Re: problem connecting to ADO programmatically

William Meyer wrote:

I have taken the connection string created using the MS wizard, and
broken it into a series of constants, so I can replace the file path
dynamically. When I attempt to do this, I get the "Could not find
installable ISAM" error message. My code:

[snipped]

If I comment out the assignment to ADOConnCAPWatch.ConnectionString,
there is no error. I have tried commenting out parts of the tail
strings, finally reaching this:

[snipped]

I still get the error. Any suggestions?

Here is the connection string I use on normal (unprotected) MDB files
for just reading them.

adoConn.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0' +
';Data Source=' + objSettings.DatabaseName +
';Mode=Read' +
';Persist Security Info=False';

On the component level I have KeepConnection and LoginPrompt set to
False. I can and am changing the connectionstring on the fly based on
user settings.

--
Pieter
.