Conference orarep::nomahs::odbc_rdb_driver

1321.0. "Driver not capable + SQL-F-RELNOTDEF ?" by 8292::PJACOB (Patrick [email protected]) Tue Apr 01 1997 13: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
...

    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