Hi all,
I'm trying to keep on track of sales data of each items...
However I'm getting "Could not get min DOB from SQL RDB. Check Debouts for more details"
Screenshot here:
Below are the debout files:
Debout.SQL
Jul 25, 23:42:46
Jul 25, 23:42:46 ...............................................................
Jul 25, 23:42:46 ***** DrSql 6.0.0.20 Alpha started... (Doctor SQL) *****
Jul 25, 23:42:46 iberdir = C:\Aloha
Jul 25, 23:42:46 LoadIberStrings() - Loaded version 6.2.16.0, IBERSTR.DLL
Jul 25, 23:42:46 LoadIberStrings() - WARNING: Application version = 6.0.0.20, IberStr.dll version = 6.2.16.0.
Version difference may cause problems.
Jul 25, 23:42:46 Could not create sql server object. CoCreateInstance failed.
Jul 25, 23:42:53 ***** Doctor SQL DB App Ended *****
Debout.txt
Jun 24, 14:56:53,, [STATUS],,""
Jun 24, 14:56:53,, [STATUS],,"............................................................"
Jun 24, 14:56:53,, [STATUS],,"AlohaMgr starting... version 6.2.16.1183.2 "
Jun 24, 14:56:53,, [INFO],," MODE SETTINGS"
Jun 24, 14:56:53,, [INFO],,"***** Version: 6.2.16.1183.2 "
Jun 24, 14:56:56,, [INFO],,"Unable to read ESP.EXE version string for file - C:\Aloha\Backoffice\Schedule\ESP.EXE"
Jun 24, 14:56:56,, [INFO],,"LoadIberStrings() - Loaded version 6.2.16.0, C:\Aloha\bin\IBERSTR.DLL"
Jun 24, 14:56:56,, [INFO],,"***** Workstation: ALOHABOH"
Jun 24, 14:56:56,, [INFO],,"***** TableService Only"
Jun 24, 14:56:56,, [INFO],,"***** Using SQLMODE"
Jun 24, 14:56:56,, [INFO],,"***** Relational database: Access"
Jun 24, 14:56:56,, [INFO],,"***** Site Id: 0"
Jun 24, 14:56:56,, [INFO],,"*****Start of WORK in InitInstance"
Jun 24, 14:57:01,, [INFO],,"*****Before AlohaMgr create"
Jun 24, 14:57:02,, [INFO],,"*****Before AlohaMgr RequestCtlSvr"
Jun 24, 14:57:02,, [INFO],,"CAlohaMgrApp::RequestCtlSvr() called..."
Jun 24, 14:57:02,, [INFO],,"WaitForCtlSvrStartupComplete()..."
Jun 24, 14:57:02,, [INFO],,"ACtlSvrConnect: (thread) - Begin Run()"
Jun 24, 14:57:03,, [INFO],,"ACtlSvrConnect: (thread) - startup complete."
Jun 24, 14:57:04,, [INFO],,"WaitForCtlSvrStartupComplete()...complete."
Jun 24, 14:57:04,, [INFO],,"*****Before AlohaMgr OnLogin"
Jun 24, 14:57:04,, [INFO],,"ALOHASEC.EXE initializing..."
Jun 24, 14:57:06,, [INFO],,"LoadIberStrings() - Loaded version 6.2.16.0, C:\Aloha\bin\IBERSTR.DLL"
Jun 24, 14:57:06,, [INFO],,"In AlohaSec/LoadSecurityData, BEFORE reading SQL data files"
Jun 24, 14:57:06,, [INFO],,"DAO Version 3.6"
Jun 24, 14:57:06,, [INFO],,"In AlohaSec/LoadSecurityData, AFTER reading SQL data files"
Jun 24, 14:57:06,, [INFO],,"CBOHSecurity::SecuritySetup() - SQLMode - successful return."
Jun 24, 14:57:10,, [INFO],,"AlohaMgr Login: Dealer Password"
Jun 24, 14:57:10,, [INFO],,"*****Before NewModuleAdded"
Jun 24, 14:57:10,, [INFO],,"CTL4X.DLL in InitInstance..."
Jun 24, 14:57:10,, [STATUS],,"CTL4X.DLL initializing... version 6.2.16.1183.2 "
Jun 24, 14:57:10,, [INFO],,"CAlohaMgrApp::RequestCtlSvr() called..."
Jun 24, 14:57:10,, [INFO],,"LoadIberStrings() - Loaded version 6.2.16.0, C:\Aloha\bin\IBERSTR.DLL"
Jun 24, 14:57:10,, [INFO],,"Connected to Relational Database (Access)."
Jun 24, 14:57:10,, [INFO],,"Connected to Relational Database - CTL4X"
Jun 24, 14:57:10,, [INFO],,"Initializing store terminal manager"
Jun 24, 14:57:10,, [INFO],,"DAO Version 3.6"
Jun 24, 14:57:10,, [INFO],,"Done initializing store terminal manager"
Jun 24, 14:57:10,, [INFO],,"Reading stores and terminals..."
Jun 24, 14:57:10,, [INFO],,"Done reading stores and terminals"
Jun 24, 14:57:11,, [INFO],,"EDTPUNCH.DLL in InitInstance..."
Jun 24, 14:57:11,, [INFO],,"TIMEZONE=NO DST - setting TZ to prevent spring forward or fall back"
Jun 24, 14:57:11,, [INFO],,"WARNING: This computer's Time Zone has non-zero values for StandardStart and DaylightStart dates."
Jun 24, 14:57:11,, [INFO],," Either select the correct time zone which does not honor DST or"
Jun 24, 14:57:11,, [INFO],," remove 'TIMEZONE=NO DST' from Aloha.ini to have Aloha software use US DST."
Jun 24, 14:57:11,, [STATUS],,"EDTPUNCH.DLL initializing... version 6.2.16.1183.2 "
Jun 24, 14:57:11,, [INFO],,"LoadIberStrings() - Loaded version 6.2.16.0, C:\Aloha\bin\IBERSTR.DLL"
Jun 24, 14:57:11,, [INFO],,"Connected to Relational Database (Access)."
Jun 24, 14:57:11,, [INFO],,"MNT4X.DLL in InitInstance..."
Jun 24, 14:57:11,, [INFO],,"LoadIberStrings() - Loaded version 6.2.16.0, C:\Aloha\bin\IBERSTR.DLL"
Jun 24, 14:57:11,, [INFO],,"Connected to Relational Database (Access)."
Jun 24, 14:57:11,, [INFO],,"Connected to Relational Database"
Jun 24, 14:57:11,, [INFO],,"Mnt4x: Total Disk Space = 1117224960 bytes. Free = 1212338176 bytes"
Jun 24, 14:57:11,, [STATUS],,"MNT4X.DLL initializing on workstation ALOHABOH... version 6.2.16.1183.2 "
Jun 24, 14:57:11,, [INFO],,"TIMEZONE=NO DST - setting TZ to prevent spring forward or fall back"
Jun 24, 14:57:11,, [INFO],,"WARNING: This computer's Time Zone has non-zero values for StandardStart and DaylightStart dates."
Jun 24, 14:57:11,, [INFO],," Either select the correct time zone which does not honor DST or"
Jun 24, 14:57:11,, [INFO],," remove 'TIMEZONE=NO DST' from Aloha.ini to have Aloha software use US DST."
Jun 24, 14:57:11,, [INFO],,"Database Versions and Generation are Current."
Jun 24, 14:57:11,, [INFO],,"MNT4X.DLL - Running Aloha Table Service..."
Jun 24, 14:57:12,, [STATUS],,"USERTOOL.DLL initializing... version 6.2.16.1183.2 "
Jun 24, 14:57:12,, [INFO],,"AlohaLab.DLL in InitInstance..."
Jun 24, 14:57:12,, [INFO],,"Before CoFreeUnusedLibraries"
Jun 24, 14:57:12,, [INFO],,"AlohaLab.DLL exiting..."
Jun 24, 14:57:12,, [INFO],,"EDTPUNCH.DLL exiting..."
Jun 24, 14:57:12,, [INFO],,"CTL4X.DLL exiting..."
Jun 24, 14:57:12,, [INFO],,"After CoFreeUnusedLibraries"
Jun 24, 14:57:12,, [INFO],,"*****After NewModuleAdded"
Jun 24, 14:57:12,, [INFO],,"*****After AlohaMgr OnLogin"
Jun 24, 14:57:12,, [INFO],,"*****End of InitInstance"
Jun 24, 14:57:16,, [INFO],,"CTL4X.DLL in InitInstance..."
Jun 24, 14:57:16,, [STATUS],,"CTL4X.DLL initializing... version 6.2.16.1183.2 "
Jun 24, 14:57:16,, [INFO],,"CAlohaMgrApp::RequestCtlSvr() called..."
Jun 24, 14:57:16,, [INFO],,"LoadIberStrings() - Loaded version 6.2.16.0, C:\Aloha\bin\IBERSTR.DLL"
Jun 24, 14:57:16,, [INFO],,"Connected to Relational Database (Access)."
Jun 24, 14:57:16,, [INFO],,"Connected to Relational Database - CTL4X"
Jun 24, 14:57:16,, [INFO],,"Initializing store terminal manager"
Jun 24, 14:57:16,, [INFO],,"DAO Version 3.6"
Jun 24, 14:57:16,, [INFO],,"Done initializing store terminal manager"
Jun 24, 14:57:16,, [INFO],,"Reading stores and terminals..."
Jun 24, 14:57:16,, [INFO],,"Done reading stores and terminals"
Jun 24, 14:57:16,, [INFO],,"CTL4X: Successfully launched: C:\Aloha\bin\rpt.exe /RP /IBERDIR C:\Aloha /SQLMODE /USERNAME SPR /PASSWORD XXXXXXXX"
Jun 24, 14:57:17,, [INFO],,"LoadIberStrings() - Loaded version 6.2.16.0, C:\Aloha\bin\IBERSTR.DLL"
Jun 24, 14:57:17,, [STATUS],,"RPT started... version 6.2.16.1183.2 "
Jun 24, 14:57:17,, [INFO],,"Command Line: C:\Aloha\bin\rpt.exe /RP /IBERDIR C:\Aloha /SQLMODE /USERNAME SPR /PASSWORD XXXXXXXX"
Jun 24, 14:57:17,, [INFO],,"TIMEZONE=NO DST - setting TZ to prevent spring forward or fall back"
Jun 24, 14:57:17,, [INFO],,"WARNING: This computer's Time Zone has non-zero values for StandardStart and DaylightStart dates."
Jun 24, 14:57:17,, [INFO],," Either select the correct time zone which does not honor DST or"
Jun 24, 14:57:17,, [INFO],," remove 'TIMEZONE=NO DST' from Aloha.ini to have Aloha software use US DST."
Jun 24, 14:57:17,, [INFO],,"Database Versions and Generation are Current."
Jun 24, 14:57:17,, [INFO],,"Connected to Relational Database (Access)."
Jun 24, 14:57:17,, [INFO],,"The Username was SPR, & empId evaluated to 0"
Jun 24, 14:57:17,, [INFO],,"AggQuery: Could not connect to relational database.
Error: Data source name not found and no default driver specified
"
Jun 24, 14:57:18,, [INFO],,"AggQuery: Could not connect to relational database.
Error: Data source name not found and no default driver specified
"
Jun 24, 14:58:26,, [INFO],,"CTL4X.DLL exiting..."
Thanks in advance!
I'm trying to keep on track of sales data of each items...
However I'm getting "Could not get min DOB from SQL RDB. Check Debouts for more details"
Screenshot here:
Below are the debout files:
Debout.SQL
Jul 25, 23:42:46
Jul 25, 23:42:46 ...............................................................
Jul 25, 23:42:46 ***** DrSql 6.0.0.20 Alpha started... (Doctor SQL) *****
Jul 25, 23:42:46 iberdir = C:\Aloha
Jul 25, 23:42:46 LoadIberStrings() - Loaded version 6.2.16.0, IBERSTR.DLL
Jul 25, 23:42:46 LoadIberStrings() - WARNING: Application version = 6.0.0.20, IberStr.dll version = 6.2.16.0.
Version difference may cause problems.
Jul 25, 23:42:46 Could not create sql server object. CoCreateInstance failed.
Jul 25, 23:42:53 ***** Doctor SQL DB App Ended *****
Debout.txt
Jun 24, 14:56:53,, [STATUS],,""
Jun 24, 14:56:53,, [STATUS],,"............................................................"
Jun 24, 14:56:53,, [STATUS],,"AlohaMgr starting... version 6.2.16.1183.2 "
Jun 24, 14:56:53,, [INFO],," MODE SETTINGS"
Jun 24, 14:56:53,, [INFO],,"***** Version: 6.2.16.1183.2 "
Jun 24, 14:56:56,, [INFO],,"Unable to read ESP.EXE version string for file - C:\Aloha\Backoffice\Schedule\ESP.EXE"
Jun 24, 14:56:56,, [INFO],,"LoadIberStrings() - Loaded version 6.2.16.0, C:\Aloha\bin\IBERSTR.DLL"
Jun 24, 14:56:56,, [INFO],,"***** Workstation: ALOHABOH"
Jun 24, 14:56:56,, [INFO],,"***** TableService Only"
Jun 24, 14:56:56,, [INFO],,"***** Using SQLMODE"
Jun 24, 14:56:56,, [INFO],,"***** Relational database: Access"
Jun 24, 14:56:56,, [INFO],,"***** Site Id: 0"
Jun 24, 14:56:56,, [INFO],,"*****Start of WORK in InitInstance"
Jun 24, 14:57:01,, [INFO],,"*****Before AlohaMgr create"
Jun 24, 14:57:02,, [INFO],,"*****Before AlohaMgr RequestCtlSvr"
Jun 24, 14:57:02,, [INFO],,"CAlohaMgrApp::RequestCtlSvr() called..."
Jun 24, 14:57:02,, [INFO],,"WaitForCtlSvrStartupComplete()..."
Jun 24, 14:57:02,, [INFO],,"ACtlSvrConnect: (thread) - Begin Run()"
Jun 24, 14:57:03,, [INFO],,"ACtlSvrConnect: (thread) - startup complete."
Jun 24, 14:57:04,, [INFO],,"WaitForCtlSvrStartupComplete()...complete."
Jun 24, 14:57:04,, [INFO],,"*****Before AlohaMgr OnLogin"
Jun 24, 14:57:04,, [INFO],,"ALOHASEC.EXE initializing..."
Jun 24, 14:57:06,, [INFO],,"LoadIberStrings() - Loaded version 6.2.16.0, C:\Aloha\bin\IBERSTR.DLL"
Jun 24, 14:57:06,, [INFO],,"In AlohaSec/LoadSecurityData, BEFORE reading SQL data files"
Jun 24, 14:57:06,, [INFO],,"DAO Version 3.6"
Jun 24, 14:57:06,, [INFO],,"In AlohaSec/LoadSecurityData, AFTER reading SQL data files"
Jun 24, 14:57:06,, [INFO],,"CBOHSecurity::SecuritySetup() - SQLMode - successful return."
Jun 24, 14:57:10,, [INFO],,"AlohaMgr Login: Dealer Password"
Jun 24, 14:57:10,, [INFO],,"*****Before NewModuleAdded"
Jun 24, 14:57:10,, [INFO],,"CTL4X.DLL in InitInstance..."
Jun 24, 14:57:10,, [STATUS],,"CTL4X.DLL initializing... version 6.2.16.1183.2 "
Jun 24, 14:57:10,, [INFO],,"CAlohaMgrApp::RequestCtlSvr() called..."
Jun 24, 14:57:10,, [INFO],,"LoadIberStrings() - Loaded version 6.2.16.0, C:\Aloha\bin\IBERSTR.DLL"
Jun 24, 14:57:10,, [INFO],,"Connected to Relational Database (Access)."
Jun 24, 14:57:10,, [INFO],,"Connected to Relational Database - CTL4X"
Jun 24, 14:57:10,, [INFO],,"Initializing store terminal manager"
Jun 24, 14:57:10,, [INFO],,"DAO Version 3.6"
Jun 24, 14:57:10,, [INFO],,"Done initializing store terminal manager"
Jun 24, 14:57:10,, [INFO],,"Reading stores and terminals..."
Jun 24, 14:57:10,, [INFO],,"Done reading stores and terminals"
Jun 24, 14:57:11,, [INFO],,"EDTPUNCH.DLL in InitInstance..."
Jun 24, 14:57:11,, [INFO],,"TIMEZONE=NO DST - setting TZ to prevent spring forward or fall back"
Jun 24, 14:57:11,, [INFO],,"WARNING: This computer's Time Zone has non-zero values for StandardStart and DaylightStart dates."
Jun 24, 14:57:11,, [INFO],," Either select the correct time zone which does not honor DST or"
Jun 24, 14:57:11,, [INFO],," remove 'TIMEZONE=NO DST' from Aloha.ini to have Aloha software use US DST."
Jun 24, 14:57:11,, [STATUS],,"EDTPUNCH.DLL initializing... version 6.2.16.1183.2 "
Jun 24, 14:57:11,, [INFO],,"LoadIberStrings() - Loaded version 6.2.16.0, C:\Aloha\bin\IBERSTR.DLL"
Jun 24, 14:57:11,, [INFO],,"Connected to Relational Database (Access)."
Jun 24, 14:57:11,, [INFO],,"MNT4X.DLL in InitInstance..."
Jun 24, 14:57:11,, [INFO],,"LoadIberStrings() - Loaded version 6.2.16.0, C:\Aloha\bin\IBERSTR.DLL"
Jun 24, 14:57:11,, [INFO],,"Connected to Relational Database (Access)."
Jun 24, 14:57:11,, [INFO],,"Connected to Relational Database"
Jun 24, 14:57:11,, [INFO],,"Mnt4x: Total Disk Space = 1117224960 bytes. Free = 1212338176 bytes"
Jun 24, 14:57:11,, [STATUS],,"MNT4X.DLL initializing on workstation ALOHABOH... version 6.2.16.1183.2 "
Jun 24, 14:57:11,, [INFO],,"TIMEZONE=NO DST - setting TZ to prevent spring forward or fall back"
Jun 24, 14:57:11,, [INFO],,"WARNING: This computer's Time Zone has non-zero values for StandardStart and DaylightStart dates."
Jun 24, 14:57:11,, [INFO],," Either select the correct time zone which does not honor DST or"
Jun 24, 14:57:11,, [INFO],," remove 'TIMEZONE=NO DST' from Aloha.ini to have Aloha software use US DST."
Jun 24, 14:57:11,, [INFO],,"Database Versions and Generation are Current."
Jun 24, 14:57:11,, [INFO],,"MNT4X.DLL - Running Aloha Table Service..."
Jun 24, 14:57:12,, [STATUS],,"USERTOOL.DLL initializing... version 6.2.16.1183.2 "
Jun 24, 14:57:12,, [INFO],,"AlohaLab.DLL in InitInstance..."
Jun 24, 14:57:12,, [INFO],,"Before CoFreeUnusedLibraries"
Jun 24, 14:57:12,, [INFO],,"AlohaLab.DLL exiting..."
Jun 24, 14:57:12,, [INFO],,"EDTPUNCH.DLL exiting..."
Jun 24, 14:57:12,, [INFO],,"CTL4X.DLL exiting..."
Jun 24, 14:57:12,, [INFO],,"After CoFreeUnusedLibraries"
Jun 24, 14:57:12,, [INFO],,"*****After NewModuleAdded"
Jun 24, 14:57:12,, [INFO],,"*****After AlohaMgr OnLogin"
Jun 24, 14:57:12,, [INFO],,"*****End of InitInstance"
Jun 24, 14:57:16,, [INFO],,"CTL4X.DLL in InitInstance..."
Jun 24, 14:57:16,, [STATUS],,"CTL4X.DLL initializing... version 6.2.16.1183.2 "
Jun 24, 14:57:16,, [INFO],,"CAlohaMgrApp::RequestCtlSvr() called..."
Jun 24, 14:57:16,, [INFO],,"LoadIberStrings() - Loaded version 6.2.16.0, C:\Aloha\bin\IBERSTR.DLL"
Jun 24, 14:57:16,, [INFO],,"Connected to Relational Database (Access)."
Jun 24, 14:57:16,, [INFO],,"Connected to Relational Database - CTL4X"
Jun 24, 14:57:16,, [INFO],,"Initializing store terminal manager"
Jun 24, 14:57:16,, [INFO],,"DAO Version 3.6"
Jun 24, 14:57:16,, [INFO],,"Done initializing store terminal manager"
Jun 24, 14:57:16,, [INFO],,"Reading stores and terminals..."
Jun 24, 14:57:16,, [INFO],,"Done reading stores and terminals"
Jun 24, 14:57:16,, [INFO],,"CTL4X: Successfully launched: C:\Aloha\bin\rpt.exe /RP /IBERDIR C:\Aloha /SQLMODE /USERNAME SPR /PASSWORD XXXXXXXX"
Jun 24, 14:57:17,, [INFO],,"LoadIberStrings() - Loaded version 6.2.16.0, C:\Aloha\bin\IBERSTR.DLL"
Jun 24, 14:57:17,, [STATUS],,"RPT started... version 6.2.16.1183.2 "
Jun 24, 14:57:17,, [INFO],,"Command Line: C:\Aloha\bin\rpt.exe /RP /IBERDIR C:\Aloha /SQLMODE /USERNAME SPR /PASSWORD XXXXXXXX"
Jun 24, 14:57:17,, [INFO],,"TIMEZONE=NO DST - setting TZ to prevent spring forward or fall back"
Jun 24, 14:57:17,, [INFO],,"WARNING: This computer's Time Zone has non-zero values for StandardStart and DaylightStart dates."
Jun 24, 14:57:17,, [INFO],," Either select the correct time zone which does not honor DST or"
Jun 24, 14:57:17,, [INFO],," remove 'TIMEZONE=NO DST' from Aloha.ini to have Aloha software use US DST."
Jun 24, 14:57:17,, [INFO],,"Database Versions and Generation are Current."
Jun 24, 14:57:17,, [INFO],,"Connected to Relational Database (Access)."
Jun 24, 14:57:17,, [INFO],,"The Username was SPR, & empId evaluated to 0"
Jun 24, 14:57:17,, [INFO],,"AggQuery: Could not connect to relational database.
Error: Data source name not found and no default driver specified
"
Jun 24, 14:57:18,, [INFO],,"AggQuery: Could not connect to relational database.
Error: Data source name not found and no default driver specified
"
Jun 24, 14:58:26,, [INFO],,"CTL4X.DLL exiting..."
Thanks in advance!