I guess I misstated, I had created a new report and had not saved the data. I want it to show fresh data every time they view it. I'm using SQL server for the data.
I found the answer though:
.oReport.Database.Tables(1).SetLogOnInfo("CQI-TERMSERV", "ctore", "ctore", "cqi$$")
Craig thanks alot, your article on your website is great.
Kirk