OraFAQ Forum: Performance Tuning » Ploblem connect oracle by Vb application

Home » RDBMS Server » Performance Tuning » Ploblem connect oracle by Vb application

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Ploblem connect oracle by Vb application [message #120010]

Tue, 17 May 2005 04:36

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

Report message to a moderator

Re: Ploblem connect oracle by Vb application [message #120022 is a reply to message #120010]

Tue, 17 May 2005 06:01

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.

Report message to a moderator

Re: Ploblem connect oracle by Vb application [message #120198 is a reply to message #120022]

Wed, 18 May 2005 07:02

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

Report message to a moderator

Re: Ploblem connect oracle by Vb application [message #120257 is a reply to message #120198]

Wed, 18 May 2005 10:44

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

Report message to a moderator

Previous Topic:	Prameters For Improving DB Perfomance
Next Topic:	Statspack for 9i on 8.1.6

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 04:07:54 CST 2025