Oracle7 + 32 bit ODBC killing me!!!!

Thanks for reading.
I need some help please.
I set up some VB code to extract data from Access 97 and update data in Oracle 7.
It worked fine with Oracle 7 32bit ODBC Driver 2.0.3.1.1. I needed to rebuild the client machine and couldn't get hold of the above mentioned driver so I downloaded latest Oracle7 32bit ODBC Driver 2.5.3.1.0B. My application fails with the message that it couldn't find

the table and I should check it's name is spelt correctly. I then pop up a SQL*Plus window and issue the same SQL command with no problems. It appears to have lost it's connection in some way. My questions are: 1. Because my server is running 2.0.3.1.1 and my client 2.5.3.1.0B could this cause the problem (I can't afford to remove the server ODBC driver as it's the only one that works). I believe my client ODBC data source only needs to know the database alias/connect string and doesn't rely on any server side ODBC.
2. SQL*Plus session works ok so I'm satisfied with the revs of SQL*net

and SQL*Plus though they are different. 3. How do I get the 2.5.3.1.0B driver working? 4. Does anybody know how I can get hold of the 2.0.3.1.1 driver.

I'm in desperate need of a quick reply as I have to demonstrate this application at University in a couple of days. Received on Sun Jan 31 1999 - 15:57:47 CST