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. I think this is VB code and I am not a developer. The application we run the reports through is managed by the owners.
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"
Where am I suppose to write this code? Is it just a one time thing?
The code and additional instuctions were found in the Report Designer Component 9 pdf file.
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. I think this is VB code and I am not a developer. The application we run the reports through is managed by the owners.
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"
Where am I suppose to write this code? Is it just a one time thing?
The code and additional instuctions were found in the Report Designer Component 9 pdf file.
