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

[paulnamroud]

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

 

[Sheco]

Any chance the code uses a DSN defined on the old server but not on the new? Or does it use a connection string?

 

[johnwm]

I note you are new to forums. It may be worth reading faq222-2244 and

http://www.catb.org/~esr/faqs/smart-questions.html

to see how these forums (and forums in general) work best

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints