VB 3.0 ODBC Oracle 7.1.x connectivity 
Author Message
 VB 3.0 ODBC Oracle 7.1.x connectivity

I am trying to connect to Oracle Database via ODBC.
Below is a listing of the info .

Does anyone have any clues?

Do I have the correct DLLs, Connect string. etc...

If Dlls are not the correct level, where might I get the correct versions.

I got the sqora.dll & sqorastp.dll from ora110a.exe at ftp.micrsoft.com

Thanks in advance,

-------------------------------------------------------------------
-------------------------------------------------------------------
The Error message was as follows:

ODBC--call failed. [Microsoft][ODBC DLL]
Driver's SQLSetConnectOption failed
[PageAhead][ODBC Oracle Driver]Driver not capable.
[PageAhead][ODBC Oracle Driver][Oracle OCI]ORA-09241:
Message not found ; product=RDBMS ; facility=ORA ; language=NULL. (#9241)
Number: 3146

-------------------------------------------------------------------
The dlls I am using are as follows:

-rw-rw-rw-   1 anonymou anonymou    55792 Aug 17  1994 odbc.dll
-rw-rw-rw-   1 anonymou anonymou   144096 Jul 12  1993 sqora.dll
-rw-rw-rw-   1 anonymou anonymou     9632 Jul 06  1993 sqorastp.dll
-rw-rw-rw-   1 anonymou anonymou   285573 Apr 28  1993 ora6win.dll
-rw-rw-rw-   1 anonymou anonymou   273264 Mar 23  1994 ora7win.dll

-------------------------------------------------------------------
the odbc.ini file has the following entry:
[tracking]
Driver=C:\WINDOWS\SYSTEM\sqora.dll
Description=Oracle on server
Server=T:watson:BUGS
UserId=cws
PacketSize=2048
OemToAnsi=Yes

------------------------------------------------------------------------



Sun, 23 Nov 1997 03:00:00 GMT  
 VB 3.0 ODBC Oracle 7.1.x connectivity

Quote:

>I am trying to connect to Oracle Database via ODBC.
>Below is a listing of the info .
>Does anyone have any clues?
>Do I have the correct DLLs, Connect string. etc...
>If Dlls are not the correct level, where might I get the correct versions.
>I got the sqora.dll & sqorastp.dll from ora110a.exe at ftp.micrsoft.com
>The Error message was as follows:
>ODBC--call failed. [Microsoft][ODBC DLL]
>Driver's SQLSetConnectOption failed
>[PageAhead][ODBC Oracle Driver]Driver not capable.
>[PageAhead][ODBC Oracle Driver][Oracle OCI]ORA-09241:
>Message not found ; product=RDBMS ; facility=ORA ; language=NULL. (#9241)
>Number: 3146

Have you installed the Oracle SQL*Net software on your computer? You need this
in order to talk to the Oracle DB.

Regards,

Jens R., OECD Halden reactor Project



Mon, 24 Nov 1997 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. VB-ODBC-Oracle connectivity....

2. VB-ADO-ODBC-Oracle connectivity

3. ADO+ODBC+Oracle Connectivity problem in VB on Win98

4. GPF : VB 3.0 / MS-Jet 2.5 / ODBC 2.11 / Oracle 7.1

5. Transactions using VB 3.0/ODBC Q+E/Sql*NET TCP-IP/Oracle 7

6. Help with Oracle/VB connectivity

7. VB/Oracle Connectivity

8. VB Windows -> Oracle (UNIX) Connectivity

9. Oracle 7.3.3 Connectivity With CR/VB

10. Connectivity To oracle from Vb

11. Oracle connectivity from VB

12. Vb connectivity to ORACLE

 

 
Powered by phpBB® Forum Software