Problem installing a VB ADO Oracle App. 1

[WP]

Hi,

Trying to install my VB App. which uses an Oracle db and having a problem that I cannot solve.

When it trys ro connect with:

objOracleADOConn.Open "Provider=msdaora; Data Source=" & gstrOracleSystem & ";" & _
"User Id=" & gstrOracleUser & "; Password=" & _
gstrOraclePwd & ";"

I get an error message

Oracle error occurred but message could not be retrieved from Oracle.

The app runs ok on my development box. All parameters are being filled properly.

Can anyone help ?

Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out

http://www.deepturtle.ch

 

[subhavs]

WP,

What kind of deployment package are you using to distribute the software ?

Also, are the operating systems on the both the development machine and the deployed machine the same ?

- Subha Nothing is impossible, even the word impossible says I'm possible.

 

[WP]

Subha,

Using VB's software. Both operating systems are NT 4.0.

Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out

http://www.deepturtle.ch

 

[SLAbel]

Hello,

I had this problem also. Apparently some registry settings are incorrect or missing. See the following Knowledgebase article. It corrected my problem.

Q264012 - PRB: Connectivity Issue with MDAC and Oracle8i

http://support.microsoft.com/support/kb/articles/Q264/0/12.ASP

Hope this helps some others.

In His Love
scott

 

[Giorgi]

THAK YOU VERY MUCH! I've had this problem for a monthes and couldn't resolve. Thanks God now I can sleep quitely.