Visual Basic Crystal Reports - VB 6, Crystal Report Control And Sql Sever 2005

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

VB 6, Crystal Report Control And Sql Sever 2005

jatinbhatt@gmail.com

2006-03-29, 7:06 pm

Hi,

I have written a VB6 application with Crystal Report Control ,Crystal
Reports 9 and Access 2000 database.

The VB6 application prints the reports using the CR control. Also, the
access database is located on a file server on the network.

Sample code being:
CR.ReportFileName = App.path & "\Test.rpt"
CR.Destination = crptToWindow
CR.PrintReport

This works absolutely fine.

I have now migrated from Access 2000 to Sql Server 2005.The problem
arises when i try to print the reports, i get an error number 20536 ,
the report window pops up and goes away.

The physical CR files reside on a file server on the network. These
reports point to SQL Server 2005 installed on an another machine on the
network. Earler these same files pointed to the access database (.mdb
file) on the same file server.

Please advice.

Thanks
Jatin

Sponsored Links