Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Aloha Manager - Product mix error

Status
Not open for further replies.

m0dE

Vendor
May 8, 2009
30
0
0
CA
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!
 
It would seem that Aloha cannot connect to the data source. Are you using SQL??

 
I believe so.
Could you tell me how to verify if I am or not?
Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top