Re: Cannot Connect ADOConnection at Run-Time

Andy wrote: 
What is your ConnectionString ?

Andy
"Mike Sandoval" <NoThankYou@xxxxxxxxxxxxxx> wrote in message news:426dab20$1@xxxxxxxxxxxxxxxxxxxxxxxxx

Thank you Betsy,

It still does not work. It only works if it is set Connected := true at design time; otherwise, I cannot connect at Run-time.

Any other ideas?

Mike 



Andy,

Here is my ConnectionString:

Provider=MSDASQL.1;Persist Security Info=False;User ID=administrator;Extended Properties="DSN=MS Access Database;DBQ=C:\Data\ABC Database\db1.mdb;DefaultDir=C:\Data\ABC Database;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"



I have also tried...

strfile := 'C:\Data\ABC Database\db1.mdb';
with ADOConnection1 do begin
Close;
ConnectionObject := nil;
end;
ADOConnectionString := '';
ADOConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;';
ADOConnectionString := ADOConnectionString + 'Data Source=' + strfile + ';';
ADOConnectionString := ADOConnectionString + 'Persist Security Info=True' +';';
ADOConnection1.ConnectionString := ADOConnectionString;

Thanks...
.