• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 227
  • Last Modified:

Crystal Report VB Active X Designer

Does any one know why when using this control, everytime i start the program i get the following message:

microsoft old db provider for odbc drivers: [microsoft][odbcsqldrivers][sql server] login failed,

then i get a message saying that server has not started yet.

i have provided a dsn for this application, but it just doesn't work.
Auerelio Vasquez
Auerelio Vasquez
1 Solution
Annette RussellCommented:
1.  Make sure you are using ODBC32.
2.  Make sure that System DSN (not User DSN).
3.  You might try changing converting the database driver to the native driver in the report.  For example, the default in CR for SQL Server is PDSODBC.  The native driver for SQL Server is PDSSQL.

Hope this helps.
Auerelio VasquezETL DeveloperAuthor Commented:
how can i get this driver???? PDSODBC
Annette RussellCommented:
This dll comes with Crystal.  You can change the dll for your report. I'm not sure what version you are using but in version 6.0, in the Report Designer,  check Database -- Convert Database driver.  Try using the pdssql.dll since you are using sql server.
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

I had a similar problem. Seagate Tech support said that only the drivers which are loaded with the OCX control (when you install VB 6.0) are available. If you're trying to use ADO OLEDB - it won't work. You've got to buy Crystal reports 7.0, which has all the necessary drivers for SQL Server.

You can buy the upgrade rather than the full price version, because you've installed VB which has the CR OCX control.
Auerelio VasquezETL DeveloperAuthor Commented:
shoot! i don't want to buy anything!
This question was awarded, but never cleared due to the JSP-500 errors of that time.  It was "stuck" against userID -1 versus the intended expert whom you awarded.  This corrects the problem and the expert will now receive these points; points verified.

Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them.

This is the Community Support link, if help is needed, along with the link to All Topics since many new ones were recently added.

Moderator @ Experts Exchange
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now