3/31/2015 5:56:42 PM;troy;appuser.SetupUser;Set work directory: E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\workfiles;;;;;;;
3/31/2015 5:56:42 PM;troy;appuser.SetupUser;Set query directory: E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\Queries;;;;;;;
3/31/2015 5:56:42 PM;troy;appuser.GetQuery;troy;Query queryautodb: Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;;;;;;
3/31/2015 5:56:42 PM;troy;appuser.GetQuery;Query queryautodb: Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;;;;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=19;AllocStmt;15725312;;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=19;SetAsyncMode;0;;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=19;ExecDirect;unicode=False;Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=19;ExecDirect;rc=0;;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=19;GetNumRows;rc=0;numrows=0;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=19;GetColInfo; NumCols=1;;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=19;Bindcols;colno=1,Database,type=12,bind=C,prec=50,buflen=51;;Tot bytes alloc=55;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=19;Fetch started;;;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=19;Fetch reached end after 0 rows;;;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=19;SQLDiagRec;FetchOne;0;SQLState=;;;
3/31/2015 5:56:42 PM;troy;GetDataColl;Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;rows=0;cols=1;elapsed=0.02;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=19;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.0156257 Prepare=0 ExecDirect=0 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
3/31/2015 5:56:43 PM;troy;dbsignon - page load;;;;;;;;
3/31/2015 5:56:43 PM;troy;dbsignon > loadsignons;;;;;;;;
3/31/2015 5:56:43 PM;troy;appuser.GetQuery;troy;Query querydblist: Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;;;;;;
3/31/2015 5:56:43 PM;troy;appuser.GetQuery;Query querydblist: Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;;;;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=20;AllocStmt;707324144;;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=20;SetAsyncMode;0;;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=20;ExecDirect;unicode=False;Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=20;ExecDirect;rc=0;;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=20;GetNumRows;rc=0;numrows=2;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=20;GetColInfo; NumCols=10;;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=20;Bindcols;colno=1,Database,type=12,bind=C,prec=50,buflen=51;colno=2,Description,type=12,bind=C,prec=100,buflen=101;colno=3,ReadOnly,type=1,bind=C,prec=1,buflen=2;colno=4,NeedsUserPass,type=1,bind=C,prec=1,buflen=2;colno=5,DatabaseType,type=1,bind=C,prec=1,buflen=2;colno=6,CfgFile,type=12,bind=C,prec=20,buflen=21;colno=7,ShowReports,type=1,bind=C,prec=1,buflen=2;colno=8,ShowDatabase,type=1,bind=C,prec=1,buflen=2;colno=9,ShowSQL,type=1,bind=C,prec=1,buflen=2;colno=10,ShowFiles,type=1,bind=C,prec=1,buflen=2;;Tot bytes alloc=227;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=20;Fetch started;;;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=20;Fetch reached end after 2 rows;;;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=20;SQLDiagRec;FetchOne;0;SQLState=;;;
3/31/2015 5:56:43 PM;troy;GetDataColl;Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;rows=2;cols=10;elapsed=0.02;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=20;CloseQuery;Query statistics: Fetches=2 GetData=0 Elapsed=0.0312498 Prepare=0 ExecDirect=0 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
3/31/2015 5:56:43 PM;troy;aqtdbsignon > SetUpDsnSignons: dbSignonColl collection = 0;;;;;;;;
3/31/2015 5:56:43 PM;troy;appuser.GetQuery;troy;Query queryselrecent: Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;;;
3/31/2015 5:56:43 PM;troy;appuser.GetQuery;Query queryselrecent: Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=21;AllocStmt;707324144;;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=21;SetAsyncMode;0;;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=21;ExecDirect;unicode=False;Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=21;ExecDirect;rc=0;;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=21;GetNumRows;rc=0;numrows=2;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=21;GetColInfo; NumCols=7;;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=21;Bindcols;colno=1,Database,type=12,bind=C,prec=50,buflen=51;colno=2,Userid,type=12,bind=C,prec=50,buflen=51;colno=3,DBName,type=12,bind=C,prec=50,buflen=51;colno=4,OraclePriv,type=12,bind=C,prec=50,buflen=51;colno=5,Description,type=12,bind=C,prec=100,buflen=101;colno=6,ReadOnly,type=1,bind=C,prec=1,buflen=2;colno=7,EncryptedPwd,type=12,bind=C,prec=50,buflen=51;;Tot bytes alloc=386;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=21;Fetch started;;;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=21;Fetch reached end after 2 rows;;;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=21;SQLDiagRec;FetchOne;0;SQLState=;;;
3/31/2015 5:56:43 PM;troy;GetDataColl;Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;rows=2;cols=7;elapsed=0.03;;;;
3/31/2015 5:56:43 PM;db=1=;stmt=21;CloseQuery;Query statistics: Fetches=2 GetData=0 Elapsed=0.0312474 Prepare=0 ExecDirect=0 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
3/31/2015 6:17:40 PM;troy;Logging off AQT due to Timeout;;;;;;;;
3/31/2015 6:17:40 PM;troy;appuser.GetQuery;phil;Query querysessionlog: Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'phil', '<LogData>');;;;;;
3/31/2015 6:17:40 PM;troy;LogSessionStatus: Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'phil', 'Logoff due to session timeout');;;;;;;;
3/31/2015 6:17:40 PM;db=1=;stmt=22;AllocStmt;15621992;;;;;
3/31/2015 6:17:40 PM;db=1=;stmt=22;SetAsyncMode;2;;;;;
3/31/2015 6:17:40 PM;db=1=;stmt=22;ExecDirect;unicode=False;Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'phil', 'Logoff due to session timeout');;;;
3/31/2015 6:17:40 PM;db=1=;stmt=22;ExecDirect;rc=0;;;;;
3/31/2015 6:17:40 PM;db=1=;stmt=22;GetNumRows;rc=0;numrows=1;;;;
3/31/2015 6:17:40 PM;db=1=;stmt=22;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.015627 Prepare=0 ExecDirect=0 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
3/31/2015 6:17:40 PM;troy;-------------------- Session Ends due to session timeout--------------------;;;;;;;;
3/31/2015 6:17:40 PM;troy;Processing error at SessionTimedOut Object reference not set to an instance of an object. ;;;;;;;;
3/31/2015 6:17:40 PM;troy;Logging off AQT due to Timeout;;;;;;;;
3/31/2015 6:17:40 PM;troy;appuser.GetQuery;troy;Query querysessionlog: Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'troy', '<LogData>');;;;;;
3/31/2015 6:17:40 PM;troy;LogSessionStatus: Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'troy', 'Logoff due to session timeout');;;;;;;;
3/31/2015 6:17:40 PM;db=1=;stmt=23;AllocStmt;15621992;;;;;
3/31/2015 6:17:40 PM;db=1=;stmt=23;SetAsyncMode;2;;;;;
3/31/2015 6:17:40 PM;db=1=;stmt=23;ExecDirect;unicode=False;Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'troy', 'Logoff due to session timeout');;;;
3/31/2015 6:17:40 PM;db=1=;stmt=23;ExecDirect;rc=0;;;;;
3/31/2015 6:17:40 PM;db=1=;stmt=23;GetNumRows;rc=0;numrows=1;;;;
3/31/2015 6:17:40 PM;db=1=;stmt=23;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.0312499 Prepare=0 ExecDirect=0.0312499 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
3/31/2015 6:17:40 PM;troy;-------------------- Session Ends due to session timeout--------------------;;;;;;;;
3/31/2015 6:17:40 PM;db=1=;Disconnect;rc=0;;;;;;
3/31/2015 6:17:40 PM;;Processing error at SessionTimedOut Object reference not set to an instance of an object. ;;;;;;;;
4/14/2015 5:58:00 PM;aqtdb path=C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\aqtweb\0e6c774c\e7062279\assembly\dl3\16733391\7b8e989b_fc2ccf01\aqtdbinterface.dll;;;;;;;;
4/14/2015 5:58:00 PM;aqtdb version=C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\aqtweb\0e6c774c\e7062279\assembly\dl3\16733391\7b8e989b_fc2ccf01\aqtdbinterface.dll;1.0.4884.37408;32-bit mode;;;;;;;;
4/14/2015 5:58:00 PM;troy;-------------------- Session Starts --------------------;;;;;;;;
4/14/2015 5:58:00 PM;troy;Options;UseDSNConnections=y,ShowFavOnStart=n,ODBCMode=n,SupportAS400SysNamingConvention=n,NewTab=y,MenuStyle=Windows7,ToolbarStyle=Windows7,MultQueries=n,MultQueries2=n,MultQueriesBlankRow=y,AutoSaveQueries=n,Delimiter=;,RemoveComments=y,EnableUserParms=y,UserParmChar=$,MaxRows=1000,MaxColSize=1000,ShowGroupBy=y,ShowRowNumbers=n,RightTrim=y,NullFormat=(null),ShowVarcharLen=n,DateFormatV9=yyyy-MM-dd,TimeFormatV9=HH:mm:ss,DateFormatInformixV9=yyyy-MM-dd,TimeFormatInformixV9=HH:mm:ss,ShowZeroTime=n,ShowRowID=n,BinaryDisplay=2,ConvertEBCDIC=n,WriteBlobsToFiles=y,ShowBlobs=y,ShowClobs=y,ShowVarchar=n,ExcludeBLOBs=n,AsyncMode=2,QuoteNames=n,UncommittedRead=y,UseParms=n,AutoCommit=y,CommitAfterEachQuery=n,UseExecDirect=n,UnicodeMode=y,UnicodeCols=n,BindColsToStrings=n,UseGetDataAll=n,DeferredPrepare=n,ContinueOnFetchError=n,IDMSAccessCode=,IDMSAccessPlan=,ShowAllCons=n,ShowDNSCons=y,HistFile=aqt_history.txt,HistDiffName=n,HistIncScript=n,HistIncUpd=n,HistIncSearch=n,AuditEnabled=n,AuditDir=\audit,AuditFile=aqt_audit_yyyymmdd.txt,AuditSepFiles=n,AuditSelectStatements=n,AuditQueryResults=n,AuditRows=50,AuditRowLength=1000,DefDir=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\workfiles,CfgDir=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\cfg,QueryDir=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\Queries,HistDir=,DSNdirectory=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\DSNs,ReadOnlyMode=n,debug=y,debugDB=y,debugfile=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\aqtdebug_troy.txt,DisableSavePwd=n,ErrorLog=errorlog.txt,RunSQL=n,CharTstamps=n,EnforceSafeMode=n,SafeMode=n,SafeModeRem=n,SafeModeNumber=1,RowCount=n,ReplaceHex00=y,PromptTranMode=y,GridFormatForNumeric=y,ShowUserName=y,UseTOCHARWithOracleTstamps=y,PostgreSQLSetLimit=n,UseOracleServerName=n,OracleReplaceCRLF=y,QualifyUnqualifedTabNames=y,OnlyLookatUDRs=n,MultResult=n,NumHistEntries=20,EncryptPasswords=false;;;;;;;
4/14/2015 5:58:00 PM;troy;appuser.SetupUser;Set work directory: E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\workfiles;;;;;;;
4/14/2015 5:58:00 PM;troy;appuser.SetupUser;Set query directory: E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\Queries;;;;;;;
4/14/2015 5:58:00 PM;troy;appuser.GetQuery;troy;Query queryautodb: Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;;;;;;
4/14/2015 5:58:00 PM;troy;appuser.GetQuery;Query queryautodb: Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;;;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=9;AllocStmt;714614440;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=9;SetAsyncMode;0;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=9;ExecDirect;unicode=False;Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=9;ExecDirect;rc=0;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=9;GetNumRows;rc=0;numrows=0;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=9;GetColInfo; NumCols=1;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=9;Bindcols;colno=1,Database,type=12,bind=C,prec=50,buflen=51;;Tot bytes alloc=55;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=9;Fetch started;;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=9;Fetch reached end after 0 rows;;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=9;SQLDiagRec;FetchOne;0;SQLState=;;;
4/14/2015 5:58:00 PM;troy;GetDataColl;Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;rows=0;cols=1;elapsed=0.03;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=9;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.0312489 Prepare=0 ExecDirect=0.0156236 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
4/14/2015 5:58:00 PM;troy;dbsignon - page load;;;;;;;;
4/14/2015 5:58:00 PM;troy;dbsignon > loadsignons;;;;;;;;
4/14/2015 5:58:00 PM;troy;appuser.GetQuery;troy;Query querydblist: Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;;;;;;
4/14/2015 5:58:00 PM;troy;appuser.GetQuery;Query querydblist: Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;;;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=10;AllocStmt;714616696;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=10;SetAsyncMode;0;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=10;ExecDirect;unicode=False;Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=10;ExecDirect;rc=0;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=10;GetNumRows;rc=0;numrows=5;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=10;GetColInfo; NumCols=10;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=10;Bindcols;colno=1,Database,type=12,bind=C,prec=50,buflen=51;colno=2,Description,type=12,bind=C,prec=100,buflen=101;colno=3,ReadOnly,type=1,bind=C,prec=1,buflen=2;colno=4,NeedsUserPass,type=1,bind=C,prec=1,buflen=2;colno=5,DatabaseType,type=1,bind=C,prec=1,buflen=2;colno=6,CfgFile,type=12,bind=C,prec=20,buflen=21;colno=7,ShowReports,type=1,bind=C,prec=1,buflen=2;colno=8,ShowDatabase,type=1,bind=C,prec=1,buflen=2;colno=9,ShowSQL,type=1,bind=C,prec=1,buflen=2;colno=10,ShowFiles,type=1,bind=C,prec=1,buflen=2;;Tot bytes alloc=227;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=10;Fetch started;;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=10;Fetch reached end after 5 rows;;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=10;SQLDiagRec;FetchOne;0;SQLState=;;;
4/14/2015 5:58:00 PM;troy;GetDataColl;Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;rows=5;cols=10;elapsed=0.03;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=10;CloseQuery;Query statistics: Fetches=5 GetData=0 Elapsed=0.0312482 Prepare=0 ExecDirect=0.0156193 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
4/14/2015 5:58:00 PM;troy;aqtdbsignon > SetUpDsnSignons: dbSignonColl collection = 0;;;;;;;;
4/14/2015 5:58:00 PM;troy;appuser.GetQuery;troy;Query queryselrecent: Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;;;
4/14/2015 5:58:00 PM;troy;appuser.GetQuery;Query queryselrecent: Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=11;AllocStmt;714616696;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=11;SetAsyncMode;0;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=11;ExecDirect;unicode=False;Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=11;ExecDirect;rc=0;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=11;GetNumRows;rc=0;numrows=2;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=11;GetColInfo; NumCols=7;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=11;Bindcols;colno=1,Database,type=12,bind=C,prec=50,buflen=51;colno=2,Userid,type=12,bind=C,prec=50,buflen=51;colno=3,DBName,type=12,bind=C,prec=50,buflen=51;colno=4,OraclePriv,type=12,bind=C,prec=50,buflen=51;colno=5,Description,type=12,bind=C,prec=100,buflen=101;colno=6,ReadOnly,type=1,bind=C,prec=1,buflen=2;colno=7,EncryptedPwd,type=12,bind=C,prec=50,buflen=51;;Tot bytes alloc=386;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=11;Fetch started;;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=11;Fetch reached end after 2 rows;;;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=11;SQLDiagRec;FetchOne;0;SQLState=;;;
4/14/2015 5:58:00 PM;troy;GetDataColl;Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;rows=2;cols=7;elapsed=0.03;;;;
4/14/2015 5:58:00 PM;db=1=;stmt=11;CloseQuery;Query statistics: Fetches=2 GetData=0 Elapsed=0.0312447 Prepare=0 ExecDirect=0.0156193 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
4/14/2015 5:58:13 PM;troy;appuser.GetQuery;phil;Query querysignon: Select EncryptedPassword from Users where UserName='phil';;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=12;AllocStmt;714614440;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=12;SetAsyncMode;0;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=12;ExecDirect;unicode=False;Select EncryptedPassword from Users where UserName='phil';;;;
4/14/2015 5:58:13 PM;db=1=;stmt=12;ExecDirect;rc=0;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=12;GetNumRows;rc=0;numrows=1;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=12;GetColInfo; NumCols=1;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=12;Bindcols;colno=1,EncryptedPassword,type=12,bind=C,prec=50,buflen=51;;Tot bytes alloc=55;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=12;Fetch started;;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=12;Fetch reached end after 1 rows;;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=12;SQLDiagRec;FetchOne;0;SQLState=;;;
4/14/2015 5:58:13 PM;troy;GetDataColl;Select EncryptedPassword from Users where UserName='phil';rows=1;cols=1;elapsed=0.03;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=12;CloseQuery;Query statistics: Fetches=1 GetData=0 Elapsed=0.031246 Prepare=0 ExecDirect=0.0156208 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
4/14/2015 5:58:13 PM;troy;do_dec ;password= ;phil;;;;;;
4/14/2015 5:58:33 PM;aqtdb path=C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\aqtweb\0e6c774c\e7062279\assembly\dl3\16733391\7b8e989b_fc2ccf01\aqtdbinterface.dll;;;;;;;;
4/14/2015 5:58:33 PM;aqtdb version=C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\aqtweb\0e6c774c\e7062279\assembly\dl3\16733391\7b8e989b_fc2ccf01\aqtdbinterface.dll;1.0.4884.37408;32-bit mode;;;;;;;;
4/14/2015 5:58:33 PM;troy;-------------------- Session Starts --------------------;;;;;;;;
4/14/2015 5:58:33 PM;troy;Options;UseDSNConnections=y,ShowFavOnStart=n,ODBCMode=n,SupportAS400SysNamingConvention=n,NewTab=y,MenuStyle=Windows7,ToolbarStyle=Windows7,MultQueries=n,MultQueries2=n,MultQueriesBlankRow=y,AutoSaveQueries=n,Delimiter=;,RemoveComments=y,EnableUserParms=y,UserParmChar=$,MaxRows=1000,MaxColSize=1000,ShowGroupBy=y,ShowRowNumbers=n,RightTrim=y,NullFormat=(null),ShowVarcharLen=n,DateFormatV9=yyyy-MM-dd,TimeFormatV9=HH:mm:ss,DateFormatInformixV9=yyyy-MM-dd,TimeFormatInformixV9=HH:mm:ss,ShowZeroTime=n,ShowRowID=n,BinaryDisplay=2,ConvertEBCDIC=n,WriteBlobsToFiles=y,ShowBlobs=y,ShowClobs=y,ShowVarchar=n,ExcludeBLOBs=n,AsyncMode=2,QuoteNames=n,UncommittedRead=y,UseParms=n,AutoCommit=y,CommitAfterEachQuery=n,UseExecDirect=n,UnicodeMode=y,UnicodeCols=n,BindColsToStrings=n,UseGetDataAll=n,DeferredPrepare=n,ContinueOnFetchError=n,IDMSAccessCode=,IDMSAccessPlan=,ShowAllCons=n,ShowDNSCons=y,HistFile=aqt_history.txt,HistDiffName=n,HistIncScript=n,HistIncUpd=n,HistIncSearch=n,AuditEnabled=n,AuditDir=\audit,AuditFile=aqt_audit_yyyymmdd.txt,AuditSepFiles=n,AuditSelectStatements=n,AuditQueryResults=n,AuditRows=50,AuditRowLength=1000,DefDir=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\workfiles,CfgDir=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\cfg,QueryDir=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\Queries,HistDir=,DSNdirectory=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\DSNs,ReadOnlyMode=n,debug=y,debugDB=y,debugfile=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\aqtdebug_troy.txt,DisableSavePwd=n,ErrorLog=errorlog.txt,RunSQL=n,CharTstamps=n,EnforceSafeMode=n,SafeMode=n,SafeModeRem=n,SafeModeNumber=1,RowCount=n,ReplaceHex00=y,PromptTranMode=y,GridFormatForNumeric=y,ShowUserName=y,UseTOCHARWithOracleTstamps=y,PostgreSQLSetLimit=n,UseOracleServerName=n,OracleReplaceCRLF=y,QualifyUnqualifedTabNames=y,OnlyLookatUDRs=n,MultResult=n,NumHistEntries=20,EncryptPasswords=false;;;;;;;
4/14/2015 5:58:33 PM;troy;appuser.SetupUser;Set work directory: E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\workfiles;;;;;;;
4/14/2015 5:58:33 PM;troy;appuser.SetupUser;Set query directory: E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\Queries;;;;;;;
4/14/2015 5:58:33 PM;troy;appuser.GetQuery;troy;Query queryautodb: Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;;;;;;
4/14/2015 5:58:33 PM;troy;appuser.GetQuery;Query queryautodb: Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;;;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=29;AllocStmt;714618752;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=29;SetAsyncMode;0;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=29;ExecDirect;unicode=False;Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=29;ExecDirect;rc=0;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=29;GetNumRows;rc=0;numrows=0;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=29;GetColInfo; NumCols=1;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=29;Bindcols;colno=1,Database,type=12,bind=C,prec=50,buflen=51;;Tot bytes alloc=55;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=29;Fetch started;;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=29;Fetch reached end after 0 rows;;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=29;SQLDiagRec;FetchOne;0;SQLState=;;;
4/14/2015 5:58:33 PM;troy;GetDataColl;Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;rows=0;cols=1;elapsed=0.03;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=29;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.0468743 Prepare=0 ExecDirect=0.0156224 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
4/14/2015 5:58:33 PM;troy;dbsignon - page load;;;;;;;;
4/14/2015 5:58:33 PM;troy;dbsignon > loadsignons;;;;;;;;
4/14/2015 5:58:33 PM;troy;appuser.GetQuery;troy;Query querydblist: Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;;;;;;
4/14/2015 5:58:33 PM;troy;appuser.GetQuery;Query querydblist: Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;;;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=30;AllocStmt;714618752;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=30;SetAsyncMode;0;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=30;ExecDirect;unicode=False;Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=30;ExecDirect;rc=0;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=30;GetNumRows;rc=0;numrows=5;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=30;GetColInfo; NumCols=10;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=30;Bindcols;colno=1,Database,type=12,bind=C,prec=50,buflen=51;colno=2,Description,type=12,bind=C,prec=100,buflen=101;colno=3,ReadOnly,type=1,bind=C,prec=1,buflen=2;colno=4,NeedsUserPass,type=1,bind=C,prec=1,buflen=2;colno=5,DatabaseType,type=1,bind=C,prec=1,buflen=2;colno=6,CfgFile,type=12,bind=C,prec=20,buflen=21;colno=7,ShowReports,type=1,bind=C,prec=1,buflen=2;colno=8,ShowDatabase,type=1,bind=C,prec=1,buflen=2;colno=9,ShowSQL,type=1,bind=C,prec=1,buflen=2;colno=10,ShowFiles,type=1,bind=C,prec=1,buflen=2;;Tot bytes alloc=227;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=30;Fetch started;;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=30;Fetch reached end after 5 rows;;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=30;SQLDiagRec;FetchOne;0;SQLState=;;;
4/14/2015 5:58:33 PM;troy;GetDataColl;Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;rows=5;cols=10;elapsed=0.03;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=30;CloseQuery;Query statistics: Fetches=5 GetData=0 Elapsed=0.0312731 Prepare=0 ExecDirect=0.0156234 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
4/14/2015 5:58:33 PM;troy;aqtdbsignon > SetUpDsnSignons: dbSignonColl collection = 0;;;;;;;;
4/14/2015 5:58:33 PM;troy;appuser.GetQuery;troy;Query queryselrecent: Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;;;
4/14/2015 5:58:33 PM;troy;appuser.GetQuery;Query queryselrecent: Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=31;AllocStmt;714618752;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=31;SetAsyncMode;0;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=31;ExecDirect;unicode=False;Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=31;ExecDirect;rc=0;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=31;GetNumRows;rc=0;numrows=2;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=31;GetColInfo; NumCols=7;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=31;Bindcols;colno=1,Database,type=12,bind=C,prec=50,buflen=51;colno=2,Userid,type=12,bind=C,prec=50,buflen=51;colno=3,DBName,type=12,bind=C,prec=50,buflen=51;colno=4,OraclePriv,type=12,bind=C,prec=50,buflen=51;colno=5,Description,type=12,bind=C,prec=100,buflen=101;colno=6,ReadOnly,type=1,bind=C,prec=1,buflen=2;colno=7,EncryptedPwd,type=12,bind=C,prec=50,buflen=51;;Tot bytes alloc=386;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=31;Fetch started;;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=31;Fetch reached end after 2 rows;;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=31;SQLDiagRec;FetchOne;0;SQLState=;;;
4/14/2015 5:58:33 PM;troy;GetDataColl;Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;rows=2;cols=7;elapsed=0.02;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=31;CloseQuery;Query statistics: Fetches=2 GetData=0 Elapsed=0.0312494 Prepare=0 ExecDirect=0 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
4/14/2015 6:18:40 PM;troy;Logging off AQT due to Timeout;;;;;;;;
4/14/2015 6:18:40 PM;troy;appuser.GetQuery;troy;Query querysessionlog: Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'troy', '<LogData>');;;;;;
4/14/2015 6:18:40 PM;troy;LogSessionStatus: Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'troy', 'Logoff due to session timeout');;;;;;;;
4/14/2015 6:18:40 PM;db=1=;stmt=32;AllocStmt;714635200;;;;;
4/14/2015 6:18:40 PM;db=1=;stmt=32;SetAsyncMode;2;;;;;
4/14/2015 6:18:40 PM;db=1=;stmt=32;ExecDirect;unicode=False;Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'troy', 'Logoff due to session timeout');;;;
4/14/2015 6:18:40 PM;db=1=;stmt=32;ExecDirect;rc=0;;;;;
4/14/2015 6:18:40 PM;db=1=;stmt=32;GetNumRows;rc=0;numrows=1;;;;
4/14/2015 6:18:40 PM;db=1=;stmt=32;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.0156252 Prepare=0 ExecDirect=0.0156252 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
4/14/2015 6:18:40 PM;troy;-------------------- Session Ends due to session timeout--------------------;;;;;;;;
4/14/2015 6:18:40 PM;troy;Processing error at SessionTimedOut Object reference not set to an instance of an object. ;;;;;;;;
4/14/2015 6:18:40 PM;troy;Logging off AQT due to Timeout;;;;;;;;
4/14/2015 6:18:40 PM;troy;appuser.GetQuery;phil;Query querysessionlog: Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'phil', '<LogData>');;;;;;
4/14/2015 6:18:40 PM;troy;LogSessionStatus: Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'phil', 'Logoff due to session timeout');;;;;;;;
4/14/2015 6:18:40 PM;db=1=;stmt=33;AllocStmt;714635200;;;;;
4/14/2015 6:18:40 PM;db=1=;stmt=33;SetAsyncMode;2;;;;;
4/14/2015 6:18:40 PM;db=1=;stmt=33;ExecDirect;unicode=False;Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'phil', 'Logoff due to session timeout');;;;
4/14/2015 6:18:40 PM;db=1=;stmt=33;ExecDirect;rc=0;;;;;
4/14/2015 6:18:40 PM;db=1=;stmt=33;GetNumRows;rc=0;numrows=1;;;;
4/14/2015 6:18:40 PM;db=1=;stmt=33;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.0312467 Prepare=0 ExecDirect=0.0156234 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
4/14/2015 6:18:40 PM;troy;-------------------- Session Ends due to session timeout--------------------;;;;;;;;
4/14/2015 6:18:40 PM;troy;Processing error at SessionTimedOut Object reference not set to an instance of an object. ;;;;;;;;
4/14/2015 6:18:40 PM;troy;Logging off AQT due to Timeout;;;;;;;;
4/14/2015 6:18:40 PM;troy;appuser.GetQuery;troy;Query querysessionlog: Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'troy', '<LogData>');;;;;;
4/14/2015 6:18:40 PM;troy;LogSessionStatus: Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'troy', 'Logoff due to session timeout');;;;;;;;
4/14/2015 6:18:40 PM;db=1=;stmt=34;AllocStmt;714635200;;;;;
4/14/2015 6:18:40 PM;db=1=;stmt=34;SetAsyncMode;2;;;;;
4/14/2015 6:18:40 PM;db=1=;stmt=34;ExecDirect;unicode=False;Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'troy', 'Logoff due to session timeout');;;;
4/14/2015 6:18:40 PM;db=1=;stmt=34;ExecDirect;rc=0;;;;;
4/14/2015 6:18:40 PM;db=1=;stmt=34;GetNumRows;rc=0;numrows=1;;;;
4/14/2015 6:18:40 PM;db=1=;stmt=34;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.031315 Prepare=0 ExecDirect=0.031315 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
4/14/2015 6:18:40 PM;troy;-------------------- Session Ends due to session timeout--------------------;;;;;;;;
4/14/2015 6:18:40 PM;db=1=;Disconnect;rc=0;;;;;;
4/14/2015 6:18:40 PM;;Processing error at SessionTimedOut Object reference not set to an instance of an object. ;;;;;;;;
10/13/2015 4:24:00 PM;aqtdb path=C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\aqtweb\0e6c774c\e7062279\assembly\dl3\16733391\7b8e989b_fc2ccf01\aqtdbinterface.dll;;;;;;;;
10/13/2015 4:24:00 PM;aqtdb version=C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\aqtweb\0e6c774c\e7062279\assembly\dl3\16733391\7b8e989b_fc2ccf01\aqtdbinterface.dll;1.0.4884.37408;32-bit mode;;;;;;;;
10/13/2015 4:24:00 PM;troy;-------------------- Session Starts --------------------;;;;;;;;
10/13/2015 4:24:00 PM;troy;Options;UseDSNConnections=y,ShowFavOnStart=y,ODBCMode=n,SupportAS400SysNamingConvention=n,NewTab=y,MenuStyle=Back,ToolbarStyle=Windows7,MultQueries=n,MultQueries2=n,MultQueriesBlankRow=y,AutoSaveQueries=n,Delimiter=;,RemoveComments=y,EnableUserParms=y,UserParmChar=$,MaxRows=1000,MaxColSize=1000,ShowGroupBy=y,ShowRowNumbers=n,RightTrim=y,NullFormat=(null),ShowVarcharLen=n,DateFormatV9=yyyy-MM-dd,TimeFormatV9=HH:mm:ss,DateFormatInformixV9=yyyy-MM-dd,TimeFormatInformixV9=HH:mm:ss,ShowZeroTime=n,ShowRowID=n,BinaryDisplay=2,ConvertEBCDIC=n,WriteBlobsToFiles=y,ShowBlobs=y,ShowClobs=y,ShowVarchar=n,ExcludeBLOBs=n,AsyncMode=2,QuoteNames=n,UncommittedRead=y,UseParms=n,AutoCommit=y,CommitAfterEachQuery=n,UseExecDirect=n,UnicodeMode=y,UnicodeCols=n,BindColsToStrings=n,UseGetDataAll=n,DeferredPrepare=n,ContinueOnFetchError=n,IDMSAccessCode=,IDMSAccessPlan=,ShowAllCons=n,ShowDNSCons=y,HistFile=aqt_history.txt,HistDiffName=n,HistIncScript=n,HistIncUpd=n,HistIncSearch=n,AuditEnabled=n,AuditDir=\audit,AuditFile=aqt_audit_yyyymmdd.txt,AuditSepFiles=n,AuditSelectStatements=n,AuditQueryResults=n,AuditRows=50,AuditRowLength=1000,DefDir=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\workfiles,CfgDir=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\cfg,QueryDir=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\Queries,HistDir=,DSNdirectory=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\DSNs,ReadOnlyMode=n,debug=y,debugDB=y,debugfile=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\aqtdebug_troy.txt,DisableSavePwd=n,ErrorLog=errorlog.txt,RunSQL=n,CharTstamps=n,EnforceSafeMode=n,SafeMode=n,SafeModeRem=n,SafeModeNumber=1,RowCount=n,ReplaceHex00=y,PromptTranMode=y,GridFormatForNumeric=y,ShowUserName=y,UseTOCHARWithOracleTstamps=y,PostgreSQLSetLimit=n,UseOracleServerName=n,OracleReplaceCRLF=y,QualifyUnqualifedTabNames=y,OnlyLookatUDRs=n,MultResult=n,NumHistEntries=20,EncryptPasswords=false;;;;;;;
10/13/2015 4:24:00 PM;troy;appuser.SetupUser;Set work directory: E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\workfiles;;;;;;;
10/13/2015 4:24:00 PM;troy;appuser.SetupUser;Set query directory: E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\Queries;;;;;;;
10/13/2015 4:24:00 PM;troy;appuser.GetQuery;troy;Query queryautodb: Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;;;;;;
10/13/2015 4:24:00 PM;troy;appuser.GetQuery;Query queryautodb: Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;;;;;;;
10/13/2015 4:24:00 PM;db=1=;stmt=9;AllocStmt;18804720;;;;;
10/13/2015 4:24:00 PM;db=1=;stmt=9;SetAsyncMode;0;;;;;
10/13/2015 4:24:00 PM;db=1=;stmt=9;ExecDirect;unicode=False;Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;;;;
10/13/2015 4:24:00 PM;db=1=;stmt=9;ExecDirect;rc=0;;;;;
10/13/2015 4:24:00 PM;db=1=;stmt=9;GetNumRows;rc=0;numrows=0;;;;
10/13/2015 4:24:00 PM;db=1=;stmt=9;GetColInfo; NumCols=1;;;;;
10/13/2015 4:24:00 PM;db=1=;stmt=9;Bindcols;colno=1,Database,type=12,bind=C,prec=50,buflen=51;;Tot bytes alloc=55;;;;
10/13/2015 4:24:00 PM;db=1=;stmt=9;Fetch started;;;;;;
10/13/2015 4:24:00 PM;db=1=;stmt=9;Fetch reached end after 0 rows;;;;;;
10/13/2015 4:24:01 PM;db=1=;stmt=9;SQLDiagRec;FetchOne;0;SQLState=;;;
10/13/2015 4:24:01 PM;troy;GetDataColl;Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;rows=0;cols=1;elapsed=0.03;;;;
10/13/2015 4:24:01 PM;db=1=;stmt=9;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.0312498 Prepare=0 ExecDirect=0 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
10/13/2015 4:24:07 PM;troy;dbsignon - page load;;;;;;;;
10/13/2015 4:24:07 PM;troy;dbsignon > loadsignons;;;;;;;;
10/13/2015 4:24:07 PM;troy;appuser.GetQuery;troy;Query querydblist: Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;;;;;;
10/13/2015 4:24:07 PM;troy;appuser.GetQuery;Query querydblist: Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;;;;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=10;AllocStmt;708148056;;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=10;SetAsyncMode;0;;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=10;ExecDirect;unicode=False;Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=10;ExecDirect;rc=0;;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=10;GetNumRows;rc=0;numrows=7;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=10;GetColInfo; NumCols=10;;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=10;Bindcols;colno=1,Database,type=12,bind=C,prec=50,buflen=51;colno=2,Description,type=12,bind=C,prec=100,buflen=101;colno=3,ReadOnly,type=1,bind=C,prec=1,buflen=2;colno=4,NeedsUserPass,type=1,bind=C,prec=1,buflen=2;colno=5,DatabaseType,type=1,bind=C,prec=1,buflen=2;colno=6,CfgFile,type=12,bind=C,prec=20,buflen=21;colno=7,ShowReports,type=1,bind=C,prec=1,buflen=2;colno=8,ShowDatabase,type=1,bind=C,prec=1,buflen=2;colno=9,ShowSQL,type=1,bind=C,prec=1,buflen=2;colno=10,ShowFiles,type=1,bind=C,prec=1,buflen=2;;Tot bytes alloc=227;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=10;Fetch started;;;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=10;Fetch reached end after 7 rows;;;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=10;SQLDiagRec;FetchOne;0;SQLState=;;;
10/13/2015 4:24:07 PM;troy;GetDataColl;Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;rows=7;cols=10;elapsed=0.02;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=10;CloseQuery;Query statistics: Fetches=7 GetData=0 Elapsed=0.0156227 Prepare=0 ExecDirect=0 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
10/13/2015 4:24:07 PM;troy;aqtdbsignon > SetUpDsnSignons: dbSignonColl collection = 0;;;;;;;;
10/13/2015 4:24:07 PM;troy;appuser.GetQuery;troy;Query queryselrecent: Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;;;
10/13/2015 4:24:07 PM;troy;appuser.GetQuery;Query queryselrecent: Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=11;AllocStmt;708148056;;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=11;SetAsyncMode;0;;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=11;ExecDirect;unicode=False;Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=11;ExecDirect;rc=0;;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=11;GetNumRows;rc=0;numrows=2;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=11;GetColInfo; NumCols=7;;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=11;Bindcols;colno=1,Database,type=12,bind=C,prec=50,buflen=51;colno=2,Userid,type=12,bind=C,prec=50,buflen=51;colno=3,DBName,type=12,bind=C,prec=50,buflen=51;colno=4,OraclePriv,type=12,bind=C,prec=50,buflen=51;colno=5,Description,type=12,bind=C,prec=100,buflen=101;colno=6,ReadOnly,type=1,bind=C,prec=1,buflen=2;colno=7,EncryptedPwd,type=12,bind=C,prec=50,buflen=51;;Tot bytes alloc=386;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=11;Fetch started;;;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=11;Fetch reached end after 2 rows;;;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=11;SQLDiagRec;FetchOne;0;SQLState=;;;
10/13/2015 4:24:07 PM;troy;GetDataColl;Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;rows=2;cols=7;elapsed=0.03;;;;
10/13/2015 4:24:07 PM;db=1=;stmt=11;CloseQuery;Query statistics: Fetches=2 GetData=0 Elapsed=0.0312504 Prepare=0 ExecDirect=0.0156237 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
10/13/2015 4:44:20 PM;troy;Logging off AQT due to Timeout;;;;;;;;
10/13/2015 4:44:20 PM;troy;appuser.GetQuery;troy;Query querysessionlog: Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'troy', '<LogData>');;;;;;
10/13/2015 4:44:20 PM;troy;LogSessionStatus: Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'troy', 'Logoff due to session timeout');;;;;;;;
10/13/2015 4:44:20 PM;db=1=;stmt=12;AllocStmt;18702784;;;;;
10/13/2015 4:44:20 PM;db=1=;stmt=12;SetAsyncMode;2;;;;;
10/13/2015 4:44:20 PM;db=1=;stmt=12;ExecDirect;unicode=False;Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'troy', 'Logoff due to session timeout');;;;
10/13/2015 4:44:20 PM;db=1=;stmt=12;ExecDirect;rc=0;;;;;
10/13/2015 4:44:20 PM;db=1=;stmt=12;GetNumRows;rc=0;numrows=1;;;;
10/13/2015 4:44:20 PM;db=1=;stmt=12;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.0156199 Prepare=0 ExecDirect=0 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
10/13/2015 4:44:20 PM;troy;-------------------- Session Ends due to session timeout--------------------;;;;;;;;
10/13/2015 4:44:20 PM;db=1=;Disconnect;rc=0;;;;;;
10/13/2015 4:44:20 PM;;Processing error at SessionTimedOut Object reference not set to an instance of an object. ;;;;;;;;
4/13/2016 2:22:19 PM;aqtdb path=C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\aqtweb\0e6c774c\e7062279\assembly\dl3\16733391\7b8e989b_fc2ccf01\aqtdbinterface.dll;;;;;;;;
4/13/2016 2:22:19 PM;aqtdb version=C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\aqtweb\0e6c774c\e7062279\assembly\dl3\16733391\7b8e989b_fc2ccf01\aqtdbinterface.dll;1.0.4884.37408;32-bit mode;;;;;;;;
4/13/2016 2:22:19 PM;troy;-------------------- Session Starts --------------------;;;;;;;;
4/13/2016 2:22:19 PM;troy;Options;UseDSNConnections=y,ShowFavOnStart=y,ODBCMode=n,SupportAS400SysNamingConvention=n,NewTab=y,MenuStyle=Back,ToolbarStyle=Windows7,MultQueries=n,MultQueries2=n,MultQueriesBlankRow=y,AutoSaveQueries=n,Delimiter=;,RemoveComments=y,EnableUserParms=y,UserParmChar=$,MaxRows=1000,MaxColSize=1000,ShowGroupBy=y,ShowRowNumbers=n,RightTrim=y,NullFormat=(null),ShowVarcharLen=n,DateFormatV9=yyyy-MM-dd,TimeFormatV9=HH:mm:ss,DateFormatInformixV9=yyyy-MM-dd,TimeFormatInformixV9=HH:mm:ss,ShowZeroTime=n,ShowRowID=n,BinaryDisplay=2,ConvertEBCDIC=n,WriteBlobsToFiles=y,ShowBlobs=y,ShowClobs=y,ShowVarchar=n,ExcludeBLOBs=n,AsyncMode=2,QuoteNames=n,UncommittedRead=y,UseParms=n,AutoCommit=y,CommitAfterEachQuery=n,UseExecDirect=n,UnicodeMode=y,UnicodeCols=n,BindColsToStrings=n,UseGetDataAll=n,DeferredPrepare=n,ContinueOnFetchError=n,IDMSAccessCode=,IDMSAccessPlan=,ShowAllCons=n,ShowDNSCons=y,HistFile=aqt_history.txt,HistDiffName=n,HistIncScript=n,HistIncUpd=n,HistIncSearch=n,AuditEnabled=n,AuditDir=\audit,AuditFile=aqt_audit_yyyymmdd.txt,AuditSepFiles=n,AuditSelectStatements=n,AuditQueryResults=n,AuditRows=50,AuditRowLength=1000,DefDir=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\workfiles,CfgDir=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\cfg,QueryDir=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\Queries,HistDir=,DSNdirectory=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\DSNs,ReadOnlyMode=n,debug=y,debugDB=y,debugfile=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\aqtdebug_troy.txt,DisableSavePwd=n,ErrorLog=errorlog.txt,RunSQL=n,CharTstamps=n,EnforceSafeMode=n,SafeMode=n,SafeModeRem=n,SafeModeNumber=1,RowCount=n,ReplaceHex00=y,PromptTranMode=y,GridFormatForNumeric=y,ShowUserName=y,UseTOCHARWithOracleTstamps=y,PostgreSQLSetLimit=n,UseOracleServerName=n,OracleReplaceCRLF=y,QualifyUnqualifedTabNames=y,OnlyLookatUDRs=n,MultResult=n,NumHistEntries=20,EncryptPasswords=false;;;;;;;
4/13/2016 2:22:19 PM;troy;appuser.SetupUser;Set work directory: E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\workfiles;;;;;;;
4/13/2016 2:22:19 PM;troy;appuser.SetupUser;Set query directory: E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\Queries;;;;;;;
4/13/2016 2:22:19 PM;troy;appuser.GetQuery;troy;Query queryautodb: Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;;;;;;
4/13/2016 2:22:19 PM;troy;appuser.GetQuery;Query queryautodb: Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;;;;;;;
4/13/2016 2:22:19 PM;db=1=;stmt=9;AllocStmt;711288880;;;;;
4/13/2016 2:22:19 PM;db=1=;stmt=9;SetAsyncMode;0;;;;;
4/13/2016 2:22:19 PM;db=1=;stmt=9;ExecDirect;unicode=False;Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;;;;
4/13/2016 2:22:19 PM;db=1=;stmt=9;ExecDirect;rc=-1;;;;;
4/13/2016 2:22:19 PM;db=1=;stmt=9;GetErrorMsg;ExecDirect;SQLState=S0022;1054;S0022(1054)[MySQL][ODBC 3.51 Driver][mysqld-5.6.24-log]Unknown column 'Database' in 'field list';;
4/13/2016 2:22:19 PM;db=1=;stmt=9;GetNumRows;rc=-1;numrows=0;;;;
4/13/2016 2:22:19 PM;troy;GetDataColl;Error running query Error during ExecDirect
 S0022(1054)[MySQL][ODBC 3.51 Driver][mysqld-5.6.24-log]Unknown column 'Database' in 'field list';;;;;;;
