ERROR 599 CANNOT OPEN SQL SERVER

[jmcalis]

RECEIVING THIS ERROR WHEN ATTEMPTING TO RUN REPORT FROM COLDFUSION. MY SQL SERVER IS ON ANOTHER SERVER BUT HAVE AN ODBC CONNECTION TO IT. ANY HINTS?

 

[emallon]

Your not logged into the server. You need to set login information to open the database. I code in VB so maybe this applies to Cold Fusion as well. It can't hurt to try.
(This is the CR8 Automated Server application.)

Declare variables for CR8 however its done in CF:
Global CA As CRPEAuto.Application
Global CR As CRPEAuto.Report
Global DbName As CRPEAuto.Database
Global DbTbls As CRPEAuto.DatabaseTables
Global DbTbl As CRPEAuto.DatabaseTable
(this is VB code)

Next, set your application and open your report:

Set CA = CreateObject("Crystal.CRPE.Application&quot
Set CR = CA.OpenReport(Report Location and Name)

Next, set your database name and tables:
Set DbName = CR.Database
Set DbTbls = DbName.Tables
Set DbTbl = DbTbls.Item(1)

Next, Logon to server
Call DbTbl.SetLogOnInfo(server ID, "", User ID, PassWord)

Next, preview report.
CR.Preview

I hope this helps.