cancel
Showing results for 
Search instead for 
Did you mean: 

ODBC, BOE 3, SQL SErver 2005, and linux

Former Member
0 Kudos

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=

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi Paul,

can you please look at the following information from Microsoft:

[http://support.microsoft.com/kb/942861]

Not sure if this applies in your case but led to similar error messages when accessing a SQL 2005 DB from BOE

Regards,

Stratos

PS: I assume that you have added the lib path of your ODBC driver in the LD_LIBRARY_PATH environment variable.

Edited by: Efstratios Karaivazoglou on May 1, 2009 11:35 PM

Answers (0)