Could not change Datasource

[Former Member]

Hi,

I am migrating a web application with crystal report viewer to display lots of crystal reports.

The old environment

32bit window 2003 IIS 6, .NET 3.5

32bit Window 2003 SQL 2005

Crystal report XI R2 SP2, VS 2005

The new environment:

64 bit Window 2012 IIS 8.5 CRforVS_redist_Install_32bit_13_0_15 (+CRforVS_redist_Install_64bit_13_0_15), .NET 4.5

64 bit Window 2012 SQL 2014, .NET4.5, VS 2012

Developing machine: Window 7 64 bit, VS2012 + CRforVS_13_0_15

My problem:

I could not change the data source in the report. When the data source in code does not match the one in the report, the report does not work. I tried both odbc (both system dsn and file dsn) and ole db, same problem.

For example, I set ole db as data source in the report, server name is Earth2, it is SQL user. 

when the server name in the code is Earth2, the report displays the data without any issue

when the server name in the code is another server name or IP address to Earth2 itself, I get the login window, the Server is still Earth2, password is empty. After I fill in the password manually, the report works.

The code should be fine, it works fine in old environment (be able to change data source there) and no difference comparing with samples online.

Any advice is highly appreciated.

Thanks in advance.

[former_member11696 · Accepted solution]

LOTS of post on how to change data sources in an application.

PLEASE search before posting...