|
-
Mar 3rd, 2009, 08:29 PM
#1
Thread Starter
Hyperactive Member
 [RESOLVED] Error : 20599 Cannot open SQL Server
Hi All,
Hope someone may help me 
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.
Where there is no hope, there can be no endeavor.
There are two ways of rising in the world, either by your own industry or by the folly of others.
-
Mar 3rd, 2009, 10:01 PM
#2
Thread Starter
Hyperactive Member
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 ?
Where there is no hope, there can be no endeavor.
There are two ways of rising in the world, either by your own industry or by the folly of others.
-
Mar 3rd, 2009, 10:26 PM
#3
Thread Starter
Hyperactive Member
Re: Error : 20599 Cannot open SQL Server
problem Solved : set location of subreport table to new DSN.
Thanks
Where there is no hope, there can be no endeavor.
There are two ways of rising in the world, either by your own industry or by the folly of others.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote