Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Express & report
Message
De
28/07/2007 07:39:14
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Services de reporting
Titre:
SQL Express & report
Divers
Thread ID:
01244339
Message ID:
01244339
Vues:
55
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform