Results 1 to 2 of 2

Thread: server.createobject(ADODB.Connection)

  1. #1
    Join Date
    Dec 1969

    Default server.createobject(ADODB.Connection)

    In one of the books author has mentioned that server.createobject(ADODB.Connection) calls ODBC or OLEDB based on provider mentioned in connection string.<BR><BR>In another book author has mentioned that ADO always goes to OLEDB.<BR><BR>I&#039;m little bit confused here. How do I know whether ADODB.Connections calls ODBC or OLEDB ?

  2. #2
    Join Date
    Dec 1969

    Default RE: server.createobject(ADODB.Connection)

    depends on the connectionstring. if you use DSNs or a driver string, you&#039;re calling ODBC, which in turn uses OLEDB. if you use an OLEDB connectionstring, you call OLEDB directly, avoiding the ODBC layer. this method is the most efficient of the three.<BR><BR>ADO is the package containing all this data access technology<BR><BR>j<BR>

Posting Permissions

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