Opening Oracle 7.3 database via ODBC in VB4

Opening Oracle 7.3 database via ODBC in VB4

Post by Robbert de GROO » Sat, 31 Jan 1998 04:00:00



When trying to open a Oracle 7.3 database via ODBC, while being in the VB4
16-bits development environnement (running under Windows 95 r2), using the
OpenDatabase command, we trapped the following error messages:

5 erreurs :
- 0:[Microsoft][ODBC DLL] Driver's SQLSetConnectOption failed
- 0:[Oracle][ODBC Oracle Driver]Driver not capable.
- 12154:[Oracle][ODBC Oracle Driver][Oracle OCI]Error while trying to
retrieve text for error ORA-12154.
- 0:[Oracle][ODBC Oracle Driver]Invalid Connection string Attribute.
- 3146:ODBC--call failed.

But when we compile the code, accessing the same database works fine. We've
observed that if we take the code to open the Oracle database into a new VB
project, while being in the development environnement, accessing the Oracle
database doesn't seem to be a problem.

What is happening ?? Is there a limit of controls (VBX/OCX) that VB4 can
handle ? Is there a conflict between the controls loaded and the ORACLE
ODBC 16-bit driver ??

Any help is welcome.

Robbert de GROOT / Farid GOUGAM
SGIP/CREDOME

 
 
 

1. Opening Oracle 7.3 database via ODBC (16bits) with VB4 16-bits development environnement

When trying to open a Oracle 7.3 database via ODBC (16bits), while being in
the VB4 16-bits development environnement (running under Windows 95 r2),
using the OpenDatabase command, we trapped the following error messages:

5 erreurs :
  - 0:[Microsoft][ODBC DLL] Driver's SQLSetConnectOption failed
  - 0:[Oracle][ODBC Oracle Driver]Driver not capable.
  - 12154:[Oracle][ODBC Oracle Driver][Oracle OCI]Error while trying to
retrieve text for error ORA-12154.
  - 0:[Oracle][ODBC Oracle Driver]Invalid Connection string Attribute.
  - 3146:ODBC--call failed.

BUT when we compile the code, accessing the same database works fine?!?!?!
!??????  We've observed that  if we take the code to open the Oracle
database (OpenDatabase) into a new VB project, while being in the
development environnement, accessing the Oracle database doesn't seem to be
a problem.

What is happening ?? Is there a limit of controls (VBX/OCX) that VB4 can
handle ? Is there a conflict between the controls loaded and the ORACLE
ODBC 16-bit driver ??

Any help is welcome.

Robbert de GROOT / Farid GOUGAM
SGIP/CREDOME

2. how do I drag from a DbGrid?

3. Cannot Connect To ORACLE 7.3 via ODBC and CDataBase

4. WJ0470 Pick P/A - Manufacturing

5. Connection Oracle 7.3 via ODBC

6. The transactions are blocked!

7. SQL7 to ORACLE 7.3 via ODBC - Advice Needed

8. problem with Recordset deleting

9. I need help connecting Personal Oracle 7.3 to Delphi 3 via ODBC

10. connection ASP - Oracle 7.3 via ODBC?

11. Help: Connection to Oracle 7.3 via ODBC/JET/DAO

12. Oracle 7.3 Time Field to SQL 7.0 via ODBC

13. Connecting to Oracle via Oracle ODBC driver from VB4