473,320 Members | 1,857 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Add new datasource doesn't work in Whidbey...

I actually honestly believe that this problem might stem from my SQL
2005 Express installation, but since it occurs in Whidbey I figured I'd
post here.

My problem is that I can't create a new datasource in whidbey using the
add new option in the data menu. I get a messagebox with an error such
as the following:

"An unexpected error has occurred.
Please record the following message when seeking support from
Microsoft:

Source:Microsoft.VSDesigner
ErrorCode:-1
Additional Info:None

[OK]"

This error message obviously doesn't help much, and neither has various
search queries with googles been very helpful. Has anyone experienced
this? I've heard suggestions from re-installing VS to re-installing
windows. I've tried the former without any luck. Worth noting is that
the same error is produced either when dragging a table from the server
explorer to the dataset designer window. But get this, it works for ONE
table by dragging from the server explorer, but not any subsequent
tables. Also, adding a TableAdapter produces the same error. This
sounds to me like something might be wrong with the data connection.
However, the event viewer hasn't logged anything which might suggest
something is wrong with my SQL 2005 Express installation, although it
did fail the first time when installing with the VS 2005 installer, so
I downloaded the SQL 2005 Express installation from MSDN. Another thing
worth noting is that I get this dialog before the error (and also
before the first table in the dataset gets added):

"Updating queries can not be automatically generated because your
SELECT query does not include some primary key columns. Do you wish to
add primary key columns to your query?

[Yes] [No]"

Obviously, clicking no aborts the operation. Also, if it's helpful, I'm
connecting to a SQL database file (mdf).

And lastly, I've uploaded a diagram of how my tables looks:
http://hem.bredband.net/b251589/misc/db.png

I'm sorry about the small font. The relationship is as follows:
The Awards and Functions tables have a column called Section which has
a relationship with the Id column in the Sections table. The rest have
a column called Member which has a relationship with the Id column in
the Members table.

Has anyone else experienced this?

Nov 22 '05 #1
1 1304
Marcus,

There are special newsgroup for Whidbey beta testing.

http://communities.microsoft.com/new...idbey&slcid=us

I think that you help the most creating from 2003 beta a good product with
posting the problems to those newsgroups.

Cor
Nov 22 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: marcus | last post by:
I actually honestly believe that this problem might stem from my SQL 2005 Express installation, but since it occurs in Whidbey I figured I'd post here. My problem is that I can't create a new...
13
by: DraguVaso | last post by:
Hi, I need a function that gives me the number of Columns shown in a DataGrid. So I don't need to know the number of columns shown in tha DataSource, because this number can be completely...
13
by: Sherif ElMetainy | last post by:
Hello I was just got VS 2005 preview, and was trying generics. I tried the following code int intArray = new int; IList<int> intList = (IList<int>) intArray; it didn't compile, also the...
0
by: Billy Porter | last post by:
Greetings, Which datasource object (ObjectDataSource, SqlDataSource or DataSetDataSource) can I use when I already have a DataTable that I want to bind to my GridView? I would like to use one of...
4
by: Stephen | last post by:
IN VB.NET I have a form with a ListBox and would like to set the DataSource property at design-time but I can't seem to declare any kind of variable that will show up in the list. I have tried a...
2
by: John Richardson | last post by:
This is probably a yes/no answer... I have a datasource for a combobox, and my datasource is an IList. This list may be composed of two class types, but all implement an INavItem interface...
7
by: bernadou | last post by:
How do I (or is this even possible) get the total number of records from a datasource control in ASP.NET 2.0? I’ve messed around with getting the row count from the grid that the datasource is...
4
by: SHEBERT | last post by:
Here is an example of a SortedList that works as a datasource to the ComboBox and a generic SortedList<that does not works as a datasource to the ComboBox. Why? If I use List and generic List<>,...
2
by: shapper | last post by:
Hello, I created a Repeater at runtime with an AccessDataSource.Everything Works fine! Now I need to use the same repeater but with a DataSource created in my VB.Net code. I created a...
5
by: Mark Olbert | last post by:
How do I get the DataPager and ListView to play nice together when I use a custom datasource? In my webpage, I use linq to pull data from a SqlServer database and assign the resulting...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.