ODBC for Oracle 8i Driver could not be loaded 1

[mcgibbong]

I have just downloaded the ODBC driver for Oracle 8i from the Oracle site and installed it on NT. I am using the Oracle client 8.1.7.0.0 and the odbc was 8.1.7.4.
In the ODBC driver configuration test connection, I get the message 'SQLSTATE=lM003 Specified driver could not be loaded due to a system error 127 (Oracle in DEFAULT_HOME). I have put the oracle home directory into the path. I have checked the web and the answer seems to be that there are either some dlls missing or out of date. Can anyone help or be more specific?

Thanks

Gary

 

[sem]

Have you put %oracle_home%\bin to the PATH?

Regards, Dima

http://seminihin.narod.ru

 

[mcgibbong]

Thanks Dima,

I have already put this into the path.

 

[sem]

Do you have multiple homes installed?

Regards, Dima

http://seminihin.narod.ru

 

[mcgibbong]

Yes i do.

 

[sem]

Try to point ORACLE_HOME environment variable to the home where both 8.1.7 client and ODBC driver are located.

Regards, Dima

http://seminihin.narod.ru

 

[mcgibbong]

Dima, You're a star!! I put the odbc into the same oracle home as has the client and it works perfectly.

Thanks a lot.

gary