Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connecting a crystal report to MSDE

Status
Not open for further replies.

crisedefoie

Programmer
Feb 19, 2003
39
CA
Hello,
First I apologize for my english. I hope I'll be clear anyway.

I have to call a crystal report trough a MSDE connection.
When I call the same report with SQL Server my connection code works fine but I really don't know how to do with MSDE connection. I trie many different ways but they didn't works

This is my code (I simplified it for best reading)

With ConnectInfo
If ConnectType = MSDE Then
.ServerName = psServeurDadhri
.UserID = "login" ' Windows login
.Password = "password" 'Windows password
.DatabaseName = "Path" & DatabaseName
Else
.ServerName = psServeurDadhri
.UserID = login SQL Server
.Password = password SQL Server
.DatabaseName = "Path" & databaseName
End If
End with
tbCurrent.ApplyLogOnInfo(tliCurrent)
tbCurrent.Location() = Report.Database.Tables.Item(i).Name

Does someone know how to make it works?

Thanks

Helie
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top