Hi
I review the liecense, it is exits, this is old log, I deleted the odbcdebug and odbctrace files and create new one, when i restart virtuoso , the log created and are different
This is odbctrace.log
** iODBC Trace file
** Trace started on Mon Jan 27 14:11:43 2020
** Driver Manager: 03.52.1216.0712
[000000.000146]
virtuoso 7F2B99D28B80 ENTER SQLAllocEnv
SQLHENV * 0x198d000
[000000.000176]
virtuoso 7F2B99D28B80 EXIT SQLAllocEnv with return code 0 (SQL_SU$
SQLHENV * 0x198d000 (0x56208a0)
and this is odbcdebug.log
** OpenLink ODBC Trace file **
** started on Mon Jan 27 14:20:32 2020 **
Driver: 07.00.171020 OpenLink PostgreSQL Lite Driver
[7F34B37FE700] SQLAllocHandle
handleType=1
[7F34B37FE700] SQLAllocHandle: returning SQL_SUCCESS
[7F34B37FE700] SQLSetEnvAttr hEnv=10000
Attribute=200 ValuePtr=2 StringLength=0
[7F34B37FE700] SQLSetEnvAttr: returning SQL_SUCCESS
[7F34B37FE700] SQLAllocHandle hEnv=10000
handleType=2
[7F34B37FE700] SQLAllocHandle: returning SQL_SUCCESS
[7F34B37FE700] SQLSetConnectOption hDbc=20000
fOption=1051 vParam=18892673
[7F34B37FE700] SQLSetConnectOption: returning SQL_SUCCESS
[7F34B37FE700] SQLConnect hDbc=20000
szDSN=7F34C05946D8 cbDSN=-3 szUID=7F34C0594738 cbUID=-3 szPWD=7F34C03C9B78 cbPWD=-3
DSN=PG;UID=db-user;PWD=***
connStr=[DSN]
key=[DSN] data=[PG] supplied=1
key=[DATABASE] data=[db-name] supplied=0
key=[OPTIONS] data=[-H db-ip -P 5432] supplied=0
key=[UID] data=[db-user] supplied=1
key=[READONLY] data=[No] supplied=0
key=[SVT] data=[PostgreSQL] supplied=0
key=[FBS] data=[99] supplied=0
key=[NLB] data=[No] supplied=0
key=[DLF] data=[No] supplied=0
key=[JET] data=[Yes] supplied=0
key=[DRIVER] data=[] supplied=0
key=[NOAC] data=[No] supplied=0
key=[MAXROWS] data=[0] supplied=0
key=[INITSQL] data=[] supplied=0
key=[SQLDBMS] data=[] supplied=0
key=[NRSSL] data=[No] supplied=0
key=[MASE] data=[No] supplied=0
key=[IV] data=[No] supplied=0
key=[IA] data=[No] supplied=0
cn_svtype=[PostgreSQL]
cn_dbpath=[db-name]
cn_dbopts=[-H db-ip -P 5432]
cn_readonly=0
cn_fetchSize=99
cn_deferLongFetch=0
cn_jetfix=1
cn_noautocommit=0
cn_norowsetsizelimit=0
cn_maxrows=0
cn_appname=[VIRTUOSO]
cn_sqldbmsname=[]
SetLiteEnvironment: ServerType = PostgreSQL
SetLiteEnvironment: inifile = [openlink.ini]
cn_needbind=1
cn_hasMoreRes=1
cn_hasParamOp=1
cn_hasScrlCurs=1
cn_hasDynMixCurs=1
cn_hasV2DAE=0
cn_spOutDeferFetch=0
cn_hasExecute2=1
autocommit=0
[7F34B37FE700] SQLConnect: returning SQL_SUCCESS
[7F34B37FE700] SQLGetInfo hDbc=20000
fInfoType=23 rgbInfoValue=7F34C0593DE8 cbInfoValueMax=2 pcbInfoValue=0
[7F34B37FE700] SQLGetInfo: returning SQL_SUCCESS
[7F34B37FE700] SQLGetInfo hDbc=20000
fInfoType=24 rgbInfoValue=7F34C0593DEA cbInfoValueMax=2 pcbInfoValue=0
[7F34B37FE700] SQLGetInfo: returning SQL_SUCCESS
[7F34B37FE700] SQLGetConnectOption hDbc=20000
fOption=5011 pvParam=7F34B37F44DE
[7F34B37FE700] SQLGetConnectOption: returning SQL_ERROR
[7F34B37FE700] SQLSetConnectOption hDbc=20000
fOption=101 vParam=0
[7F34B37FE700] SQLSetConnectOption: returning SQL_SUCCESS
[7F34B37FE700] SQLGetInfo hDbc=20000
fInfoType=17 rgbInfoValue=7F34B37F4470 cbInfoValueMax=64 pcbInfoValue=0
[7F34B37FE700] SQLGetInfo: returning SQL_SUCCESS
[7F34B37FE700] SQLGetInfo hDbc=20000
fInfoType=6 rgbInfoValue=7F34B37F4470 cbInfoValueMax=64 pcbInfoValue=0
[7F34B37FE700] SQLGetInfo: returning SQL_SUCCESS
[7F34B37FE700] SQLGetInfo hDbc=20000
fInfoType=46 rgbInfoValue=7F34C059244C cbInfoValueMax=2 pcbInfoValue=0
[7F34B37FE700] SQLGetInfo: returning SQL_SUCCESS
[7F34B37FE700] SQLGetInfo hDbc=20000
fInfoType=23 rgbInfoValue=7F34C059244E cbInfoValueMax=2 pcbInfoValue=0
[7F34B37FE700] SQLGetInfo: returning SQL_SUCCESS
[7F34B37FE700] SQLGetInfo hDbc=20000
fInfoType=24 rgbInfoValue=7F34C0592450 cbInfoValueMax=2 pcbInfoValue=0
[7F34B37FE700] SQLGetInfo: returning SQL_SUCCESS
[7F34B37FE700] SQLSetConnectOption hDbc=20000
fOption=102 vParam=0
[7F34B37FE700] SQLSetConnectOption: returning SQL_SUCCESS
[7F34B37FE700] SQLGetConnectOption hDbc=20000
fOption=5011 pvParam=7F34B37F44B8
[7F34B37FE700] SQLGetConnectOption: returning SQL_ERROR
[7F34B37FE700] SQLAllocStmt hDbc=20000
phstmt=7F34C03EF478
[7F34B37FE700] SQLAllocStmt: returning SQL_SUCCESS
[7F34B37FE700] SQLGetStmtAttr hStmt=30000
Attribute=10010 ValuePtr=7F34C03C3108 BufferLength=0 StringLengthPtr=00000000
[7F34B37FE700] SQLGetStmtAttr: returning SQL_SUCCESS
[7F34B37FE700] SQLGetStmtAttr hStmt=30000
Attribute=10011 ValuePtr=7F34C03F0D88 BufferLength=0 StringLengthPtr=00000000
[7F34B37FE700] SQLGetStmtAttr: returning SQL_SUCCESS
[7F34B37FE700] SQLGetStmtAttr hStmt=30000
Attribute=10012 ValuePtr=7F34C03F0DD8 BufferLength=0 StringLengthPtr=00000000
[7F34B37FE700] SQLGetStmtAttr: returning SQL_SUCCESS
[7F34B37FE700] SQLGetStmtAttr hStmt=30000
Attribute=10013 ValuePtr=7F34C03EFF88 BufferLength=0 StringLengthPtr=00000000
[7F34B37FE700] SQLGetStmtAttr: returning SQL_SUCCESS
[7F34B37FE700] SQLTables hStmt=30000
szTableQualifier=0 cbTableQualifier=0 szTableOwner=0 cbTableOwner=0 szTableName=0 cbTableName=0 szTableType=0 cbTableType=0
Qualifier=’’ Owner=’%’ Name=’%’ Type=’’
[7F34B37FE700] SQLTables: returning SQL_ERROR
[7F34B37FE700] SQLError hStmt=30000
szSqlState=7F34B37F44D0 pfNativeError=7F34B37F44DC
szErrorMsg=7F34B37F42C0 cbErrorMsgMax=500 pcbErrorMsg=198CFE0
Returning [PostgreSQL Server] current transaction is aborted, commands ignored until end of transaction block
[7F34B37FE700] SQLError: returning SQL_SUCCESS
[7F34B37FE700] SQLError hStmt=30000
szSqlState=7F34B37F44D0 pfNativeError=7F34B37F44DC
szErrorMsg=7F34B37F42C0 cbErrorMsgMax=500 pcbErrorMsg=198CFE0
returning NO_DATA_FOUND
[7F34B37FE700] SQLError: returning SQL_NO_DATA_FOUND
[7F34B37FE700] SQLFreeStmt hStmt=30000
fOption=1
[7F34B37FE700] SQLFreeStmt: returning SQL_SUCCESS
[7F34B37FE700] SQLTransact hDbc=20000
fType=1
[Rollback]
[7F34B37FE700] SQLTransact: returning SQL_SUCCESS
[7F34C67FC700] SQLTransact hDbc=20000
fType=1
[Rollback]
[7F34C67FC700] SQLTransact: returning SQL_SUCCESS
[7F34C67FC700] SQLDisconnect hDbc=20000
[7F34C67FC700] SQLDisconnect: returning SQL_SUCCESS
[7F34C67FC700] SQLFreeHandle hDbc=20000
handleType=2
[7F34C67FC700] SQLFreeHandle: returning SQL_SUCCESS
[7F34C67FC700] SQLFreeHandle hEnv=10000
handleType=1
[7F34C67FC700] SQLFreeHandle: returning SQL_SUCCESS
** finished on Mon Jan 27 14:37:13 2020 **
** normal end **
Thanks