Connection to Pervasive SQL 2000i
461839Oct 21 2005 — edited Nov 2 2005I am trying to make a generic hs odbc connection to a non-oracle database. My Oracle is 9.2.0.6 and The database to connect to is Pervasive SQL 2000i. However, after all the setups I thought I needed I get an error:
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]Specified driver could not be loaded due to
system error 1114 (Pervasive ODBC Client Interface). (SQL State: 00000; SQL
Code: 160)
ORA-02063: preceding 2 lines from TEST
I believe I have set up everything needed: listener.ora, tnsnames.ora, have init<sid>.ora file etc. I actually have created one database link successfully to SQL Server 2000 right before this so the environment should be close to correct.
What could cause that kind of an error? What driver to use? The error is not that specific... The ODBC I have set up functions properly and test passes OK.
Any help would be great! Thanks, mp