Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002

    Unanswered: ADO doesn't 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;DATA BASE=Etiquetas;Server=BROMO;"
    "driver={SQL SERVER};UID=Etiquetas;PWD=xxxxxxxx;DATABASE=Etique tas;Server=BROMO;"

  2. #2
    Join Date
    Nov 2002
    San Francisco

    Re: ADO doesn't work without ODBC. Why??

    ADO is high level or top layer for OLE DB, it can handle ODBC too cauze Microsoft OLE DB Provider for ODBC drivers

    see for tons of connection samples....

    OLE DB is generally faster than ODBC....


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts