ORA-03113 Error when using MS Query

Hi there,

I have an odd problem. I am trying to connect to an Oracle 8.0 database on a Vax server using a Windows 2000 pc. When  Oracle 9i client was installed I could connect to all databases in the company (versions 8.0 - 9.2). Someone then removed 9i from the pc because of some application problem and ActiveX problems (dont ask me why), and reinstalled Oracle 8i client on the pc. Now I can connect to all databases except the 8.0 database using MS Query, I receive the ORA-3113 error when trying to connect. I can still connect to all databases using sqlplus from the pc (including the 8.0 database), it is just MS Query that gives my this problem.

Any ideas?

Thanks,
J.

So I guess that you are using an ODBC connect to the Oracle DB? If so, please let me know whose driver (MS or Oracle) and what version of the driver.

-- Jason
"It's Just Ones and Zeros"

Hi,

Sorry... should have mentioned it in my post.

I am using Oracle's ODBC driver when connecting with MS QUERY, and the tnsnames.ora entries when using connecting using sqlplus.

The strange thing is that it is only failing when connecting to the 8.0 database, I can connect fine to the rest of them using ms query.

Thanks,
J.

Ok, and does the error message occur as soon as you attempt to connect? Or when you perform a query?

Have you tested the connection from within the OBDC "setup"?

-- Jason
"It's Just Ones and Zeros"

It looks like the connection is made. I can see the list of tables for the database in MS Query, but as soon as I want to select one table to query the message pops up.

I cannot see anywhere in the ODBC setup for Oracle8's ODBC driver where I can do a test, there is one in the Oracle9 ODBC driver's "setup" though.


Thanks,
J.

Hi again...

We "fixed" our problem. We removed all Oracle and MS Office software from the pc, reinstalled Oracle 9i then Office, and now it works. Must be something dodgy with Oracle8's ODBC driver, MS Query and Oracle 8.0.

Thanks for the input

J.

Man you have me stumped. Can you double check the driver version (drives tab of ODBC setup).

It sounds like you may still be using the ORA 9 ODBC driver.

It's usually "ok" to use an older driver to connect to a newer DB (use Oracle 8 client to connect to a 9 DB) but not vice versa (use a 9 driver to connect to an 8 DB)

Can you try using Microsoft's driver?

Do you have the latest version of MDAC installed?
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en

-- Jason
"It's Just Ones and Zeros"

Hi,

Think our posts overlapped .. See above post.
Thanks,
J.