I’m truing to connect to an Oracle Database and I’m getting the dabase exception message
Some Oracle symbols are not found. Look in the console for more information.
Here is my connection code with the connection info intentionally obscured
Var db As New OracleDatabase
db.DatabaseName = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=************)(PORT=****))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=********)))"
db.UserName = "*****************"
db.Password = "**********"
db.Debug = 1
Try
db.Connect
MessageBox("Connected to Oracle!")
Catch error As DatabaseException
MessageBox("Error connecting to Oracle: " + error.Message)
End Try
I have also tried using the MBS SQL plugin and I get a different message
C:\oracle\product\11.2.0\client_1\bin\oci.dll: %1 is not a valid Win32 application.
DBMS API Library loading fails
This library is a part of DBMS client installation, not SQLAPI++
Make sure DBMS client is installed and
this required library is available for dynamic loading
I’ve searched the Forum, but all I come up with is solutions for Mac users. Anyone here connecting to Oracle via Windows that can offer some help?