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
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.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 VB.net 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.