Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Unable to connect to SQL Server
Are you trying to say that "Provider=SQLOLEDB.1" is finding different versions on different machines? OK let me check that.- shantiP
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Unable to connect to SQL Server
I am using the following code to connect to my server Set db_sql1 = New ADODB.Connection db_sql1.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & uname & ";password=" & pwd & ";Initial Catalog=CCFTEvent;Data Source=" & IPSqlServer...- shantiP
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
