Connection to DB fails, works on dev machine
Posted on 2003-03-03
Im using Delphi 5, CR 9, connecting to a MS SQL Server DB. The application using the Delphi VCL (supplied with CR) to interface to the report. I have a report that is loaded at run time from the Delphi application, then attempts to connect to the DB using OLEDB (ie not ODBC). Works fine on my dev machine, but not the client PC. The client PC gets a "717 - Failed to Load database information".
Some sample code;
oCR.Connect.ServerName := '100.100.100.1';
oCR.Connect.UserID := 'query';
oCR.Connect.Password := 'queryit';
oCR.Connect.DatabaseName := 'ESCQuery';
oCR.Test <- Fails here.
I've installed all the DLLs I can find, but this is really getting annoying, can anyone help resolve this? Im fairly certain this is a DLL redistribution issue, but after reading seagate's doco on this Im no closer.