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

    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;"
    or
    "driver={SQL SERVER};UID=Etiquetas;PWD=xxxxxxxx;DATABASE=Etique tas;Server=BROMO;"

  2. #2
    Join Date
    Nov 2002
    Location
    San Francisco
    Posts
    251

    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 http://www.able-consulting.com/tech.htm for tons of connection samples....


    OLE DB is generally faster than ODBC....



    jiri

Posting Permissions

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