connection failed: -2147467259 -[Microsoft][ODBC d

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

connection failed: -2147467259 -[Microsoft][ODBC d

Author

Topic

sponguru_dba
Yak Posting Veteran

93 Posts

Posted - 2006-02-09 : 00:03:05

Hi All

connection failed: -2147467259 -[Microsoft][ODBC driver for Oracle][Oracle]

Iam getting this problem in my VB application,i know this is Microsoft ODBC driver for Oracle(MCORCL32.DLL) problem,but my system having that file,if suppose the DLL corrept how to replace or Test that MCORCL32.DLL file

Can some body help me

Thanks in Advance
Sreenivas

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-02-09 : 00:13:10

I think this error indicates a timeout.

look at changing the CommandTimeout property. Google that for info.

ALso, if you are connecting to oracle, you need to have the oracle client installed as well as a tnsnames.ora file. Just having the ODBC or OLEDB driver is not good enough.

if you can tnsping your oracle database then you have the oracle client and a tnsnanmes.ora file installed.

-ec

sponguru_dba
Yak Posting Veteran

93 Posts

Posted - 2006-02-09 : 01:10:05

Thanks eyechart

I have both Oracle Server and Application in one mechine..and checked the tnsname.ora having all information of connection string

so, no problem with tnsname.ora

sponguru_dba
Yak Posting Veteran

93 Posts

Posted - 2006-02-10 : 02:34:06

Hi From where can i get the Micorsoft ODBC Drivers for Oracle

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources