Skip to Content
0
Former Member
Feb 25, 2009 at 07:50 PM

Database logon coming up

56 Views

I am trying to call a report based on an Advantage database from a .net Application. This is the code that I use

d = New ReportDocument

d.Load("C:\test\bill.rpt")

d.SetDatabaseLogon("adssys", "MCSSTIME", "taxm_narrows", "C:\Development\Customer Data\data_narrows\TaxM.add")

CrystalReportViewer1.ReportSource = d

I get no errors but the problem is that the database logon box comes up every time. Also, when the box comes up, the server name and database are greyed out but I can see that they are the server/database that the report was based on, it doesn't change

I've also tried this:

Dim ci As ConnectionInfo

ci = New ConnectionInfo

ci.DatabaseName = "taxm.add"

ci.IntegratedSecurity = True

ci.Password = "MCSSTIME"

ci.UserID = "adssys"

ci.ServerName = "taxm_narrows"

d.Database.Tables(0).LogOnInfo.ConnectionInfo = ci

and This:

d.Database.Tables(0).LogOnInfo.ConnectionInfo

.DatabaseName = "taxm.add"

d.Database.Tables(0).LogOnInfo.ConnectionInfo

.IntegratedSecurity = True

d.Database.Tables(0).LogOnInfo.ConnectionInfo

.Password = "MCSSTIME"

d.Database.Tables(0).LogOnInfo.ConnectionInfo

.UserID = "adssys"

d.Database.Tables(0).LogOnInfo.ConnectionInfo

.ServerName = "taxm_narrows"

All of them end up with the same results. I can use this same code with SQL server and it's fine. what am I missing?