• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 248
  • Last Modified:

Crystal Reports Problem

Hello I'm using the Report Designer for Crystal Reports 6.0.  The problem that I'm having is that when I go to open the report it is saying ODBC login failure.  When I created the report I put in a valid Username and Password assuming it would use these durin execution, but it does not seem to be using these and I can't find where to set them.
0
clsmaster
Asked:
clsmaster
1 Solution
 
kponderCommented:
Assuming you are using VB & Sql Server try the following:

crwReports.Connect = "DSN = server;UID = username;PWD =password;DSQ = databasename"

Of course, change server,username,password, and databasename to match your system
0
 
sridharpCommented:
If you are using SQL server or client then first log onto the sql server or client and then you will not get any problem. Do write this and mail me back please
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now