We have a BOE 3.0/3.1 on redhat. Report development is in CR 2008. The target DB is sqlserver 2005. I configured ODBC on my decktop and designed a report using CR 2008. I created the identical data source in the BOE odbc.ini (see below). However, after uploading the report to the BOE server, reseting the DB configuration for the report (and saving it!), and scheduling the report I get the following error:
Error in File ~tmp14505a991646690.rpt: Unable to connect: incorrect log on parameters. Details: [Database Vendor Code: 11 ]
if I "view" the report:
The database logon information for this report is either incomplete or incorrect.
I know that the logon infor is correct. I know that I can access the target DB via ODBC ( I tested using FreeTDS as BOUSER). Is there anything obviously wrong in the ODBC.INI below? The connection is GpdDrakkenOdbc.
[ODBC Data Sources] CRSQLServerWP=DataDirect 5.1 SQLServer Wire Protocol Driver CRSybaseWP=DataDirect 5.1 Sybase Wire Protocol Driver CRText=DataDirect 5.1 Text Driver GpdDrakkenOdbc=DataDirect 5.1 SQLServer Wire Protocol Driver [CRSQLServerWP] Driver=/rmg/code/BO/bobje/enterprise120/linux_x86/odbc/lib/CRmsss21.so Description=DataDirect 5.1 SQLServer Wire Protocol Driver Address= Database= QuotedId=Yes AnsiNPW=No LogonID= Password= [GpdDrakkenOdbc] Driver=/rmg/code/BO/bobje/enterprise120/linux_x86/odbc/lib/CRmsss21.so Description=DataDirect 5.1 SQLServer Wire Protocol Driver Address=9188.8.131.52 Database=gpd QuotedId=Yes AnsiNPW=No LogonID= Password=