Unanswered: PL/SQL works on one machine but not on another
I´ve implemented in my application a code that gets information from a PL/SQL procedure that is written on a Oracle database.
Everything works fine when I run my application on the machine (let´s call it A) I´m developing the application on but when I move the .exe to a server (let´s call it B) I start getting the following error:
The application uses ADO components to connect to Oracle.
The difference between those two machines is:
A: Win NT
B: Win 2000
A: ADO driver 2.60.6526.0
B: ADO driver 2.61.7326.0
I got the error as well when B had an earlier version of the driver installed so I upgraded the driver on B to the one mentioned above but the same error still comes up with the updated driver.
B: VB not installed since it is a server.
Does anyone know a solution to this one ?????
Please help .... because I´m completly lost in this one.
The fact that you are getting an ODBC error would lead me to believe that you have a conflicting odbc entry, or you are using the ODBC driver unintentionally. Make sure that you are not using the OLE DB provider for ODBC.