Thursday, February 16, 2012

ADO doesnt work without ODBC. Why?

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

No comments:

Post a Comment