CodeVerge.Net Beta


   Explore    Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums

ASP.NET Web Hosting – 3 Months Free!



Zone: > NEWSGROUP > Asp.Net Forum > visual_studio.visual_studio_2005 Tags:
Item Type: NewsGroup Date Entered: 11/15/2006 3:50:21 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 4 Views: 14 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
5 Items, 1 Pages 1 |< << Go >> >|
TheFIsh
Asp.Net User
Unable to Create new tables or editi exsiting ones11/15/2006 3:50:21 PM

0/0

Hello all,

I have recently moved to VS 2005 and was enjoying the experience until I tried to create a new table or edit an existing table. 

I have setup Database projects for several of my databases within VS2005 and i am using the correct username and passwords.

I am getting the "The Parameter is incorrect" whenever i try to create a new table or when i right click a table and select (open table definition).  This is proving very frustrating.

I am able to add new and edit existing stored procedures.  I am running Windows XP Pro SP2, bang up to date and SQL server 2000.  I have tried the following:

 
Reinstalling VS then SQL 2000

Reinstalling SQL 2000 then VS

 
All to no avail, can anyone help?

 

Many Thanks,


The Fish 


Regards,

TheFIsh
Brian27
Asp.Net User
Re: Unable to Create new tables or editi exsiting ones11/16/2006 8:18:55 AM

0/0

Hi,

  Are you able to create/open databases using a SQLServer Management tool (graphical or command line).  Sounds like you have VS 2005 Pro or better (as you are able to create database projects), so I guess you have SQL Server management suite avaialble.  Do your databases show up in the Server Explorer?

  One nice thing about ASP.NET 2,0 and VS, is the ease of creating data connections.  Can you create data connections to any of the DBs on the server you are using?  Is that server on the local machine or remote via your network?

You'll also want to make sure that you've registered aspnet to SQL server - if you want to use the aspnet functionality like membership, etc....  Look for something like C:Windows\Microsoft.net\Framework\(the version you have installed) then find aspnet_regsql.exe  if you haven't registered with IIS yet, you can find that .exe in the same place.

Hope some of this help, BRN..
 

TheFIsh
Asp.Net User
Re: Unable to Create new tables or editi exsiting ones11/16/2006 9:43:45 AM

0/0

Hi Brian,

THanks for your input.  Yes i can create/open databases using my entreprise manager and yesy I am able to create dtabase projects and view them, write SP's etc. 

My database's do not show up in my server explorere within VS 2005 but i can create the data connecctions to any of my DB's (these database are in multiple locations, remote local, network etc.)

 

Strange still can get it sorted.

 
Stephen
 


Regards,

TheFIsh
Brian27
Asp.Net User
Re: Unable to Create new tables or editi exsiting ones11/16/2006 9:38:35 PM

0/0

