Data source name not found and no default driver specified

[Jeffreytopia]

I am using CR8 in a VB6 design environment. I am getting the following error when attempting to run a report on several users PC's. The odd thing is that I do not receive this error when I run the reports using the same executable on my PC. Here is the error message I am receiving:

______________________________________________________
Seagate Crystal Reports: Database Error

Microsoft OLE DB Provider for ODBC Drivers:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

Server has not yet been opened
______________________________________________________

In the past I would simply re-verify the database and the problem would be solved. In this case, when I attempt to re-verify, it shows that my database connection is up to date.

Why am I able to run this executable successfully on my PC and not that of my users? Anyone? Help appreciated.

thank you

 

[vidru]

Looks like an ODBC issue. Did you set up the same DSN the same way on the other client machines?

-dave

 

[Jeffreytopia]

Thanks vidru,

You hit the nail on the head.

Problem:
Report was set to MS Access Database 97 location. Client machines set to MS Access Database location. Our machines had both (which is why they were running fine for us)

Solution:
Made following changes to the report in design environment of our project as opposed to changing DSN on all of the client machines:
1) Database / Set location / ODBC / MS Access Database
2) Database / Convert Database Driver (Pdsmon.dll)
3) Reverify Database