SetLogonInfo has stopped working for changing databases in VB6

[tigertechie2]

I have used FAQ768-5374 (How do I change Database Location at runtime VB6 - RDC) to change Database location at runtime, and this has worked well for some time now.

ie using the .SetLogonInfo method using Crystal Reports 8.5 ActiveX Designer Runtime Library

It has stopped working and I am not sure why as the code or Crystal Reports have not been changed.

It is quite strange because the value of .LogOnServerName property changes from the old DSN to the new DSN when I call the .SetLogonInfo method, but the report does not display the data from the new location.

I have tried this for ODBC and OLEDB database drivers and get the same result.

Has anyone come across this before or seen any issues that may help me?

Many thanks

Tigertechie

 

[tigertechie2]

Sorry, should have stated
I am using VB6, Microsoft SQL Server 2000, and Crystal Reports 8.5