In my application VB, I am effecting the connection with the SQL Server it saw connection string, without ODBC, thus does not function.
I need to create any ODBC connection to complete the connection. Why?
My Connection string:
"provider=SQLOLEDB;UID=Etiquetas;PWD=xxxxxxxx;DATAB ASE=Etiquetas;Server=BROMO;"
or
"driver={SQL SERVER};UID=Etiquetas;PWD=xxxxxxxx;DATABASE=Etique tas;Server=BROMO;"ADO is high level or top layer for OLE DB, it can handle ODBC too cauze Microsoft OLE DB Provider for ODBC drivers
see http://www.able-consulting.com/tech.htm for tons of connection samples...
OLE DB is generally faster than ODBC...
jiri
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment