Guys!

I'm using MSSQL2000, VB6 and Crystal Report 8.5

My application is working fine. I'm able to produce report from MSSQL down to CR 8.5. I'm using "Crystal Report Contro"l to access .rpt within my VB6 application.

The problem started when we are using several MSSQL server. since all my .rpt is configured only to one server, i would have to encounter some report errors e.g. "cannot connect specified server".

Please help me to connect Crystal Report to SQL Server programmatically using VB6. I think i could help me a lot to resolve this issue.

Thanks a lot.