Answer: 

~~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

 

Required Tags:

Article Type: 
Product Info
Product Line: 
Abila Millennium
Product Module/Feature: 
Tools-System
Product Version: 
2015.1

Optional Tags:

Database Engine: 
SQL Server 2012
Ranking: 
0

No votes yet