how to set logon info

[ramnagar]

hai,
could you please tell me how to setlogon info.I am using following code to setlogon info.


userid = "user"
password = "password"

set crtable = session("oRpt&quot.Database.Tables.Item(1)
crtable.SetLogonInfo "DB_WEB_CONFERENCE", "VDP", cstr(userid), cstr(password)

due to this problem i am getting two errors
1)"An Error has occured on the server in attempting to access the data source", when i use the report file after unchecking the option "save data with report " in seagate crystal report and then save the file .
2)"CRAXDRT error occured on server-server has not yet been opened" when i refresh the report which was saved with data in browser.

if i uncheck the option "save data with report" and then save the report file i am getting the above first error.

if any body knows about these please let me know.Since lastweek i am facing this problem.

thanks
ram

 

[bjrollet]

Try logging into the report before trying to use the Table object.

 

[ramnagar]

hi bjrollet,
thanks for reply.I am able to logon to the report without using table object.If i wont use this setlogoninfo i am able to get the result,but that is not updated one.I am getting the report file which i saved at the time of starting.
could you please tell me is there any relation between setlogon info and the error "An Error has occured on the server in attempting to access the data source".

thanks
ram