connecting to a server

Hi Folk
Can you tell me how I can connect to an SQL server using a vbscript?
Basically, I want to do the following:
..define array of sql statements (e.g. select * from customers,
selec...)
..connect to databsae
..run sql statements to extract files
..ftp extracted files (csv) to webserver
Can someone tell me if VB script is a good option for this or if I
should be using something else. I just want to keep it simple and I
have limited experience in programming for VBscript.
What do you think about using an access database?
Thanks
NicolaasOne option is to just use ADO in the VBScript.
You might also be able to do what you are trying to do using
jobs or DTS/SSIS. Whether you just used a job and SQL
statements or not depends on the "extract files" and what is
needed in those.
I guess you could use Access but if you don't actually need
to use any data in Access and it isn't a part of an Access
application, I don't see much benefit in that approach.
-Sue
On 17 Jul 2006 05:20:46 -0700, "windandwaves"
<nfrancken@.gmail.com> wrote:

>Hi Folk
>Can you tell me how I can connect to an SQL server using a vbscript?
>Basically, I want to do the following:
>..define array of sql statements (e.g. select * from customers,
>selec...)
>..connect to databsae
>..run sql statements to extract files
>..ftp extracted files (csv) to webserver
>Can someone tell me if VB script is a good option for this or if I
>should be using something else. I just want to keep it simple and I
>have limited experience in programming for VBscript.
>What do you think about using an access database?
>Thanks
>Nicolaas

connecting SQL

I am trying to define a connection to a remote SQL, although the server is installed localy. can I try to connect via IP (as a remote client) even though the server is on my local machine ?

thanks,

dror

You can do that. For instance, you can use osql.exe to connection a local instance as:

osql -E -Stcp:.\<instance>,<portnumber>

For Yukon, the portnumber is 1433. Also the link (http://support.microsoft.com/kb/265808) tells you how to find out a port for all versions of SQL Server.

Thanks,

Junfeng