Re: "The parameter is incorrect" error, adding table in Database Explorer

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



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




.



Relevant Pages

  • Re: error -8796
    ... Entourage identity, with no emails and no contacts ALSO got Error ... I believe that Error -8976, at least in my case, represented a font ... I did a fresh install of Panther on a separate partition, ... database files now miraculously works. ...
    (microsoft.public.mac.office.entourage)
  • elpoint - anybody?
    ... I wanted to try out elpoint, ... didn't install the font successfully. ... But the error message continued. ...
    (Debian-User)
  • Re: Fonts
    ... of graphic card driver etc. as source of the problem - after all, ... fact, they even DID install, since after editing the registry, all fonts I ... you want to install this font please remove its older version first". ... I get an error message like "file ...
    (microsoft.public.word.docmanagement)
  • BI Portal Installation
    ... Cannot install database; ... I specified database server and Database name ... Then the above error message showed up. ...
    (microsoft.public.sqlserver.olap)
  • Re: Entourage 2008
    ... I've never seen that error message before. ... database and to use the MS database utility... ... How did you install Leopard? ... Entourage Help Blog ...
    (microsoft.public.mac.office.entourage)