troubleshooting Question

Urgent - 2147467259: [Microsoft] [ODBC driver for Oracle] [Oracle].

Avatar of paulnamroud
paulnamroud asked on
Oracle DatabaseASP
3 Comments1 Solution1575 ViewsLast Modified:
Hi guys,

I need your help!!!!

I have installed and configured a new server called "intranetnew" in order to replace the old server "intranet."

With the new server, i'm able to connect to Oracle and do SQL queries using the SQL-Plus.

However, when i try to connect to Oracle via a test page written in ASP, the following error message appears on the screen "2147467259: [Microsoft] [ODBC driver for Oracle] [Oracle]."

While the same test page (same code) is 100% functional on the old machine intranet

The only thing I could see is the version of Microsoft ODBC driver for Oracle installed on the two servers.

On the old server (intranet) the installed version of the driver is "2.573.4202.00 with MDAC 2.6, whereas on the new server (intranetnew) the installed version of this driver is "2.576.1830.00" with MDAC 2.8.

Do you have an idea for solving this problem?
Thank you very much for your help!

By the way, we are using Oracle Database 8.1.7.

Paul
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros