Home » Infrastructure » Windows » Problem connect oracle db with vb via odbc
icon5.gif  Problem connect oracle db with vb via odbc [message #120011] Tue, 17 May 2005 04:50 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: Problem connect oracle db with vb via odbc [message #120026 is a reply to message #120011] Tue, 17 May 2005 06:50 Go to previous messageGo to next message
Maaher
Messages: 7064
Registered: December 2001
Senior Member
Have you tried using the Oracle ODBC drivers?

MHE
Re: Problem connect oracle db with vb via odbc [message #120027 is a reply to message #120011] Tue, 17 May 2005 06:57 Go to previous message
chara
Messages: 81
Registered: April 2005
Location: th
Member
I tried but it not work !
Previous Topic: Problem In SQL* Loader with Win2000 Professional
Next Topic: Problem Installing Oracle on Win 2000 Server
Goto Forum:
  


Current Time: Mon Aug 15 08:56:58 CDT 2022