Can anyone please send me some sample code for accessing sqlserver database through a vbs file.

Thanks,
vineet

Take a look at ISQL (http://msdn.microsoft.com/library/de..._isql_8r39.asp) I've used it on several projects to do the same thing.

Please send me some sample code which is easy to understand as I am new to this technology.

Thanks for your help.

What do you mean by "accessing" a SQL server? What do you want to do there?

Do you want to use a DSN, or ADO?

I use these connections to write data to SQL server. This may get you started if that is what you need:

'==========
strUserName = "yourSQLusername"
strPassword = "yourSQLpassword"
Const adOpenStatic = 3
Const adLockOptimistic = 3
Const adUseClient = 3

Set objConnection = CreateObject("ADODB.Connection")
Set objRecordset = CreateObject("ADODB.Recordset")
objConnection.Open "DSN=YourDSNName;", strUserName, strPassword
objRecordset.CursorLocation = adUseClient
objRecordset.Open "SELECT * FROM tblYourTable" , objConnection, adOpenStatic, adLockOptimistic

   objRecordset.AddNew
   objRecordset("Field1") = "YourData1"
   objRecordset("Field2") = "YourData2"
   '...
   objRecordset("Fieldn") = "YourDatan"
   objRecordset.Update

objRecordset.Close
objConnection.Close
'==========

HTH

mmcdonal

BTW, this adds one new record to "tblYourTable" in a SQL server named "YourDSNName."

mmcdonal

Sorry, with an account name of "yourSQLusername" with write access to tblYourTable", using SQL login, and a password of "yourSQLpassword."


mmcdonal

Thanks,By accessing SQL server I mean querying the database or doing some inserts and updates.

Your code helped me.