4/13/2016 2:22:19 PM;troy;GetDataColl;Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;rows=0;cols=0;elapsed=0.03;;;;
4/13/2016 2:22:19 PM;db=1=;stmt=9;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.0312521 Prepare=0 ExecDirect=0.0156032 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
4/13/2016 2:22:23 PM;troy;dbsignon - page load;;;;;;;;
4/13/2016 2:22:23 PM;troy;dbsignon > loadsignons;;;;;;;;
4/13/2016 2:22:23 PM;troy;appuser.GetQuery;troy;Query querydblist: Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;;;;;;
4/13/2016 2:22:23 PM;troy;appuser.GetQuery;Query querydblist: Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;;;;;;;
4/13/2016 2:22:23 PM;db=1=;stmt=10;AllocStmt;711414704;;;;;
4/13/2016 2:22:23 PM;db=1=;stmt=10;SetAsyncMode;0;;;;;
4/13/2016 2:22:23 PM;db=1=;stmt=10;ExecDirect;unicode=False;Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;;;;
4/13/2016 2:22:23 PM;db=1=;stmt=10;ExecDirect;rc=-1;;;;;
4/13/2016 2:22:23 PM;db=1=;stmt=10;GetErrorMsg;ExecDirect;SQLState=S0022;1054;S0022(1054)[MySQL][ODBC 3.51 Driver][mysqld-5.6.24-log]Unknown column 'a.Database' in 'field list';;
4/13/2016 2:22:23 PM;db=1=;stmt=10;GetNumRows;rc=-1;numrows=0;;;;
4/13/2016 2:22:23 PM;troy;GetDataColl;Error running query Error during ExecDirect
 S0022(1054)[MySQL][ODBC 3.51 Driver][mysqld-5.6.24-log]Unknown column 'a.Database' in 'field list';;;;;;;
