Hi,
I've just created a new VB-based Windows Forms project in Visual Studio
2005. One of the first things I did was to create a default data connection
by placing it in the Project's app.config (via Project > Properties >
Settings Tab) and made sure that the connection was set to 'Application'
level scope. I am certain that the credentials specified work since I use
the identical credentials in another project (same user and database
connection).
Now here is the issue. When I create a new Dataset and embed a TableAdapter
into the dataset the Table Adapter Configuration Wizard will appear. The
first thing you have to do is select the data connection for the new
adapter. Unfortunately the combobox for the data connection selection is
blank - no sign of the connection that is located in the App.Config file.
I have created additional connection strings, I have recompiled the project
and solution many times. I have tested that the connection string is
referencable in a class by typing out My.Settings.MyConnString and it is
valid. I have also tested the connection string by creating a manual data
connection and have opened the connection successfully is form's class code.
But why can't this string be seen by the table adapter wizard?
Thanks in advance
|