Hi,
i'm VB beginner. Lately i try out using the ADO to retrieve data frm SQL server, but connection problem encouter when i run it.
SQL server 7 is locally installed type (local) as server name, & use Window NT Integreted security as log on to the server. (no username/passward needs)
My VB code:
Dim cnnConnection As ADODB.Connection
Set cnnConnection = New Connection
cnnConnection.ConnectionString = "Provider=sqloledb;" & _
"Data Source (local); Initial Catalog=BigBank;"
cnnConnection.Open
.........
Error:Invalid Connection String Attribute.
Any advise will be sincerely appreciated.
Regards
Chris
Problem set up connection string to SQL server (Using ADO in VB)
John Tsoi
Thks for the help.
Yat, we might familiar to see almost the SQL connection (with book reference) are "Provider=xx; Data source=(local); Intial catalog=xx; User Id=sa; Password;".
However, i found the solution for my code which tough by other pp.
You can get to below link for future reference.
Link: http://www.carlprothman.net/Default.aspx tabid=87#OLEDBProviderForSQLServer< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Best Regards
Chris
wvbotha
http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/frlrfsystemdatasqlclientsqlconnectionclassconnectionstringtopic.asp
It seems to imply that the string should look more like "Data Source=(local)" or "server=.".
Hope this helps,
Vaughn