[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | DEC ODBC Driver |
| Notice: | DEC ODBC Driver V2.0 Now Available |
| Moderator: | SQLSRV::MAVRIS |
|
| Created: | Tue Dec 29 1992 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1357 |
| Total number of notes: | 4864 |
1321.0. "Driver not capable + SQL-F-RELNOTDEF ?" by 8292::PJACOB (Patrick JACOB-pjacob@fr.oracle.com) Tue Apr 01 1997 16:17
A customer is having a problem accessing to Rdb from his PC through Access and
ODBC. Approximatively 1 time every 4 accesses, the PC hangs and a reboot is
necessary:
client : Windows 3.11 Access 2.0 ODBC Rdb 2.10.11
server : VAX/VMS 6.2 SQL/Services 6.1-01 Rdb 6.1-01
On the Oracle ODBC Driver Connect for Rdb window, he specifies the server, the
class, the user name, the password and the attach statement. On the database
window he selects a table ( named GRILLE_MATRA ).
The title bar "Table: GRILLE_MATRA" is displayed with the various lifts, but
the remaining screen is white and the PC is hung. I told to the customer to
enable logging ( Driver Logging=7 and Client Logging=7 in WIN.INI ). We found
the following talking about
[Oracle][ODBC]Driver not capable
and
[Oracle][ODBC][Rdb]%SQL-F-RELNOTDEF, Table MSYSCONF is not defined in
database or schema
I don't know if it is related but sometimes, he has the Microsoft Access screen
displaying the following error message:
ODBC Specification Conformance Error(-7713).
This error should be reported to the ODBC driver
vendor.
Any help should be appreciated.
Patrick
Driver log:
===========
...
SQLSetStmtOption 0X6D970000
...._rcSQLSetStmtOption 0X00000004
......SQL Error Code = 0X00001006
......Native Error Code= 0X00000000
......S1C00Driver not capable. 0X00000000
SQLError 0X00000000
[Oracle][ODBC]Driver not capable.
SQLError 0X00000000
SQLExecDirect 0X6D970000
...._rcSQLPrepare 0X6D970000
....0X6D970000: SELECT Config, nValue FROM MSysConf
......SQL Error Code = 0X00001029
......Native Error Code= 0XFFFFFBEF
....%SQL-F-RELNOTDEF, Table MSYSCONF is not defined in database or schema
SQLError 0X00000000
[Oracle][ODBC][Rdb]%SQL-F-RELNOTDEF, Table MSYSCONF is not defined in
database or schema
SQLError 0X00000000
SQLFreeStmt 0X6D970000
...._rcSQLFreeStmt 0X6D970000
...._StmtDestroy 0X6D970000
SQLAllocStmt 0X6DD70000
SQLGetStmtOption 0X6D770000
....Option 0X00000000
SQLGetStmtOption 0X6D770000
....Option 0X00000004
SQLSetStmtOption 0X6D770000
...._rcSQLSetStmtOption 0X00000004
......SQL Error Code = 0X00001006
......Native Error Code= 0X00000000
......S1C00Driver not capable. 0X00000000
SQLError 0X00000000
[Oracle][ODBC]Driver not capable.
SQLError 0X00000000
SQLExecDirect 0X6D770000
...._rcSQLPrepare 0X6D770000
....0X6D770000: SELECT GRILLE_MATRA.GRP_CL,GRILLE_MATRA.NUM_POSTE FROM GRI
....LLE_MATRA
...._rcSQLExecDirect 0X6D770000
...._rcSQLExecute 0X6D770000
...._sOpenCursor 0X6D770000
SQLFetch 0X6D770000
...._rcSQLFetch 0X00000000
SQLGetData 0X6D770000
...._rcSQLGetData 0X6D770000
....dbgetdata 0X00000001
....uCnvConvert 0X6D8F3E20
SQLGetData 0X6D770000
....
and later on :
SQLSetStmtOption 0X6C7F0000
...._rcSQLSetStmtOption 0X00000004
......SQL Error Code = 0X00001006
......Native Error Code= 0X00000000
......S1C00Driver not capable. 0X00000000
SQLError 0X00000000
[Oracle][ODBC]Driver not capable.
SQLError 0X00000000
SQLGetStmtOption 0X6C7F0000
....Option 0X00000001
SQLSetStmtOption 0X6C7F0000
...._rcSQLSetStmtOption 0X00000001
SQLExecDirect 0X6C7F0000
...._rcSQLPrepare 0X6C7F0000
....0X6C7F0000: SELECT CATEGORIE,BAT,BUREAU,CLASSE_SERVICE,CLIENT,CODE_SEC
....,COMMU,FAC,FILTRAGE,FONCTION_GROUPE,GROUPEMENT,GRP_CL,NOM_CLIENT,NUM_P
....OSTE,NU_GROUPE,NU_SERIE,SERV_PAYS,PE_NU,PRENOM,REMARQUE,TITRE,TYPE_GRO
....UPE,TYPE_POSTE,MES_VOC FROM GRILLE_MATRA
...._rcSQLExecDirect 0X6C7F0000
...._rcSQLExecute 0X6C7F0000
...._sOpenCursor 0X6C7F0000
SQLFetch 0X6C7F0000
...._rcSQLFetch 0X00000000
SQLGetData 0X6C7F0000
...._rcSQLGetData 0X6C7F0000
....dbgetdata 0X00000001
....uCnvConvert 0X6D8F87D2
etc...
We get quite the same in client.log. If it matters, I should say that it talks
about Oracle Sql/Services Version 7.00.
client.log:
==========
...
PROTOCOL LEVEL LOG CLIENT: read at 16:54:31 on 24-Mar-1997
----PACKET ID: 3, PACKET SEQUENCE: 0
--------ERROR AC......SQL Error Code = 0X00001029
......Native Error Code= 0XFFFFFBEF
....%SQL-F-RELNOTDEF, Table MSYSCONF is not defined in database or schema
SQLError 0X00000000
[Oracle][ODBC][Rdb]%SQL-F-RELNOTDEF, Table MSYSCONF is not defined in
database or schema
...
| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 1321.1 | network config? | M5::JBALOGH | | Tue Apr 01 1997 17:19 | 19 |
| The driver not capable and relnotdef messages can be ignored.
If the PC is hanging, I doubt you will see an error message in any of
the logs.
Many times when we see this symptom, it is caused by a network config
issues on the PC. This is especially true with Win 3.1. I know
specificly of a problem where MS TCP/IP would hang on large queries.
This was on old versions of Microsoft TCP/IP and I don't know if/when
it was fixed (by Microsoft).
Other things you could look for include checking the comm server log
file for any errors around this time of the PC hang and also check the
execute server for this connection to ensure it isn't hung or running a
long query.
Sounds like a network issue on the PC to me...
John
|