[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.
Re: Error : 20599 Cannot open SQL Server
I had found the root cause already.
The report contain subreport.
How can I make the connection in both ?
Re: Error : 20599 Cannot open SQL Server
problem Solved : set location of subreport table to new DSN.
Thanks