DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2001
    ODBC Problem -

    I'm having Oracle 8.1.6 server. Oracle Client 8.1.6 works fine with this when installed on any client machine but when i try to connect it thro' microsoft data link using any dsn it gives error. hence, i cannot connect thro' any frontend. I've tried 8.1.5 , 7.3 but still the problem is unresolvable. sometimes it works on 7.3 ( few machines ). i'm having win95 nodes and nt server

    while using Oracle ODBC driver gives error -

    Microsoft Data Link Error - Test connection failed because error in initializing provider. Specified driver could not be loaded due to system error 1114 ( Oracle ODBC Driver )

    while using Miscrosoft ODBC for Oracle gives error -

    OCI.dll one of the library could not be found. Test connection failed.

    Can any one tell me whats happening

    [Edited by sjadhavdba on 02-26-2002 at 01:20 AM]
    Santosh Jadhav
    8i OCP DBA

  2. #2
    Join Date
    Jun 2000


    I have passed through ODBC problems before , you may change to $ORACLE_HOME/ODBC ,, you will find files concerning ODBC ,, open file named : ODBCRelnotes.wri ,, read it ,, you will find information about ODBC compitability between Server / Client / OS / Development tool .

    Try both Oracle and Microsoft ODBC Drivers , remember that ODBC can not run Oracle Packages.

    Good Luck
    Hisham Nagia
    IT Manager For Development
    Oracle Consultant - OCP

  3. #3
    Join Date
    Aug 2001
    try creating a dns using oracle odbc driver


Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.