Delphi 7 Crystal 10 RDC

Posted on 2005-05-06
Last Modified: 2008-01-09
I was trying to find out how to change cysrtal data source, my Delphi 7 app can need to switch to various sql instances using ADO,
Crystal 10 does not change sucessfully

two attempts are as follows
number 1
  for i := 0 to (Crpe.LogOnInfo.Count - 1) do
//frmLocation.edtInstance.Text  name of the sql instance on the server

    Crpe.LogOnInfo[i].ServerName := GetComputerNetName() + '\' + frmLocation.edtInstance.Text;  
    Crpe.LogOnInfo[i].Password := 'sa';
    Crpe.LogOnInfo[i].DatabaseName := 'VoterNetWrk';
    Crpe.LogOnInfo[i].UserID:= 'vndata2005';

  crpe.DiscardSavedData ;
  Crpe.Connect.ServerName := GetComputerNetName() + '\'  + frmLocation.edtInstance.Text;
  Crpe.Connect.UserID := 'sa';
  Crpe.Connect.Password := 'vndata2005';
  crpe.Connect.DatabaseName := 'VoterNetWrk';

I found referances here to cr 9 using the RDC,  but having trouble on finding an example with CR 10
I would like a quick fix for now since I plan to move the whole apt to or Delphi.NET, but I need something working in the meantime.
Willing to try the RDC but would perfer not to at this point.
I know the VCL is going away.
any Ideas?

Question by:MichaelLuna
    LVL 4

    Accepted Solution

    Hi MichaelLuna,

    I don't think it's true that the VCL is going away. Just recently, BO releases the crystal report 11 VCL for delphi 7. Although BO don't have any VCL yet for Delphi 8 and up, I heard its on the way.
    If you don't have the Crystal report 10 VCL yet, you can get it here:

    I think there are few sample apps included when you install the VCL...not sure though.


    Author Comment

    I have the VCL installed
    I just need to changes the instance of msde/sql the report uses for the data source at run time.

    instance 1   CDMain\losAngeles
    instance 2   CDMain\SantaMonica

    The databases are names the same for each instance.
    A client could have up to 5 different citys.  Each is maintained serperately.
    VCL works great for everything else, I just need to changes the server instance.

    Author Comment

    Problems solved.
    The reports were based on a stored procecure which queried a table on another database in the same server.  Even with the same use login it just would not work.

    Had to reconfigure the program to only referance  on database, then switching servers no longer became a problem.

    Author Comment

    I guess 50 points for trying.  The answer was no help.
    Thanks anyway

    Author Comment

    Yes, How do I do that?
    LVL 100

    Expert Comment

    Points are reduced.

    Select ACCEPT to the right of the chosen comment.

    If there are several comments then click the link below this one that says SPLIT POINTS.


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now