Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Crystal report OLE DB Provider selection at launch

Posted on by Microsoft Employee

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

  • Tom Mathew Profile Picture
    Tom Mathew 1,750 on at
    RE: Crystal report OLE DB Provider selection at launch

    I've asked you to check the native client in my previous post as well :).

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Crystal report OLE DB Provider selection at launch

    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. 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Crystal report OLE DB Provider selection at launch

    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

  • Tom Mathew Profile Picture
    Tom Mathew 1,750 on at
    RE: Crystal report OLE DB Provider selection at launch

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Crystal report OLE DB Provider selection at launch

    There is a user in SQL called crystalreports that everyone is using

  • Tom Mathew Profile Picture
    Tom Mathew 1,750 on at
    RE: Crystal report OLE DB Provider selection at launch

    what kind of authentication you are using for the OLEDB. Are you using the 'sa' user?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Crystal report OLE DB Provider selection at launch

    Wouldn't that change the login for everyone? It's just this one user that has this issue.

  • Suggested answer
    Tom Mathew Profile Picture
    Tom Mathew 1,750 on at
    RE: Crystal report OLE DB Provider selection at launch

    go to the database expert and set data source location and update it once again and save .

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans