~~Printers.exe Unable to get database platform information
Steps to Reproduce:
1. Browse to client’s defined queue
2. Launch hosted - MILLENNIUM2015\queue\Printers.exe
3. Prompted for Data Source
4. Designate & Authenticate to Web SQL (32-bit) connection object
Current result:
Printers.exe utility fails to launch. Error: Unable to get database platform information
Corrective Measure Taken:
1. Verify Millennium functionality
2. Verify Millennium reporting functionality using extant, defined printers
3. Created missing 64-bit Web SQL connection object on Millennium IIS Server
4. Verify Web SQL (32-bit & 64-bit) connectivity
Tools | system Upkeep | System Info
Reporting Information
Institution: Inst. name
HTML Report Location: \\hosted-millennium2015\reports
Report Template Format Location: \\hosted-millennium2015\formats
Default Format Location: \\hosted-millennium2015\formats\bio
Default Export Path: \\hosted-millennium2015\exports
Photos Location: <Blank> ... not yet defined
Reporting Queues
Queue: Queue
Queue Location: \\HOSTED-MILLENNIUM2015\queue
Database Computer: servername\millennium
Data Database: milldata
Primary Database Computer: servername\millennium
Reporting Printers
Queue: Queue
Printer Description: 02-304HP4250
Printer Location: ip address
Printer Name: \\servername04\02-304HP4250
Printer Driver: HP Universal Printing PCL 5 (v5.1)
Queue: Queue
Printer Description: 02-304HP4250-A
Printer Location: 10.2.30.13
Printer Name: \\servername04\02-304HP4250-A
Printer Driver: HP Universal Printing PCL 5 (v5.1)
Establish RDP to \\HOSTED-MILLENNIUM2015\queue
Launch \\HOSTED-MILLENNIUM2015\queue\printers.exe
Run test report to confirm Millennium reporting functionality
Mill78Test_YMF
sa
08/14/2015 01:44 PM
Report completed, selecting 5,744 records. Total Time: 00:00:41
2015/08/14==13:44:19 User: sa Report Name: Mill78Test_YMF Report Path: \\hosted-millennium2015\reports Destination: S
Workfile: dbo.wrk9B822368572200556_1
opening report: \\hosted-millennium2015\formats\bio\ROSTER THREE ACROSS.RPT <<<<<<<<<<<<<<<<<<<<<<
Report completed, selecting 5,744 records. Total Time: 00:00:41
Establish RDP to Millennium IIS\Queue Server \\HOSTED-MILLENNIUM2015\queue
Verify ODBC connection objects
%windir%\syswow64\odbcad32.exe | System DSN
Name: Web SQL
Server: servername\millennium
Default Database: milldata
Test connection:
Microsoft SQL Server ODBC Driver Version 06.03.9600
Data Source Name: Web SQL
Data Source Description: Millennium 32 bit ODBC
Server: servername\millennium
Database: milldata
Language: (Default)
Translate Character Data: No
Log Long Running Queries: No
Log Driver Statistics: No
Use Regional Settings: No
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No
64-bit Web SQL ODBC Connection object ... not present, created
%windir%\system32\odbcad32.exe | System DSN
Name: Web SQL
Server: servername\millennium
Default Database: milldata
Microsoft SQL Server ODBC Driver Version 06.03.9600
Data Source Name: Web SQL
Data Source Description: Millennium Web SQL (x64)
Server: servername\millennium
Database: milldata
Language: (Default)
Translate Character Data: No
Log Long Running Queries: No
Log Driver Statistics: No
Use Regional Settings: No
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No
Launch "\\HOSTED-MILLENNIUM2015\queue\Printers.exe" ... failed ... Unable to get database platform information
Resolution: Customer has *duplicate QUEUE directories
D:\inetpub\wwwroot\mill\QUEUE
*AND*
D:\QUEUE
Renamed D:\inetpub\wwwroot\mill\QUEUE to D:\inetpub\wwwroot\mill\QUEUE_OLD
Launch "D:\QUEUE\QueueAdmin.exe"
Uninstall Millennium Queue Service
Launch\Run Millennium Queue Application ("D:\QUEUE\Queue.exe")
Print activity queue reports immediately resumed & completed