Re: Error Type: ADODB.Command (0x800A0BB9)???

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Brad (info_at_webdevcreations.com)
Date: 08/02/04 

Date: Mon, 2 Aug 2004 11:40:51 -0400

Hey Aaron,

Please accept my apology for the multi post ~was not my intention to SPAM
the boards....

The humnid air has my mind frazzled, the connection string was messed up....

I chenged my connection to your advice though I am still having the error

ERROR Message is:

Error Type:
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.

My file.asp holds this now:
<%
set conn = CreateObject("ADODB.Connection")
conn_string = "Provider=SQLOLEDB;Data Source=Server;" & _
    "Initial Catalog=MyDB;User ID=User;Password=XXX;"
conn.open conn_string
%>

Then inside my Brad.HTM file I have:

Sub CatTopicsList()

Set objComm = Server.CreateObject("ADODB.command")

objComm.ActiveConnection = CONN_STRING

objComm.CommandText = "stored Proc namet"

objComm.CommandType = adCmdStoredProc <<< The error points ot this
line??????

objComm.Parameters.Append objComm.CreateParameter("@TOPICID", adInteger,
adParamInput, 4, intTopicID)

objComm.Parameters.Append objComm.CreateParameter("@LANG", adInteger,
adParamInput, 4, Lang)

Set RS = objComm.Execute

If NOT RS.EOF Then arrIMCatTopicsList = RS.GetRows()

RS.Close

Set objComm = Nothing

Set RS = Nothing

End Sub

Yet I am still encountering that ERROR message.................. the reason
for the htm is simple.it is locally, no worries...it is for testing
purposes,

Anyhow, I cannot understand why it gives me this error..........

Any ideas?

Thanks in advance,

~Brad

"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:OovcHIKeEHA.3016@tk2msftngp13.phx.gbl...
> > I am working on a App. at my work place, now wanting to set it up at
home
> > but for some reason I keep getting this error : ADODB.Command
>
> What is the TEXT of the error message?
>
> > I set up a Virtual Directory in IIS and then working with Microsoft
> > FrontPage
>
> <shudder>
>
> > CONN_STRING.open = "Driver={SQL
>
> You're mixing things up here. Are you trying to set a string variable, or
> are you trying to open a connection object? Should be:
>
> set conn = CreateObject("ADODB.Connection")
> conn_string = "Driver = ..."
> conn.open conn_string
>
> Or just
>
> set conn = CreateObject("ADODB.Connection")
> conn.open "Driver = ..."
>
> > CONN_STRING.open = "Driver={SQL
> > SERVER};Server=Server;UID=User;PWD=XXX;DATABASE=MyDB"
>
> I strongly recommend the OLEDB provider.
>
> CONN_STRING = "Provider=SQLOLEDB;Data Source=Server;" & _
> "Initial Catalog=MyDB;User ID=User;Password=XXX;"
>
> > Inside my Brad.htm page
>
> Why are you doing ASP work inside an .HTM page? Do you know that if you
> type the URL to /brad.htm directly you will see a bunch of your ASP code
> (e.g. the stored procedure name)?
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>

Relevant Pages

  • Re: module
    ... You have to report the correct error message to the group. ... Copy that into google, including quotes. ... 'build our connection string to use when we open the connection ...
    (microsoft.public.vb.general.discussion)
  • Re: Connection to Access Database Problem
    ... Here are the settings shown in the Connection Editor: ... Pressing the Test button gives the error message. ... I can't see a Connection string as I'd expect - there is a Connection ...
    (borland.public.delphi.database.ado)
  • ODBC Data source name not found and no default driver specified
    ... I have the DSN configured properly and a test connection from the ODBC Data Source admin works just fine. ... However, when I drop an odbcConnection object onto my form and try to configure, I always get errors before I can even enter a connection string. ... Once again, same error message. ...
    (microsoft.public.data.odbc)
  • ODBC Data source name not found and no default driver specified
    ... I have the DSN configured properly and a test connection from the ODBC Data Source admin works just fine. ... However, when I drop an odbcConnection object onto my form and try to configure, I always get errors before I can even enter a connection string. ... Once again, same error message. ...
    (microsoft.public.vsnet.general)
  • Re: [SOLVED] Cannot display provider-specific login prompt
    ... scenario where the program wouldn't have to know about the database, ... ConnectionStringBuilder up to a PropertyGrid for the end user to populate), ... details of the connection, for the sake of the program being able to connect ... information about the connection string that I will need. ...
    (microsoft.public.dotnet.framework.adonet)