Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2003

    Unanswered: MSADORA and Oracle Connection Errors

    I am developing an application that uses the MSADORA OleDB provider to connect to an Oracle8i database (Windows2K, MDAC 2.6, Oracle 8.1.7). However when I deploy this application to a client site the application will not connect.

    The client can connect with SQL Plus and with a VB Test application that uses the same connect string as my application.

    The only difference I can see between my environment and the client's is that they use Oracle Names server and I use TNS Naming for connect information to oracle.

    I have seen similar posts to this forum about connection. One referenced problems with registry not being updated after installation of MDAC. This actually did turn out to be a problem on the client machine until I had them fix the registrty. But one particular post to this forum made this comment:

    "...Furthermore, once the changes are made, the OLE DB won't work until you've connected at least once using ODBC. "

    Can this really be true?

    Has anybody else had problems connecting to Oracle using Oracle Names?

    ...this problem is killing me...somebody please help....
    Last edited by jhunterrts; 03-27-03 at 01:03.

Posting Permissions

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