I have a CR written with OLEDB and I get an error when changing the datasource.

The error is "Logon failed; ADO Error Code 0x80040e4d"

Kbase Article 521897 explains the cause, and I have no doubt it's accurate, but it doesn't tell you how to correct.

Does anyone know how to change an OLEDB datasource and change the PDL at the same time?

TIA,
~Shane

yeah, this one is tricky. Because you cant change the command without changing the source but you cant change the source because the command will then be invalid. You have to play a little trickery on CR.

Instead of using the typical method of Set Data Source Location goto the Database menu and select "Log on or Off Database". Log off all current connections. Close out of that dialog, go back to the Database menu and select Database Expert, then right click on the command and select Edit. When it prompts you for the login credentials, change the Data Source to the location of the PDL you want to update to, enter the associated credentials, now you should get the OLE DB Query Builder and can change it from there.

hth,
Matt

BAutiful!!!

That was exactly what I needed.


Thanks,
~Shane