How to Logon Server and SQL Server

[sfsahiwala]

Dear All,

I have create VB6 application and using SQL Server 2000 Databases.

I have create Crystal Report 8.5 using Stored Procedures.

Every time the Server change or database name change.

I have to open all Crystal Reports files and do it manually.

I need VB6 code to set Database name and server when using crystal Report.

I am using OCX Control.

I have use CrystalReport.Logon

it fails.


Please advice

[techgnome]

It's been a long time since I do it but you can open the CR and then iterate through the report and sub reports... In the object model somewhere there is a method ChangeServer I think is what it is called, use that to reset the connection string for the reports and it should be fine.

-tg

[sfsahiwala]

Thanks for your reply..

Infact if you can show me coding through vb6 using ocx control.

How to change for the same.

Your reply is appreciate.

Thanking you

[techgnome]

That was over 15 years ago... and I no longer use CReports nor do I use VB6 any more... so you'll need to go looking through the documentation and the object model and see if you can find it. It should be obvious. It's either Set or Open followed by either Database or Connection or Server... it's some combination of those.

-tg