Re: "The parameter is incorrect" error, adding table in Database Explorer
- From: "Wayne Ellis" <send2wayne_removethisnonspammers@xxxxxxxxxxxx>
- Date: Fri, 13 Oct 2006 11:40:19 +1000
Ok, I tracked down the problem, so I'll post the solution here for others
who may stumble on to this.
It's all to do with fonts.
See this page:
http://www.j3technology.com/blog/rss.php?categoryId=6&blogId=1
------------------------------------
The other day I downloaded the consolas font to check it out, everything
seemed to be going hunky then on the weekend I attempted to do an "Add new
table" to my dataset and got back an error message of "Invalid Parameter"
huh ? ok went and created the table within SQL2005 and everything was moving
forward.
Then went and attempted to create a typed dataset based on the new table and
got a weird display format and the error message "Mouse click operation
failed." ... bugger
After a lot of looking around and trying to work what the hell was going on
I worked out that the font for the the "DataSet Designer" and "Table and
Database Designer" was sent to Courier New ... I changed these to MS San
Serif and everything went back to normal.
Strange things is other people here installed fine and didnt have the same
problems, none the less the error messages where extremely painful
------------------------------------
"Wayne Ellis" <send2wayne_removethisnonspammers@xxxxxxxxxxxx> wrote in
message news:OJQdwA66GHA.4276@xxxxxxxxxxxxxxxxxxxxxxx
Hey there,
Whenever I attempt to "Add New Table" to a SQL Server 2005 Express
database file using VS 2005 (or Visual Web Developer 2005 Express
v8.0.50727.42), I get a pop up error message stating "The parameter is
incorrect". (That's all - no other error details.)
Any ideas what might be causing this and how to fix it? Thanks
Are there any logs or the like I can check to get more detail?
Cheers,
Wayne
----------------------------------------------------------------------------
More Information:
- The VS window where I could normally fill in the new table details
exists remains blank once shown
- After closing the error message, it pops back up if I click the mouse in
the blank window, and occasionally if I Alt-Tab away from VS and back
again.
- If I click on the help for the error message, MS Document Explorer
states that "The information you are trying to access could not be found."
The URL show is:
ms-help://MS.VSExpressCC.v80/dv_commoner/html/1702ec84-76f9-4a82-9043-9ab8acb8aa5e.htm
- I can add tables programmatically to the database, just not in the VS
from the Database/Server Explorer, or from the Data menu
- For tables created programmatically, "Open Table Definition" causes the
same "The parameter is incorrect" error
- VS allows me to "Show Table Data" for tables created programmatically,
and add new records
- It seems that only "Add New Table" fails in VS. I can successfully "Add
New View", create a "New Query", etc.
- The SQL Server Express install is on the local machine with all the
default configuration (ie., minimal surface area). I've downloaded the
latest version
- I'm creating the new databases using "Add New Item" | "SQL Database"
- The database connection string is: "Data
Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and
Settings\...\Sample.mdf";Integrated Security=True;User Instance=True" (The
"..." being my simplification.)
- I've tried repairing my installation of VS. Then I uninstalled and
reinstalled VS. Then I downloaded and installed both Web Developer Express
and SQL Server Express. I've also tried to add tables on both a populated
and new created, empty database. None of this has made any difference.
- I've searched the usual web resources (MS support, web, news groups) for
help with no success
.
- References:
- "The parameter is incorrect" error, adding table in Database Explorer
- From: Wayne Ellis
- "The parameter is incorrect" error, adding table in Database Explorer
- Prev by Date: Re: Performance
- Next by Date: RE: Setting MS build Property for one project in a solution
- Previous by thread: "The parameter is incorrect" error, adding table in Database Explorer
- Next by thread: how to compare local folder with source control?
- Index(es):
Relevant Pages
|