All Forums >> [Scripting] >> WSH & Client Side VBScript >> VB Script Connection to SQL Server Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!
I have recently learnt how to use SQL Server. However the purpose of me learning this was to make the database under my web site a SQL server one, and not MS Access.
Can anyone advise on a good website for learning VB Script connections to SQL Server. Previously i used ADO connections to my Access ones.
' Specify connection string. This is an SQL server database on server strConnect = "DRIVER=SQL Server;Trusted_Connection=No;DATABASE=YourDatabase;SERVER=ServerName"
' Setup Recordset object and connect to database. Set adoRecordset = CreateObject("ADODB.Recordset") adoRecordset.ActiveConnection = strConnect
' Assign T-SQL statement to Source property. adoRecordset.Source = "SELECT Field1,Field2,Field3 FROM YourTable WHERE Field4=" ' Run the query and return a recordset. adoRecordset.Open
All Forums >> [Scripting] >> WSH & Client Side VBScript >> VB Script Connection to SQL Server 
Printable Version
VB Script Connection to SQL Server - 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread