Hi,
I'm having a problem with setting ADO properties at run-time compared to design
time.
Design-time (this works) I have ...
DataSource1.DataSet := DataSource1;
ADOTable1.Active := True;
ADOTable1.Connection := ADOConnection1;
ADOTable1.ConnectionString is blank
ADOConnection1.Connected := True;
ADOConnection1.connectionString := standard Microsoft.Jet.OLEDB.4.0 string
So when I run the app, it runs fine from my own PC displaying info in a DBGrid.
But, I want to change the connection string so that at run time it gets the
database path from the users PC and builds the connection string.
Does the connection string have to be set for all of these ADO components, or
just the ADOConnection? and in what sequence in the code?
It's just that if I manually set the ADO components to not active, or not
connected, and then try to set the ADOConnection string at FormCreate event, I
get the following error...
Project raised exception class EOleException with message 'could not find
installable ISAM. Process stopped. Use Step or Run to continue.
NB, I'm using Delphi 5 and an Access database , and the ADOConnection1.Provider
:= Microsoft.Jet.OLEDB.4.0
Regards,
Steve
_______________________________________________
Delphi-DB mailing list
Delphi-DB@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi-db
