CRWEB00000119

general discussion
1

Good Morning, Banging my head against the wall on this one.
-Fresh load of SAP Crystal Server 2011 on windows server 2008r2 64bit.
-Uploaded a .rpt that uses odbc against db2
-Set up database configuration in the file
-Click View and get this error.

The viewer could not process an event. The database logon information for this report is either incomplete or incorrect. []
---- Error code:0 [CRWEB00000119]

-Confirmed database name, password etc etc. Confirmed connectivity on the host tyhrough the lastest DB2 Client tool (9.7)

-The report runs fine from my pc, but this error on this server.

Thanks much,
Steve

arrowsmyth (BOB member since 2012-01-05)

2

Welcome to B:bob:B!

In Win server 2008, there are actually two ODBC Data Source Administrator tools:
C:\Windows\System32\odbcad32.exe
C:\Windows\SysWOW64\odbcad32.exe

If you created the system DSN in one of them, try creating the same system DNS also in the other one and check whether this resolves the problem.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Hi Thanks for your response. I had them set up under system 32 originally. When I was attemting to do the same thing for wow 64 I backed off when I got this warning. “The data source DB2RW already exists. Do you wish to overwrite the parameters in the DB2CLI.INI file?”

Not sure what that will do…

Thanks!

arrowsmyth (BOB member since 2012-01-05)

4

Me neither, I am sorry.

I had a similar problem before but that was not a DB2 database but SQL Server. The problem was solved by creating system DSN in the other ODBC Data Source Administrator.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

5

This was solved by uninstalling the 64 bit db2 odbc drivers and installing the 32 bit drivers. Apparantly, that’s what that error was trying tell me! (haha)

Thanks Marek!

arrowsmyth (BOB member since 2012-01-05)

6

Good to hear that you got it working. 8)

Marek Chladny :slovakia: (BOB member since 2003-11-27)

7

Hi,

I am facing the same issue, It works when I logon with the user with admin level of access where as it’s not working for user with Interactive level of access.

This issue started newly and we do not had this previously,users were able to access the reports.

Appreciated the help.

Regards,
Siva

looksmee :uk: (BOB member since 2006-02-08)