Home » RDBMS Server » Performance Tuning » Ploblem connect oracle by Vb application
icon5.gif  Ploblem connect oracle by Vb application [message #120010] Tue, 17 May 2005 04:36 Go to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Hello ,

I using vb application to connect oracle db via odbc. Sometimes
it 's work but other times it raises the error "-2147467259 : Oracle error occurred , but error message could not be retrived form oracle" .I tried to install new mdac (2.Cool and reinstall
oracle client but it 's still error.
However i tried to test connect via odbc testing and sqlplus
it's work !!!

The example syntax as the following :

Provider=MSDAORA.1;User ID=system;Password=manager;
Data Source=database;Persist Security Info=False

os client : windows 2000 pro
oracle client : oracle 8.1.7

os server : sun solaris
db server : oracle 8.1.7

Any suggestion ?
Thanks For advance
Chara




Re: Ploblem connect oracle by Vb application [message #120022 is a reply to message #120010] Tue, 17 May 2005 06:01 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Error #: -2147467259

Reason: [Oracle][ODBC][Ora]ORA-12545: Connect failed because target host or object does not exist

Whenever this error comes, do check the status of listener and database on DB server:

Both listener and database should be up and running.
Re: Ploblem connect oracle by Vb application [message #120198 is a reply to message #120022] Wed, 18 May 2005 07:02 Go to previous messageGo to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Thanks,but when i got the error i tried to
connect db via sqlplus and check listener,database
everything is ok !!!. What happend ? and thanks for advance.

Chara
Re: Ploblem connect oracle by Vb application [message #120257 is a reply to message #120198] Wed, 18 May 2005 10:44 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
HI

One possible reason is timeout in connectivity.
Do check for continuous ping response during the time u r testing ur application connectivity with oracle.

REgds
Girish
Previous Topic: Prameters For Improving DB Perfomance
Next Topic: Statspack for 9i on 8.1.6
Goto Forum:
  


Current Time: Sun Sep 20 21:34:59 CDT 2020