EOle Exception: Parameter object is improperly defined

From: Bob Berry (callbob_at_paymentsinhand.com)
Date: 07/04/04 

Date: Sun, 4 Jul 2004 14:45:25 -0600

I have a desktop DB application using D7, Access and ADO. I get the subject
error where my SQL consists only of 'Select * from ' + dbname.

The Parameters.Count before adding this statement is 0, and after the Add it
is 1. Otherwise, I use no parameters in this query. I have looked at the
syntax of this statement including the dbname string til I am blue in the
face, to no avail.

I would be grateful if anyone has run into this error and can shed some
light for me.

Relevant Pages

  • Re: ALTER (or CREATE) TABLE/Ole Object Data Type in MS Access
    ... but I need to be able to do it using SQL syntax ... My database is an Access 2003 database, ... ADOX is an "extension" to ADO ... the Jet OLEDB Provider but only partially supported by other providers. ...
    (microsoft.public.vb.general.discussion)
  • Re: use instance not port for MSSQL
    ... > number to connect to the MSQL sever. ... I got an email from someone saying ... If it's ADO, you'll want to move away from the ODBC ... syntax above and go with the newer OLE DB syntax. ...
    (microsoft.public.vb.general.discussion)
  • Spaltenname einer Access-MDB per SQL =?ISO-8859-15?Q?=E4ndern?=
    ... dass es nur noch an der Syntax liegt. ... Ich vermute etwas wie "ALTER meinetabelle ALTER COLUMN meinalterspaltenname", ...
    (microsoft.public.de.vb.datenbank)
  • Re: VBScript & ADO
    ... If so where should I look to learn the syntax. ... >> I can use ADO in VBScript through ASP, however I want to develop a small ... >> script to run from the desktop. ... >> Cheers, Bill. ...
    (microsoft.public.scripting.vbscript)
  • Re: VBScript & ADO
    ... No, syntax is the same except that you have no ASP objects (Request, ... Scripting/HTA/.Net Framework IDE ... >> You can use ADO with a VBS file or, if you want an interface, use HTA ...
    (microsoft.public.scripting.vbscript)