Oracle and ODBC connection in InterDev

Hello All,

I have a slight problem with trying to connect to an Oracle 8i server. When I'm in InterDev and I try to connect to Oracle, no matter which method I use, I can never connect. It always gives the following error:

Microsoft OLE DB Provider for Oracle (0x80004005) Oracle error occurred, but error message could not be retrieved from Oracle.

The really weird part is that if I use the built in DataEnvironment, I can access the tables that I want to access. However, if I try to use the DataEnvironment object (DE), InterDev gives an error. If I try using Microsoft's ODBC driver for Oracle, I get the above error. If I try using a DSN-less connection, via the following connection string:

"Provider=MSDAORA.1;Password=*********;User ID=othergroup;Data Source=cs310.carroll.edu;Persist Security Info=True;"

I still get an error. Any help would be greatly appreciated. Thanks a bunch in advance!

Ronald Frobnitz Received on Wed Feb 20 2002 - 18:00:25 CST