Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Crystal Report VB Active X Designer

Posted on 1999-07-28
6
Medium Priority
?
223 Views
Last Modified: 2013-12-26
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.
0
Comment
Question by:Auerelio Vasquez
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 

Accepted Solution

by:
Annette Russell earned 200 total points
ID: 1495666
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.
0
 
LVL 1

Author Comment

by:Auerelio Vasquez
ID: 1495667
how can i get this driver???? PDSODBC
0
 

Expert Comment

by:Annette Russell
ID: 1495668
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.
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 1

Expert Comment

by:ndubow
ID: 1495669
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.
0
 
LVL 1

Author Comment

by:Auerelio Vasquez
ID: 1495670
shoot! i don't want to buy anything!
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 6821958
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.

http://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
http://www.experts-exchange.com/jsp/zonesAll.jsp
 
Thanks,
Moondancer
Moderator @ Experts Exchange
0

Featured Post

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses

660 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question