CR9 Logon Failed

[MRWARNER]

Have some reports (CR 9.0) that I open in a vb6 application, the db is SQL 2000 – I am connecting with ODBC
If I run the report in crystal I have no problem, when I try to open it in Application I get this message :

Logon failed.
Details:2800:[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'michele'.

I am Michele – I wrote the report in CR8 then later updated it to CR9 – When any other user runs this through the application it always says my name, regardless of who is logged in.

I have found that it has to do with the Connection Properties but I don’t understand the solutions being offered. It says to use this code, but I don’t know where to do this.

Dim ConnectionInfo As CRAXDRT.ConnectionProperties
'Set the Connection Info to Connection Properties of the table object
Set ConnectionInfo = Report.Database.Tables(1).ConnectionProperties
'Set the ODBC DSN
ConnectionInfo.Item("DSN") = "DSNName"
'Set the database name
ConnectionInfo.Item("Database") = "Database name"
'Set the user name
ConnectionInfo.Item("User ID") = "UserName
'Set the password
ConnectionInfo.Item("Password") = "Password"


The code and additional instuctions were found in the Report Designer Component 9 pdf file.

 

[vidru]

I responded to this thread: thread766-921981.

-dave