4/13/2016 2:22:23 PM;troy;GetDataColl;Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;rows=0;cols=0;elapsed=0.05;;;;
4/13/2016 2:22:23 PM;db=1=;stmt=10;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.0468529 Prepare=0 ExecDirect=0.031073 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
4/13/2016 2:22:23 PM;troy;LoadAuthorizedDatabases;Error running query Error during ExecDirect
 S0022(1054)[MySQL][ODBC 3.51 Driver][mysqld-5.6.24-log]Unknown column 'a.Database' in 'field list';;;;;;;
4/13/2016 2:22:23 PM;troy;aqtdbsignon > SetUpDsnSignons: dbSignonColl collection = 0;;;;;;;;
4/13/2016 2:22:23 PM;troy;appuser.GetQuery;troy;Query queryselrecent: Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;;;
4/13/2016 2:22:23 PM;troy;appuser.GetQuery;Query queryselrecent: Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;;;;
4/13/2016 2:22:23 PM;db=1=;stmt=11;AllocStmt;711414704;;;;;
4/13/2016 2:22:23 PM;db=1=;stmt=11;SetAsyncMode;0;;;;;
4/13/2016 2:22:23 PM;db=1=;stmt=11;ExecDirect;unicode=False;Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;
4/13/2016 2:22:23 PM;db=1=;stmt=11;ExecDirect;rc=-1;;;;;
4/13/2016 2:22:23 PM;db=1=;stmt=11;GetErrorMsg;ExecDirect;SQLState=S0022;1054;S0022(1054)[MySQL][ODBC 3.51 Driver][mysqld-5.6.24-log]Unknown column 'a.Database' in 'field list';;
4/13/2016 2:22:23 PM;db=1=;stmt=11;GetNumRows;rc=-1;numrows=0;;;;
4/13/2016 2:22:23 PM;troy;GetDataColl;Error running query Error during ExecDirect
 S0022(1054)[MySQL][ODBC 3.51 Driver][mysqld-5.6.24-log]Unknown column 'a.Database' in 'field list';;;;;;;
