I have a single user that gets a prompt to select the OLE DB Provider no matter what report they try to run. Is this a matter of recreating the ODBC connection? Please Advise.
*This post is locked for comments
I have a single user that gets a prompt to select the OLE DB Provider no matter what report they try to run. Is this a matter of recreating the ODBC connection? Please Advise.
*This post is locked for comments
I've asked you to check the native client in my previous post as well :).
For what it's worth I finally figured it out. It seems something about those reports were written in an older version of Crystal. I had to download and install the SQL Native Client 2005 version, then recreate the ODBC connection with that option.
After extensive digging around I still could not find any solution. I ended up reformatting the computer and installing Win10. Unfortunately I STILL get the same exact prompt.
The only difference I can find with other ODBC connections on other workstations is that some of them have SQL Native Client connections and Win10 apparently only has SQL Server Native Client options
Please verify the OLEDB(ADO) with the working one and check whether it is using the SQL native client or SQL server and also verify the database once more in the crystal report if it is locally placed.
There is a user in SQL called crystalreports that everyone is using
what kind of authentication you are using for the OLEDB. Are you using the 'sa' user?
Wouldn't that change the login for everyone? It's just this one user that has this issue.
go to the database expert and set data source location and update it once again and save .
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156