clydejones
Programmer
Hi Everybody,
I have an ASP application that runs cr 9.0 reports. The code I am using to log on to the main report and subreports here at the office is:
Set DatabaseTablesCollection = Session ("oRpt".Database.Tables
For Each Table in DatabaseTablesCollection
Table.SetLogonInfo "", "", "userID", "password"
Next
set dbLogon = session("oRpt".Database.Tables.Item(1)
dbLogon.SetLogonInfo cStr(serverName), CStr(dbName), CStr(userID), Cstr(password)
The problem is on one of our client's machine that once had cr 8.5 on it, this code does not work if I leave the subreports on the report. Here is the message I get:
Craxdrt Error Occurred On Server -2147189176
Details: ADO Error Code: 0x80040e4d
Source: Microsoft OLEDB Provider for SQL Server
Description: Login failed for user "userID"
SQL State: 4200
Native Error: 18456
This message doesn't tell me much as how to correct the problem. Any help will be appreciated.
Thanks,
Clyde
I have an ASP application that runs cr 9.0 reports. The code I am using to log on to the main report and subreports here at the office is:
Set DatabaseTablesCollection = Session ("oRpt".Database.Tables
For Each Table in DatabaseTablesCollection
Table.SetLogonInfo "", "", "userID", "password"
Next
set dbLogon = session("oRpt".Database.Tables.Item(1)
dbLogon.SetLogonInfo cStr(serverName), CStr(dbName), CStr(userID), Cstr(password)
The problem is on one of our client's machine that once had cr 8.5 on it, this code does not work if I leave the subreports on the report. Here is the message I get:
Craxdrt Error Occurred On Server -2147189176
Details: ADO Error Code: 0x80040e4d
Source: Microsoft OLEDB Provider for SQL Server
Description: Login failed for user "userID"
SQL State: 4200
Native Error: 18456
This message doesn't tell me much as how to correct the problem. Any help will be appreciated.
Thanks,
Clyde