>Mike,
>
>Thanks for your quick feedback.
>
>1. No sooner did I click send to my posting than it dawned on me that I can set the connection string for the adapters directly:
>
>this.patientsTableAdapter.Connection.ConnectionString =
>
>I'm experimenting with this now. I am getting an error saying the ConnectionString has not been initialzied.
>
>2. I thought initially about changing the value of ConnectionStringWoundDB in the application config file, but it isn't clear to me when and how that file is used. As far as I can tell from the designer created code, Properties.Settings.Default.ConnectionStringWoundDB is hard-coded into the application.
>
>Here is the designer generated code in Settings.Designer.cs:
>
>> [global::System.Configuration.DefaultSettingValueAttribute("Provider=VFPOLEDB.1;Data Source=\"D:\\Program Development\\wounddb\\DATA\\wounddb.dbc\"" +
> ";Collating Sequence=MACHINE")]
> public string ConnectionStringWoundDB {
> get {
> return ((string)(this["ConnectionStringWoundDB"]));
> }
> }
>
>
>What do you think?
>
>Thanks,
>Jim
When I've seen that message it was caused by not having a value in the connection string property.
Michael McLain