Re: Oracle7 + 32 bit ODBC killing me!!!!

Hello !

Ask oracle for the patch. The thing that you can download programs from oracle dosn't quarantee that they work.

Aarre Heikkilä

On Sun, 31 Jan 1999 21:57:47 +0000, A J Hirst <ahirst_at_abigail.demon.co.uk> wrote:

>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 Mon Feb 01 1999 - 01:18:16 CST