Database Driver Problems

[LeonelSanchezJr]

I have several reports which I have to use pdsodbc.dll as my Database Driver and I use a DSN as my File Data Source to grab my stored procedures.

The reports are all related and get the stored procedures from the same area. Can I use the same DSN file for all of my reports?

The DSN works great for my first two reports, but I am getting an error on my third report, "File Integrity Error". Why?

 

[kenhamady]

You can use the same DSN hundreds of time.
When do you get the error?
Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[LeonelSanchezJr]

I am using Crystal 8.5 for Publishing the reports on the web. I get the error within Crystal when I try to preview.

The error will say, "Can not open database", then, "File Integrity Error".

Furthermore, the Set Location menu shows that I am using a Microsoft Access Database; which I AM NOT USING.

 

[LeonelSanchezJr]

Another problem I noticed in Crystal is that under Current Connections, I have my real connection, then I also have a Connection with no name that I can't log off from.

 

[kenhamady]

Can you run the report within free standing Crystal? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[LeonelSanchezJr]

Sometimes it will run, and sometimes it gives me the errors mentioned above. I am going to reinstall Crystal 8.5 right now.