Hi,

  I know if you use a VS website creation project (can't create VS DB projects with the version I have - Standard), you can create a dataconnection and view the connection string.  I figure if you can look at a connection string, it could give you a clue as to where the problem lies.  If you can't create a dataconnection, then my guess it's a authentication/authorization/permissions problem.  When you access the DBs with SQL Server MS, you are likely signed on as the same person that installed the manager - and have full access.  Are you suing the same identity and sign on when you are using VS?  Also, you have options for authentication with SQL Server: windows or sql server native (and I think 'mixed' mode).  If you are using windows authentication, it will use your windows login info for access to the server; if you are using sql server native authentication, you'll see a place to enter a user name and PW. 

If you look at the server browser, which widows servers does it show, just the local, or network as well?  If you can get to the box that has the SQL Server instance, you're at least part of the way there.  If you can't get that, I'd guess authentication problems.  If you get to the instance but can't connect, then it's more likely an authorization issue.

Go back to the management studio and take a look at the properties for the server instance and the databases you are trying to access via VS.  Take a look at the properties/security item for the instance, and the properties/permissions item for the DBs.  You might see something there that will show you where the problem lies.

I do know you'll need to use ASPNET_REGSQL.EXE to access the aspnetdb, even if you created that already using the management suite.  I guess you might also need to ASPNET_REGIIS, if you are using IIS as the webserver in your VS projects (but I doubt that would not allow you to see the SQL Servers).

Anyway, some stuff to try.  Good luck.  BRN..
 

TheFIsh
Asp.Net User
Re: Unable to Create new tables or editi exsiting ones11/17/2006 9:54:09 AM

0/0

Morning...

My SQL authentication for my local instance is mixed mode, whereby i specify the sa user and a password.  Within enterprise manage i have added the SQL instance using these credentials which has allowed me to ADD EDIT DELETE and basicly do everything i need to do with the DB.  Using these same credentials i can setup the Database within VS 2005 Pro but it seems i only have read only access to the DB's, i.e not allowed to create a new Table or edit exsiting.  As i have said before the SP's seem to be unaffected.

Within VS 2005 my Data Connections can be added with any issues and the "test connetion" is successful.

Could this be realated to a previous instalation of SQL desktop engine etc.?

By Default the server browser only shows my local machine (DEVELOP 4) but none of the network servers.  Is this significant?  I can however add a new server as long as i enter different login credentials when doing so.

Could this be a bug?  I really feel i have exhausted all avenues here and i really appreciate your contribution to this topic.

 
Regards,

 

S
 


Regards,

TheFIsh
5 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Secret Oracle - Unleashing the Full Potential of the Oracle DBMS by Leveraging Undocumented Features Authors: Norbert Debes, Pages: 404, Published: 2008
SOFSEM'98: Theory and Practice of Informatics : 25th Conference on Current Trends in Theory and Practice of Informatics, Jasná, Slovakia, November 21-27, 1998 : Proceedings Authors: Branislav Rovan, Pages: 452, Published: 1998
Crystal Reports 10 the Complete Reference: the complete reference Authors: George Peck, Pages: 0, Published: 2004
Environmental quality information system EQuIS. Authors: unknown, Pages: 0, Published: -1
Encyclopedia of Library and Information Science: Volume 30 - Taiwan: Library Services and Development in the Republic of China to Toronto: University of Toronto Faculty of Library Science Authors: Allen Kent, Harold Lancour, Jay E. Daily, Pages: 502, Published: -1

Web:
Unable to Create new tables or editi exsiting ones - ASP.NET Forums Unable to Create new tables or editi exsiting ones. Last post 11-17-2006 4:54 AM by TheFIsh. 4 replies. Sort Posts: ...
Unable to Create New web Site in IIS 5.1 - SQL Server - Modify next identity range sorry its sql 2000 Tag: Unable to Create New web Site in .... Edition does not support RDA . Push for non-default Schema tables". ...
Unable to create new users - Zimbra - Forums When I go through the create a new account wizard I can fill in the fields and create the account. Then if I attempt to edit the user or ...
Mimulus XHTML Editor More extensive editing can be done using one of the source edit modes, or by using your favourite text editor. Mimulus is also unable to create documents, ...
[bug #19410] Unable to Create Logical Partition with "partnew" Command Mar 25, 2007 ... The required "menu.lst" is very easy to create (see Re: How To Write Extended Partition Tables from GRUB? - sburtchin Feb 1, 2007; ...
TheMSsForum.com >> Crm >> Unable to create a new company in CRM ... Has anyone been able to get this working with more than one dataset? Tag: Unable to create a new company in CRM 4.0 Tag: 95820 ...
WriteImage CEP Integrated System Speeds Manufacturer’s Data Access ... One of the biggest benefits of the new system is that it can grow with the ... In addition, the company was unable to create tables or fields in the ...
Smart Computing Article - Making Your Point With PowerPoint, Part II We'll discuss this more when we address editing graphs and tables.) In most cases, it's easier to just create a new slide for the graph. Tables. ...
Jan's Access Forms & Reports: Switchboard Form Use the buttons to create new items, edit the existing ones, .... Message: The Switchboard manager was unable to find a valid switchboard in this database. ...
Communication Networks/IP Tables - Wikibooks, collection of open ... Aug 22, 2007 ... It is possible for extension modules to create new tables. .... (not part of an existing connection, and unable to create a new connection). ...

Videos:
From the DVLH Wrestling vault Classic Luke Hadley wrestling music video from 1997. http://www.lukehadley.com Hardcore wrestling is a form of professional wrestling that eschews tr...
Extreme DVLH wrestling sample Classic Luke Hadley wrestling video. http://www.lukehadley.com Hardcore wrestling is a form of professional wrestling that eschews traditional concep...
DVLH volume 1 (WRESTLING) Classic Luke Hadley wrestling video. http://www.lukehadley.com Hardcore wrestling is a form of professional wrestling that eschews traditional concep...
Extreme DVLH wrestling sample 2 Classic Luke Hadley wrestling video. http://www.lukehadley.com Hardcore wrestling is a form of professional wrestling that eschews traditional concep...
Classic Luke Hadley wrestling video (DVLH) Classic Luke Hadley wrestling video. http://www.lukehadley.com Hardcore wrestling is a form of professional wrestling that eschews traditional concep...
Luke Hadley Wrestling DVD Classic Luke Hadley wrestling video. http://www.lukehadley.com Hardcore wrestling is a form of professional wrestling that eschews traditional concep...




Search This Site:










ctrl space not working after resharper uninstall

vs2005 add-in suggestion

problem with class diagram

asp.net templates/project types didn't install...

awkward situation

create: project doesn't give option for web application

metadata file not found

export template feature : which vs 2005 version ?

error in vs 2005

what's a better display setup?

tableadapter configuration wizard error

disable compilation of specific folders or files.

designer defaults? where are they?

publish problems (no files generated)

asp.net configeration error message

resize web user control in design-time

vs 2005 vwd express edition compared to pro edition for web forms.

first time, debugging results in an error in asp.net 2.0

workaround to get visual studio f5 debugging for asp.net applications on vista / iis7

help... upgrade from vista home premium to ultimate has screwed with my install of vs2005...

recent projects in start page

debug from the first line

languages in visual studio 2005

build process painfully slow

"cannot find server" in vs 2005 beta 2

opening the 'my computer' window programmaticaly

html validation can't be disabled

dumb easy question

<%@ directives keep changing their location

"parser error message: method name too long" under asp.net development server

  Privacy | Contact Us
All Times Are GMT