[RESOLVED] Changing Datasource in VB6 using Crystal 10

I am trying to change the datasource in VB6 and CR10. I am tying to pass the recordset to Crystal which has the password and username in it. I still get a login failed error. ADO Error Code 0X80040e4d

If I change the properties for the connection in CR to integrated the report runs. I need to use a non-integrated approach where I can controll the user and password.

Any suggestions?

I found the answer myself. By using the report.database.table(1).connection properties("Password")="password" this works.