PC Review


Reply
Thread Tools Rate Thread

Can't see My.Settings data connection when creating TableAdapter in strongly typed dataset

 
 
CGatto
Guest
Posts: n/a
 
      29th Feb 2008
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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
changing the connection for a strongly typed dataset BillE Microsoft ADO .NET 0 1st May 2008 08:49 PM
Has anyone had any luck in creating a strongly typed dataset in visual basic 2005 express? C a r l o s A n t o n i o Microsoft VB .NET 1 11th Dec 2006 08:22 PM
Has anyone had any luck in creating a strongly typed dataset in visual basic 2005 express? C a r l o s A n t o n i o Microsoft ADO .NET 1 11th Dec 2006 08:22 PM
RE: Problem creating foreign key constraint in strongly typed dataset =?Utf-8?B?UmljaA==?= Microsoft ADO .NET 0 18th Nov 2004 03:49 PM
Help with creating strongly typed DataSet =?Utf-8?B?QW5kcmUgUmFuaWVyaQ==?= Microsoft ASP .NET 1 19th Apr 2004 01:42 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:37 AM.