Skip to Content
0
Former Member
May 01, 2009 at 05:13 PM

ODBC, BOE 3, SQL SErver 2005, and linux

26 Views

All,

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.

thanks..pf

[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=999.99.77.74
Database=gpd
QuotedId=Yes
AnsiNPW=No
LogonID=
Password=