[RESOLVED] Error : 20599 Cannot open SQL Server

Hi All,

Hope someone may help me :thumb:

My system is going to migrate from one server to another new server.

Now I'm doing the migration for it. My crystal reports are connected by ODBC DSN. I had change the DSN Value. It work fine for all reports in my system.

All reports are connected using same methods, but one of the report is facin g a error - 20599 Cannot open SQL Server. It work fine with previous dsn but not the current.

Is someone faced this problem before.

Can someone give me an advice ?

Your help is fully appreciated.

I had found the root cause already.

The report contain subreport.

How can I make the connection in both ?

problem Solved : set location of subreport table to new DSN.

Thanks