User prompted for Database Login with blank database catalog - but only on one machine

[former_member308135]

I have a set of Crystal Reports that has been working for a long time. Recently, a small subset of updated reports are now prompting one of my users for database connection information when the report starts:

There is a default connection in the report but only the server gets picked up, not the catalog.

This behaviour only happens on the one machine, none of my other users are experiencing problems. The function that sets the database connection was copied from one of Don's examples, long ago. We have recently upgraded all users to V22, but only one user is experiencing this strange problem and only with 2 reports - unfortunately the ones they use most often.

I have a standard report form with the Crystal Report Viewer embedded in it. This form uses the same code for all reports: 1 - set parameters, 2 - set database connection for report and all sub-reports.

Does anyone have any suggestions on how to debug this? I have been unable to see any differences between the users connection information (in a domain) on that machine vs any other machines. Needless to say, it works fine in development and is not reproduceable.

The environment is Visual Studio 2010, Visual Basic, SQL Server 2005.

Thanks, Neil

[brucegreer]

I've seen the same issue when I was using SQL Authentication and feeding in the Database and Server name. It would lose the Database name, and then prompt for it and not let you supply it. There is a depreciated SQL driver that Microsoft recommends not using anymore. Go into the set Datasource location and check the provider on your connection shown under properties. If it starts with sqlnclI?? then that is usually the problem. Create a new connection that uses SQLOLEDB and use the update feature to update your connection above. This is recommended by Microsoft. See image.screenshot-2022-12-06-174814.png

One other thing, once you do, some formulas may not work. It seems with this provider, it brings in date (not datetime) fields as strings. So if the formula uses a date field, like {acctreg.transactiondate} >= {?STARTDATE} then wrap the database column in a date wrapper like date({acctreg.transactiondate}) >= {?STARTDATE}. Otherwise you may get a string expected error on the parameter.

[former_member11696 · Accepted solution]

Hi Neil,

The reason it's prompting and no info displayed for the log on info is because CR runtime can't find the DB client.

Add these 3 parameters to the System Environment variables, and create the logging folder:

LOGGING_DIR = c:\logging
LOGGING_ENABLED_ASSERT = 1
LOGGING_ENABLED_RUNTIME = 100

Run the app until the error happens and stop. Have a look in the log and you should see what and possibly why it can't find the DB client.

Check your PATH statement, SQL Server should add the path to the client in it, it may be either not there or possibly in the wrong order if other Clients were installed. You can compare the PATH on working PC's to those 2 that are not working.

Don