×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Error accessing via Crystal Reports

Error accessing via Crystal Reports

Error accessing via Crystal Reports

(OP)
Pervasive SQL 8.7
Crystal Reports 8.5

When I try and connect via Crystal Reports I get the following error:

Crystal Reports: Database Error

ODBC error:[Pervasive][ODBC Client Interface][Client LNA]Connection attempt timed out. The SQL Connection Manager may be inactive or using a different transport protocol from the client.

My ODBC connection is fine as I've been able to connect to the db via Access as well as my app (Delphi using the SDK) and the Pervasive Control Center.

My CRW 8.5 used to work fine when I had Pervasive SQL 2000.

Paul Wesson, Programmer/Analyst
www.ipaw.net


 

RE: Error accessing via Crystal Reports

If you're using the same ODBC DSN from Crystal and Access, then it should be working correctly.  
Where's the data (local or remote)?  
I know Access will cache connection info.  I'm not sure about Crystal. If it does, you might need to recreate the ODBC Connection in Crystal.  

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Error accessing via Crystal Reports

(OP)
The db is local and I also tried re-creating the ODBC connection from within Crystal, but no luck.

Paul Wesson, Programmer/Analyst
www.ipaw.net


 

RE: Error accessing via Crystal Reports

Hi, pwesson

   You may wish to visit the Crystal Reports web site to find out whether the version of Crystal you are using is compatible with your version of pervasive.  I think perhaps they are not.

Regards,

William Chadbourne
Oracle DBA

RE: Error accessing via Crystal Reports

I have Pervasive 8.6 and crystal 8.5 and they work fine together.  What if you do not use ODBC and connect directly to file.ddf?  Can you read the tables then?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz

RE: Error accessing via Crystal Reports

(OP)
Connecting using the FILE.DDF did the trick, thank you very much.

I'm still going to try and find out why it doesn't work using the Pervasive ODBC driver. If/when I find anything I'll post it here.

Paul

Paul Wesson, Programmer/Analyst
www.ipaw.net


 

RE: Error accessing via Crystal Reports

(OP)
I discovered a problem when I was creating the new report using a CSV file to report from. I could do everything but save my report. When I tried to save I got an "invalid file handle error"???? ya, I know, hugh?

Anyway after doing some searching on the web for this problem someone mentioned trying to run Crystal in Windows 2000 compatibility mode. After setting the crw32.exe to windows 2000 compatibility mode, everything worked just fine.

I can now access my Pervasive DB directly via the ODBC!

Paul Wesson, Programmer/Analyst
www.ipaw.net


 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close