×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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!
  • Students Click Here

*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

How do I change .rpt from User DSN to System DSN?

How do I change .rpt from User DSN to System DSN?

How do I change .rpt from User DSN to System DSN?

(OP)
Thanks for stopping in and taking a look at my mess!

Question:
Is there an easy way to change the odbc driver from a user dsn to a system dsn without having to create the whole report?

Scenario:
My boss has created about 15 reports (on his computer but the reports are stored on a network vol.)  by creating database connections through User DSN drivers instead of System DSN in ODBC. He has asked our department to add his reports to the intranet so the users can refresh the reports without having to ask him. We are using an NT box with IIS to host the Crystal Web Component. After countless problems we are finally able to view the reports, but now we can’t refresh them because the User DSN is only used by that one user and no one else. Well in the IIS world you have a web user that allows for anonymous access, and unfortunately the user logged onto the box and the web user are not one in the same. I know the connection is working because I can refresh the data by using crystal reports on the server but when I bring up the browser and try to refresh the report I get:

 Error connecting to database dll [page server ServerName]


Version: Crystal Reports 8

Thanks,
Veronica
vg00@swbell.net

RE: How do I change .rpt from User DSN to System DSN?

Veronica: Have you tried re-creating the UserDSN's as System DSN's and then choosing Set Location within the Report Designer? This will enable you to choose a different origin for each table used in the report i.e. move it from the User DSN to the System DSN and then propagate the same change through all the other tables used in the report.

There is a utility available (not tested on V8 but I think will work) which will swap one ODBC connection for another within a block of reports. Let me know if you need it (it may be more trouble than it's worth for only 15 reports )

David C. Monks
david.monks@chase-international.com
http://www.chase-international.com
Accredited Seagate Enterprise Partner

RE: How do I change .rpt from User DSN to System DSN?

(OP)
Thanks for the help. Once I created the System DNS exactly the same as the report was created and deleted the User Dns. I was able to connect to and refresh from the database using the Report Designer but I still get:

Error connecting to database dll [page server ServerName]

when trying to refresh the report from the Web viewer. I found a .pdf file on Crystal's web site and I am working through the troubleshooting steps so far it hasn't been much help. If you've heard of this happening before and have any suggestions I would appreciate them. Thanks!

RE: How do I change .rpt from User DSN to System DSN?

blai00: Veronica, check and make sure that you've cleared the cache before rying to view the revised report from your Web Server - I suspect that it's still looking at the old definition.

David C. Monks
david.monks@chase-international.com
http://www.chase-international.com
Accredited Crystal Decisions Enterprise Partner

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