Database Login

[jeffg22]

Hi -

I have a VB.NET Windows application that is using CrystalReports.NET. I think I've followed all of the BOL examples and discussion group recommendations, but I'm still getting a database login prompt when running a report. Here's my code for the connection info:

Dim crTableLogonInfo As New TableLogOnInfo
Dim crTables As Tables
Dim crTable As Table

crTables = PeopleList.Database.Tables

For Each crTable In crTables
crTableLogonInfo = crTable.LogOnInfo
crTableLogonInfo.ConnectionInfo.ServerName = strServer
crTableLogonInfo.ConnectionInfo.DatabaseName = strDBPathName
crTableLogonInfo.ConnectionInfo.UserID = strUserID
crTableLogonInfo.ConnectionInfo.Password = strPassword
crTable.ApplyLogOnInfo(crTableLogonInfo)
Next crTable

I've stepped through the code, and all the variables are correct. All of the ConnectionInfo properties are set correctly (and are displayed in the prompt window) except for Password. strPassword is an 8-character string, but ConnectionInfo.Password is an empty string.

When I enter the correct password in the login prompt, the report runs. But, of course, I'd like to get rid of the prompt.

Can anyone see what I'm doing wrong??

Thanks for your help.

- Jeff

 

[jeffg22]

Of course! As soon as I posted this question, I found the cause of my problem. I apologize to all for taking up bandwidth.

FYI, the issue was that my databasename property was the full path and file name of the SQL data file. (I swear I read somewhere that that was how it should be!) When I changed it to just the database name, the report ran without the prompt.

- Jeff

 

[susani]

Is your database an access database?
I don't know what to put in for server, userid, and password
as there are none on my access database.

 

[jeffg22]

Hi susani -

No, sorry, it's not an Access database. I'm using MSDE as my database engine.

Since I've never used CrystalReports with an Access database, I can't offer any helpful guidance.

- Jeff

 

[pelajhia]

Susani - default userid is Admin, no password, however you may wish to change this. There are two ways to set up passwords in Access if you want. I am not sure what to user for the server reference.

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp