Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > VB Script

Vista - ways to connect to MSSQL 2000 sever via vbscript

Reply
 
Old 01-17-2009   #1 (permalink)
rkgulati


 
 

ways to connect to MSSQL 2000 sever via vbscript

Please let me know the ways through which we can connect ot MS SQL
2000 server in VBscript. I mean we can retrive data using sql queries.
Do we have to set manually DSN on all MS SQL servers or is there a
another way?
Thanks
searching

My System SpecsSystem Spec
Old 01-18-2009   #2 (permalink)
Joe Fawcett


 
 

Re: ways to connect to MSSQL 2000 sever via vbscript


<rkgulati@xxxxxx> wrote in message
news:445901d4-f8c2-48e2-b8f1-a2fed94b10d6@xxxxxx
Quote:

> Please let me know the ways through which we can connect ot MS SQL
> 2000 server in VBscript. I mean we can retrive data using sql queries.
> Do we have to set manually DSN on all MS SQL servers or is there a
> another way?
> Thanks
> searching
No you can include the connection details in the script. Suggest you search
for at ADODB, connection and recordset online.

http://www.w3schools.com/ado/default.asp


--

Joe Fawcett (MVP - XML)
http://joe.fawcett.name

My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Ways to connect Xbox360 to my Wireless Router Network & Sharing
Exporting MsSQL table to Excel using vbScript? VB Script
Vbscript connect to ftp VB Script
Hi there I am trying to write a powershell scrip so I can connect tomy mssql servers via osql PowerShell
cannot connect to 2000 from Vista Vista networking & sharing


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46