4/13/2016 2:22:23 PM;troy;GetDataColl;Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;rows=0;cols=0;elapsed=0.02;;;;
4/13/2016 2:22:23 PM;db=1=;stmt=11;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.0312488 Prepare=0 ExecDirect=0.0167408 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
4/13/2016 2:42:40 PM;troy;Logging off AQT due to Timeout;;;;;;;;
4/13/2016 2:42:40 PM;troy;appuser.GetQuery;troy;Query querysessionlog: Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'troy', '<LogData>');;;;;;
4/13/2016 2:42:40 PM;troy;LogSessionStatus: Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'troy', 'Logoff due to session timeout');;;;;;;;
4/13/2016 2:42:40 PM;db=1=;stmt=12;AllocStmt;14603008;;;;;
4/13/2016 2:42:40 PM;db=1=;stmt=12;SetAsyncMode;2;;;;;
4/13/2016 2:42:40 PM;db=1=;stmt=12;ExecDirect;unicode=False;Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '219-88-65-72.adsl.xtra.co.nz', 'troy', 'Logoff due to session timeout');;;;
4/13/2016 2:42:40 PM;db=1=;stmt=12;ExecDirect;rc=0;;;;;
4/13/2016 2:42:40 PM;db=1=;stmt=12;GetNumRows;rc=0;numrows=1;;;;
4/13/2016 2:42:40 PM;db=1=;stmt=12;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.0152095 Prepare=0 ExecDirect=0 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
4/13/2016 2:42:40 PM;troy;-------------------- Session Ends due to session timeout--------------------;;;;;;;;
4/13/2016 2:42:40 PM;db=1=;Disconnect;rc=0;;;;;;
4/13/2016 2:42:40 PM;;Processing error at SessionTimedOut Object reference not set to an instance of an object. ;;;;;;;;
7/12/2016 5:41:18 AM;aqtdb path=C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\aqtweb\0e6c774c\e7062279\assembly\dl3\16733391\7b8e989b_fc2ccf01\aqtdbinterface.dll;;;;;;;;
7/12/2016 5:41:18 AM;aqtdb version=C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\aqtweb\0e6c774c\e7062279\assembly\dl3\16733391\7b8e989b_fc2ccf01\aqtdbinterface.dll;1.0.4884.37408;32-bit mode;;;;;;;;
7/12/2016 5:41:18 AM;troy;-------------------- Session Starts --------------------;;;;;;;;
7/12/2016 5:41:18 AM;troy;Options;UseDSNConnections=y,ShowFavOnStart=y,ODBCMode=n,SupportAS400SysNamingConvention=n,NewTab=y,MenuStyle=Back,ToolbarStyle=Windows7,MultQueries=n,MultQueries2=n,MultQueriesBlankRow=y,AutoSaveQueries=n,Delimiter=;,RemoveComments=y,EnableUserParms=y,UserParmChar=$,MaxRows=1000,MaxColSize=1000,ShowGroupBy=y,ShowRowNumbers=n,RightTrim=y,NullFormat=(null),ShowVarcharLen=n,DateFormatV9=yyyy-MM-dd,TimeFormatV9=HH:mm:ss,DateFormatInformixV9=yyyy-MM-dd,TimeFormatInformixV9=HH:mm:ss,ShowZeroTime=n,ShowRowID=n,BinaryDisplay=2,ConvertEBCDIC=n,WriteBlobsToFiles=y,ShowBlobs=y,ShowClobs=y,ShowVarchar=n,ExcludeBLOBs=n,AsyncMode=2,QuoteNames=n,UncommittedRead=y,UseParms=n,AutoCommit=y,CommitAfterEachQuery=n,UseExecDirect=n,UnicodeMode=y,UnicodeCols=n,BindColsToStrings=n,UseGetDataAll=n,DeferredPrepare=n,ContinueOnFetchError=n,IDMSAccessCode=,IDMSAccessPlan=,ShowAllCons=n,ShowDNSCons=y,HistFile=aqt_history.txt,HistDiffName=n,HistIncScript=y,HistIncUpd=y,HistIncSearch=n,AuditEnabled=n,AuditDir=\audit,AuditFile=aqt_audit_yyyymmdd.txt,AuditSepFiles=n,AuditSelectStatements=n,AuditQueryResults=n,AuditRows=50,AuditRowLength=1000,DefDir=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\workfiles,CfgDir=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\cfg,QueryDir=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\Queries,HistDir=,DSNdirectory=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\DSNs,ReadOnlyMode=n,debug=y,debugDB=y,debugfile=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\aqtdebug_troy.txt,DisableSavePwd=n,ErrorLog=errorlog.txt,RunSQL=n,CharTstamps=n,EnforceSafeMode=n,SafeMode=n,SafeModeRem=n,SafeModeNumber=1,RowCount=n,ReplaceHex00=y,PromptTranMode=y,GridFormatForNumeric=y,ShowUserName=y,UseTOCHARWithOracleTstamps=y,PostgreSQLSetLimit=n,UseOracleServerName=n,OracleReplaceCRLF=y,QualifyUnqualifedTabNames=y,OnlyLookatUDRs=n,MultResult=n,NumHistEntries=20,EncryptPasswords=false;;;;;;;
7/12/2016 5:41:18 AM;troy;appuser.SetupUser;Set work directory: E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\workfiles;;;;;;;
7/12/2016 5:41:18 AM;troy;appuser.SetupUser;Set query directory: E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\troy\Queries;;;;;;;
7/12/2016 5:41:18 AM;troy;appuser.GetQuery;troy;Query queryautodb: Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;;;;;;
7/12/2016 5:41:18 AM;troy;appuser.GetQuery;Query queryautodb: Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;;;;;;;
7/12/2016 5:41:19 AM;db=1=;stmt=11;AllocStmt;709138632;;;;;
7/12/2016 5:41:19 AM;db=1=;stmt=11;SetAsyncMode;0;;;;;
7/12/2016 5:41:19 AM;db=1=;stmt=11;ExecDirect;unicode=False;Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;;;;
7/12/2016 5:41:19 AM;db=1=;stmt=11;ExecDirect;rc=-1;;;;;
7/12/2016 5:41:19 AM;db=1=;stmt=11;GetErrorMsg;ExecDirect;SQLState=S0022;1054;S0022(1054)[MySQL][ODBC 3.51 Driver][mysqld-5.6.24-log]Unknown column 'Database' in 'field list';;
7/12/2016 5:41:19 AM;db=1=;stmt=11;GetNumRows;rc=-1;numrows=0;;;;
7/12/2016 5:41:19 AM;troy;GetDataColl;Error running query Error during ExecDirect
 S0022(1054)[MySQL][ODBC 3.51 Driver][mysqld-5.6.24-log]Unknown column 'Database' in 'field list';;;;;;;
