Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Express & report
Message
From
28/07/2007 07:39:14
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Reporting Services
Title:
SQL Express & report
Miscellaneous
Thread ID:
01244339
Message ID:
01244339
Views:
54
Before, all of my reports whose connection is using "SQL Server"
Now, i want to use SQL Express instead. I can run the system well, but the report fails
**I got over 100 reports and I don't want to re-write them . How can I use the same report under SQL Express? Thanks

Dim ReportTemp As New ReportDocument

Try
ReportTemp.Load(_report)

For Each table In ReportTemp.Database.Tables
pPrintSetting.GetInfo()
logoninfo = table.LogOnInfo
With logoninfo.ConnectionInfo
.ServerName = "DTS-MYSERVER\SQLEXPRESS"
.DatabaseName = "accountdb"
.UserID = ""
.Password = ""
.IntegratedSecurity = True

End With

table.ApplyLogOnInfo(logoninfo)

Next table
ReportTemp.RecordSelectionFormula = " {myinvoice.invo} ="123" " <-- got error . It said "Logon Fail ... , Unable to connect: incorrect log on parameters"
Please help
Next
Reply
Map
View

Click here to load this message in the networking platform