Setting The ADO Data Control ConnectionString Property At Runtime

[jerjim]

I have at lease one ADO data control on several VB forms.
Their ConnectionString property is set to the ff. value:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\

http://wwwroot\HR\Db\H3.mdb;Persist

Security Info=False

Please note that the database H3.mdb is on drive C.

For various reasons when I install my program on another computer,
the database has to be located on drive D instead of Drive C

Thus in the above connection string I have to replace C: with D:
and set at runtime the ConnectionString property of all my ADO Data Controls on all forms

With adoDataControl
.ConnectionString = sNewConnectionString
.Refresh
end with

The variable sNewConnectionString has the value:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Inetpub\

http://wwwroot\HR\Db\H3.mdb;Persist

Security Info=False

All that has changed is the drive letter.

The problem now is when the Refresh method is called,
VB flashes an error saying it could not find the file on Drive C:
But when I checked the value of the ConnectionString property,
it already has the value of the variable sNewConnectionString.

Is there anything else I should do?

 

[HermanvLimbeek]

Maybe you got your old connectionstring pointing to the C-drive in the design-time property Connectionstring?

Herman :-Q

 

[jerjim]

That's precisely why I am setting the connection string property at run time. At design time, this property was pointing to a folder in drive C. At run time I want to set it to point to a folder in drive D.

 

[HermanvLimbeek]

You misunderstood me. What I meant is maybe the connectionstring is still in the designtime property pointing to C:. But I tested it, that doesn't cause the problem.
Did you insert an errorhandler in the code, so that you're sure this string is causing the problem? Did you debug the connectionstring at runtime? Is this the only datacontrol or can it be another which has the wrong value?

Questions, questions, questions

Herman :-Q