7/12/2016 5:41:19 AM;troy;GetDataColl;Select `Database` from DatabaseAccess where UserName = 'troy' and AutoSignon=true;rows=0;cols=0;elapsed=0.06;;;;
7/12/2016 5:41:19 AM;db=1=;stmt=11;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.0625005 Prepare=0 ExecDirect=0.0312735 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
7/12/2016 5:41:19 AM;troy;dbsignon - page load;;;;;;;;
7/12/2016 5:41:19 AM;troy;dbsignon > loadsignons;;;;;;;;
7/12/2016 5:41:19 AM;troy;appuser.GetQuery;troy;Query querydblist: Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;;;;;;
7/12/2016 5:41:19 AM;troy;appuser.GetQuery;Query querydblist: Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;;;;;;;
7/12/2016 5:41:19 AM;db=1=;stmt=12;AllocStmt;709136568;;;;;
7/12/2016 5:41:19 AM;db=1=;stmt=12;SetAsyncMode;0;;;;;
7/12/2016 5:41:19 AM;db=1=;stmt=12;ExecDirect;unicode=False;Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;;;;
7/12/2016 5:41:19 AM;db=1=;stmt=12;ExecDirect;rc=-1;;;;;
7/12/2016 5:41:19 AM;db=1=;stmt=12;GetErrorMsg;ExecDirect;SQLState=S0022;1054;S0022(1054)[MySQL][ODBC 3.51 Driver][mysqld-5.6.24-log]Unknown column 'a.Database' in 'field list';;
7/12/2016 5:41:19 AM;db=1=;stmt=12;GetNumRows;rc=-1;numrows=0;;;;
7/12/2016 5:41:19 AM;troy;GetDataColl;Error running query Error during ExecDirect
 S0022(1054)[MySQL][ODBC 3.51 Driver][mysqld-5.6.24-log]Unknown column 'a.Database' in 'field list';;;;;;;
