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 Member]

If you are still having this issue, I found a solution that worked for me. I had the exact same issue as you have described. What I ended up finding was that the difference, and difference maker, was in the SQL drivers installed. For those that worked, SQL Native Client 2012 (11.0) was installed. For those that didn't work, this version of the driver was missing (SQL Native Client 2008 (10.0) was installed).

Hope this helps you or others that find this post.