Member Avatar for Ali.M.Habib

We use vb.NET windows form program to pass parameters to crystal report wich execute sql commands

I use .NET 2003, crystal 9, windows server 2000 and SQL server 2000

at the above enviroment the reports application work very well

when migrate to SQL server 2005 , and windows 2003

the applications gave the following errors
- failed to open row set
- operation illegal on linked parameter

I made sure of the connections , I verified the database

I don't know how to fix those errors

any suggestion please

  • 3 Contributors
  • 4 Replies
  • 109 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by Ali.M.Habib
Member Avatar for Ali.M.Habib

Hi,

Please read this thread "failed to open row set".

it give no erro while connect to sql server 2000 while generate error in using sql server 2005

Member Avatar for pritesh2010

see this example. it will help you.

WindowsApplication1.zip (197.68 KB)
Member Avatar for Ali.M.Habib

see this example. it will help you.

Unfortunately I don't use dataset I wrote it in the crystal
Now the report give failed to open row set at showing last page and in export

any advice please

Best regards

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.