7/12/2016 5:41:19 AM;troy;GetDataColl;Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('troy','dev') and a.`Database`=b.DatabaseName;rows=0;cols=0;elapsed=0.05;;;;
7/12/2016 5:41:19 AM;db=1=;stmt=12;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.0468555 Prepare=0 ExecDirect=0.0312359 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
7/12/2016 5:41:19 AM;troy;LoadAuthorizedDatabases;Error running query Error during ExecDirect
 S0022(1054)[MySQL][ODBC 3.51 Driver][mysqld-5.6.24-log]Unknown column 'a.Database' in 'field list';;;;;;;
7/12/2016 5:41:19 AM;troy;aqtdbsignon > SetUpDsnSignons: dbSignonColl collection = 0;;;;;;;;
7/12/2016 5:41:19 AM;troy;appuser.GetQuery;troy;Query queryselrecent: Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;;;
7/12/2016 5:41:19 AM;troy;appuser.GetQuery;Query queryselrecent: Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;;;;
7/12/2016 5:41:19 AM;db=1=;stmt=13;AllocStmt;709136568;;;;;
7/12/2016 5:41:19 AM;db=1=;stmt=13;SetAsyncMode;0;;;;;
7/12/2016 5:41:19 AM;db=1=;stmt=13;ExecDirect;unicode=False;Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;
7/12/2016 5:41:19 AM;db=1=;stmt=13;ExecDirect;rc=-1;;;;;
7/12/2016 5:41:19 AM;db=1=;stmt=13;GetErrorMsg;ExecDirect;SQLState=S0022;1054;S0022(1054)[MySQL][ODBC 3.51 Driver][mysqld-5.6.24-log]Unknown column 'a.Database' in 'field list';;
7/12/2016 5:41:19 AM;db=1=;stmt=13;GetNumRows;rc=-1;numrows=0;;;;
7/12/2016 5:41:19 AM;troy;GetDataColl;Error running query Error during ExecDirect
 S0022(1054)[MySQL][ODBC 3.51 Driver][mysqld-5.6.24-log]Unknown column 'a.Database' in 'field list';;;;;;;
