SQL Connection Problem?
From: Jeff (jeff_nospam_at_eNetPortals.com)
Date: 07/23/04
- Next message: Hugo Sousa: "crviewer9.dll may be outdated error"
- Previous message: John Guilbert: "Unable to 'Preview' report on Crystal Reports 9 Management Console"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 23 Jul 2004 15:57:08 GMT
Hi -
I'm working with CrystalReports.NET to create a report for my VB.NET Windows
application, and I'm having trouble with (I think) the connection to my SQL
2000 database. When I try to run the report, I can't get rid of the login
prompt dialog, and no combination of entries into that dialog succeeds. I'm
going through Brian Bischof's book, and I haven't yet found the solution to
my problem.
My application runs fine without the report, and correctly
displays/processes data from the database. I'm using a SQL connection
object on the app's main form to connect to the database, and then using
dataadapters to fill various datasets. My connection string that seems to
be working for the database is:
"packet size=4096;user id=sa;data source="DESKTOP4600\ENP";persist security
info=True;initial catalog=SC01;password=mainpwd"
In the Standard Report Expert (shown when I create the new report), in the
Data tab, there are 'no items found' in the Current Connections subfolder of
the Project Data folder. I don't know whether that's a problem, and if it
is, I'd appreciate any suggestions for solving it. My project's datasets,
however, are listed in the ADO.NET DataSets subfolder of the Project Data
folder. So I select a single table from one of the datasets, and a single
field from that table in the Fields tab (this is just a test to get the
connection right).
I've added a form with a ReportViewer and a ReportDocument. The
ReportDocument is an instance of the just-created report. The
ReportViewer's ReportSource points to that ReportDocument. When I run the
app and display the viewer form, I get the Database Login prompt dialog,
displaying the name of my selected table and asking for Server Name,
Database, Login ID, and Password. The Server Name and Database fields are
comboboxes, and their pulldown lists have no entries (because no connection
items were found??). I've tried the entries in the above connection string:
Server Name: DESKTOP4600\ENP
Database: SC01
Login ID: sa
Password: mainpwd
Login fails. I've also tried the full path and filename for the database
file, and the Login still fails.
I've tried coding the entries before running the report with the same
result. I would think that I can't determine whether my code is correct
before I know the correct login entries to include. (I assume these are the
same entries that would allow me to successfully login through the Login
prompt.) What are the correct entries for the Login prompt? And, of
course, how do I get rid of the prompt to allow my users to login
automatically?
Please help.
- Jeff
- Next message: Hugo Sousa: "crviewer9.dll may be outdated error"
- Previous message: John Guilbert: "Unable to 'Preview' report on Crystal Reports 9 Management Console"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
