User name password prompt with CR 9 and .NET

[mrmtek]

We use VB.NET to call crystal reports, we just upgraded from 8.5 to 9.0 crw and now when we call reports we are prompted with user name password prompts. We had this problem with 8.5 , used the following code.

CrTables = crReportDocument.Database.Tables
For TableCounter = 0 To CrTables.Count - 1
crtableLogoninfos.Add(crtableLogoninfo)
crtableLogoninfo = crtableLogoninfos.Item(TableCounter)
With crtableLogoninfo.ConnectionInfo
.ServerName = RTrim(crwServerName)
.DatabaseName = RTrim(crwDatabaseName)
.UserID = RTrim(crwUserID)
.Password = RTrim(crwPassword)
End With
CrTable = CrTables.Item(TableCounter)
CrTable.ApplyLogOnInfo(crtableLogoninfo)
Next

Which worked ok with 8.5 but now with 9.0 we get prompted for user name and password, can any body solve this annoying problem?

 

[beexcel]

Can you please give some advice, I have the same problem with VB.NET.


Thanks.