Citrix Xpe, Crystal Reports, ODBC problem

[chaosagent]

Hi Folks,
I have a bit of a problem with Crystal Reports 9 running over Citrix XPe. The reports are hooked to an Interbase Db via ODBC drivers. Users can run CR from an ICA client but when they try to enter new parameter values a db logon box displays prompting for relevant user/pwd. When entered the message is returned:

Logon Failed
details 08001: [gemini interbase odbc driver][interbase] unavailable database

I have tried several different drivers and made sure the dlls are in c:\winnt\system32. Thats the extent of my knowledge tho. Anyone know what I need to do to make the db available?

Thanks

 

[CitrixEngineer]

I haven't used CR9 or Interbase, but I'd guess the principles are the same;

1) Was CR installed in change user /install mode? For CR8.5, I have found this to be flawless.

2) Have you set up a System DSN for CR to use, and are the users logging into the database via the DSN in CR?

Hope this helps CitrixEngineer@yahoo.co.uk

 

[tbhatt]

You may also need to copy the Crystal dll's into the users profile as well, put them in the windows folder as normal and give it a shot.

 

[chaosagent]

Dear citrixengineer and tbhatt,

Thanks for the thoughts. citrixengineer had part of the answer in using a system dsn not a user dsn which I should have known...duh! However that alone didnt solve the problem.

FYI cr9 doesnt seem to allow the change user mode that is mentioned. My understanding is that cr8.5 is still the enterprise release and I assume thtis is a feature of that one.

Tbhatt, I didnt get to your solution because I fixed it before that but thanks anyway.

To anyone else having the same trouble heres what I did to make it work.

Firstly I made sure the db is allowed 'read' by the anon citrix users in XPe.

Second I set up a Gemini Driver SYSTEM DSN

Third and most importantly I set the network protocol to TCP/IP in the advanced settings and filled in a default user and password for outside users to have read access.

Thats it. Now CR prompts for odbc details and I just hit enter and voila, connect. If I change the protocol to local I revert to the same error so my conclusion is that there is some problem in the message passing between the various apps and hence why the Intersolv driver wont work for me as it is limited to a default local protocol.

Cheers

 

[CitrixEngineer]

I had a similar problem, where the SQL driver defaults to Named Pipes - as soon as I switched to TCP/IP, it all worked! With the Oracle 8.1.7 client, I found I had to disable MTS support (which I also do for the Data Store and Summary Datbase).

Not sure what you mean by

Quote /"...cr9 doesnt seem to allow the change user mode that is mentioned..." /Quote

What I meant was simply open a cmd prompt and type "change user /install", THEN run setup from the CD, or close the CD drive and let it autostart, or whatever. In install mode, all necessary changes are propagated to the users. CR shouldn't have a choice in the matter!

Glad you got it working!

CitrixEngineer@yahoo.co.uk