7/12/2016 5:41:19 AM;troy;GetDataColl;Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;rows=0;cols=0;elapsed=0.05;;;;
7/12/2016 5:41:19 AM;db=1=;stmt=13;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.062509 Prepare=0 ExecDirect=0.0170852 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
7/12/2016 5:41:41 AM;troy;dbsignon - page load;;;;;;;;
7/12/2016 5:41:41 AM;troy;dbsignon > loadsignons;;;;;;;;
7/12/2016 5:41:41 AM;troy;aqtdbsignon > SetUpDsnSignons: dbSignonColl collection = 0;;;;;;;;
7/12/2016 5:41:41 AM;troy;appuser.GetQuery;troy;Query queryselrecent: Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;;;
7/12/2016 5:41:41 AM;troy;appuser.GetQuery;Query queryselrecent: Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;;;;
7/12/2016 5:41:41 AM;db=1=;stmt=14;AllocStmt;709206016;;;;;
7/12/2016 5:41:41 AM;db=1=;stmt=14;SetAsyncMode;0;;;;;
7/12/2016 5:41:41 AM;db=1=;stmt=14;ExecDirect;unicode=False;Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;;;;
7/12/2016 5:41:41 AM;db=1=;stmt=14;ExecDirect;rc=-1;;;;;
7/12/2016 5:41:41 AM;db=1=;stmt=14;GetErrorMsg;ExecDirect;SQLState=S0022;1054;S0022(1054)[MySQL][ODBC 3.51 Driver][mysqld-5.6.24-log]Unknown column 'a.Database' in 'field list';;
7/12/2016 5:41:41 AM;db=1=;stmt=14;GetNumRows;rc=-1;numrows=0;;;;
7/12/2016 5:41:41 AM;troy;GetDataColl;Error running query Error during ExecDirect
 S0022(1054)[MySQL][ODBC 3.51 Driver][mysqld-5.6.24-log]Unknown column 'a.Database' in 'field list';;;;;;;
