Skip to Content
0
Former Member
Feb 25, 2011 at 03:21 AM

Exact Steps on How to disable ODBC Connection Prompt

156 Views

I am using CR XI R2 and have upgraded my PC's (OS = Win7, 32-bit) IBM Universe ODBC driver to version 4.00.04.7346. When I first create a report it prompts me for the odbc user id and password which in the configuration I have already set it up to save the password. So after clicking OK, the report runs and I get the data. I save the report with the data. I close out of Crystal and and then bring up Crystal again and open my report. When I hit the refresh button, the ODBC connection prompt appears. All the login and password information already appear in the corresponding fields so all I have to do is press ok. In earlier versions of this driver, I did not get this prompt. It only prompts on a refresh if I have not origninally logged onto the server.

Is there a way to pass along my my odbc login information so the prompt will not appear? I have several scheduled reports that will not run, because of the odbc connectin prompt appearing.

The reason I had to upgrade the driver is because the Current Universe database was upgraded to 10.3.6 and the ODBC driver that works with this OS is the 4.00.

I have 'Googled' for information and found some, but it just does not makes sense like I can just change the SQLDRIVERCONNECT, but unfortunately it does not say where that is located or how to do that.

Thanks in advance for all your help!