
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
------------------------------------------------------------------------