Can any one tell me whats happening
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Can any one tell me whats happening

  1. #1
    Join Date
    Dec 2001
    Posts
    221
    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
    Posts
    179

    Talking

    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
    Location
    chennai,bangalore
    Posts
    840
    try creating a dns using oracle odbc driver

    cheese
    anandkl
    anandkl

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