Please help me regarding vb6, crystal report 8.5 and mssql 2008 r2 compartibility. My old setup was vb6 , CR 8.5 and ms-sql 2000 was working fine, after migration from mssql 2000 to ms-sql 2008 r2 my report giving error lie '20599 and Cannot Open Sql Server ' message
Thanks for reply, I am using OLEDB and DSN also created. My problemis for single table used in CR 8.5 report work fine in CR 8.5 preview as well as in VB codeing. But if I used multiple table in Crystal report its shows in preview but when i call thru VB codeing its giving error.
Please see the attached zip file contained .rpt. If I open this file in CR 8.5 and preview its work fine. but in vb its giving error '20599' Cannot open SQL server. If I try for single table in report and call in VB its work fine. The problem is with multiple table used in report.
thanks for helping , I am linking table thru visuallinkingexpert thru only. When I making report using CR 8.5 and previewing in cr 8.5 its work, but same report when calling thru above code in VB6 its giving error. Same code for single table report its work fine.
If you are linking tables inside the rpt then why set the query in code?
If I try without query in code still same message ''20599' Cannot open sql server'. IF above same vb code use for single table crystal report its work fine.
When you are posting code into the forum, can you please remember to surround it in [code][/code] or [highlight][/highlight] tags? It makes it a lot easier to read. I have done this for you in your above posts.
The OCX, and Crystal Reports 8.5 have been gone for a very long time. SQL Server 2008 came out well after the retirement of both CR8.5 and the OCX. If your VB6/OCX application was working with SQL Server 2000, and now it's not working with SQL Server 2008 then it's more likely that the database drivers aren't recognizing some change from SQL Server 2000 to SQL Server 2008.
The fact that you say about the rpt is working in CR ide and not when is called from the VB6 app tells me that the problem is in the OCX
I would recomend to upgrade your code to RDC and if it's possible to a newer version of CR
JG
... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
The OCX, and Crystal Reports 8.5 have been gone for a very long time. SQL Server 2008 came out well after the retirement of both CR8.5 and the OCX. If your VB6/OCX application was working with SQL Server 2000, and now it's not working with SQL Server 2008 then it's more likely that the database drivers aren't recognizing some change from SQL Server 2000 to SQL Server 2008.
The fact that you say about the rpt is working in CR ide and not when is called from the VB6 app tells me that the problem is in the OCX
I would recomend to upgrade your code to RDC and if it's possible to a newer version of CR
If in CR I used only one table and preview then report its work same in vb also work.If I used multi table and view in CR its work fine but in vb its shows error '20599 cannot open sql server' my predictin is that my code is correct but for multi table link some setting is required.Please let me no good solution for this.