7/12/2016 5:41:41 AM;troy;GetDataColl;Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='troy' ORDER BY ConnectTime desc;rows=0;cols=0;elapsed=0.05;;;;
7/12/2016 5:41:41 AM;db=1=;stmt=14;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.0624203 Prepare=0 ExecDirect=0.031218 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
7/12/2016 6:02:00 AM;troy;Logging off AQT due to Timeout;;;;;;;;
7/12/2016 6:02:00 AM;troy;appuser.GetQuery;troy;Query querysessionlog: Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '247-90-26-185.reverse.alphalink.fr', 'troy', '<LogData>');;;;;;
7/12/2016 6:02:00 AM;troy;LogSessionStatus: Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '247-90-26-185.reverse.alphalink.fr', 'troy', 'Logoff due to session timeout');;;;;;;;
7/12/2016 6:02:00 AM;db=1=;stmt=15;AllocStmt;709050456;;;;;
7/12/2016 6:02:00 AM;db=1=;stmt=15;SetAsyncMode;2;;;;;
7/12/2016 6:02:00 AM;db=1=;stmt=15;ExecDirect;unicode=False;Insert into SessionLog (LogTime, HostName, UserName, LogData) VALUES(NOW(), '247-90-26-185.reverse.alphalink.fr', 'troy', 'Logoff due to session timeout');;;;
7/12/2016 6:02:00 AM;db=1=;stmt=15;ExecDirect;rc=0;;;;;
7/12/2016 6:02:00 AM;db=1=;stmt=15;GetNumRows;rc=0;numrows=1;;;;
7/12/2016 6:02:00 AM;db=1=;stmt=15;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.0468727 Prepare=0 ExecDirect=0.0156229 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
7/12/2016 6:02:00 AM;troy;-------------------- Session Ends due to session timeout--------------------;;;;;;;;
7/12/2016 6:02:00 AM;db=1=;Disconnect;rc=0;;;;;;
7/12/2016 6:02:00 AM;;Processing error at SessionTimedOut Object reference not set to an instance of an object. ;;;;;;;;