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

[Brad]

Dear friends,



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



I did some research on the NEt but I am still unable to figure out why I
cannot connect to my db.



My code:



I set up a Virtual Directory in IIS and then working with Microsoft
FrontPage, opened my Web Folder...........



File.asp

my connection strng

<%

Dim CONN_STRING

Set CONN_STRING = Server.CreateObject("ADODB.Connection")

CONN_STRING.open = "Driver={SQL
SERVER};Server=Server;UID=User;PWD=XXX;DATABASE=My DB"

%>



Inside my Brad.htm page

Sub CatTopicsList()

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

objComm.ActiveConnection = CONN_STRING

objComm.CommandText = "stored procedure name"

objComm.CommandType = adCmdStoredProc

objComm.Parameters.Append objComm.CreateParameter("@prod", adInteger,
adParamInput, 4, int prod ID)

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

Set RS = objComm.Execute



Then inside my Brad.ASP page I have the following::



<!-- #include virtual="MyVirtualFolderName/file.asp" -->

<!-- #include virtual="MyVirtualFolderName/Brad.htm" -->

Anyhow I continue to get errors and the page cannot be displayed...yet the
same connection works fine at work, I am missing something and am looking
for some help please,

Any ideas would be greatly appreciated,



Thanks in advance,

~Brad

----------------------------------------------
Brad Isaacs
Web/Application Developer & Client Support
[url]www.webdevcreations.com[/url]

[Brad]

Dear friends,

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
I did some research on the NEt but I am still unable to figure out why I
cannot connect to my db.

My code:
I set up a Virtual Directory in IIS and then working with Microsoft
FrontPage, opened my Web Folder...........



File.asp
my connection strng

<%

Dim CONN_STRING

Set CONN_STRING = Server.CreateObject("ADODB.Connection")

CONN_STRING.open = "Driver={SQL
SERVER};Server=Server;UID=User;PWD=XXX;DATABASE=My DB"

%>



Inside my Brad.htm page

Sub CatTopicsList()

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

objComm.ActiveConnection = CONN_STRING

objComm.CommandText = "stored procedure name"

objComm.CommandType = adCmdStoredProc

objComm.Parameters.Append objComm.CreateParameter("@prod", adInteger,
adParamInput, 4, int prod ID)

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

Set RS = objComm.Execute



Then inside my Brad.ASP page I have the following::



<!-- #include virtual="MyVirtualFolderName/file.asp" -->

<!-- #include virtual="MyVirtualFolderName/Brad.htm" -->

Anyhow I continue to get errors and the page cannot be displayed...yet the
same connection works fine at work, I am missing something and am looking
for some help please,

Any ideas would be greatly appreciated,



Thanks in advance,

~Brad

----------------------------------------------
Brad Isaacs
Web/Application Developer & Client Support
[url]www.webdevcreations.com[/url]

[Aaron [SQL Server MVP]]

> 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=My DB"

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)?

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)

[Brad]

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=My DB"

>
> 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)?
>
> --
> [url]http://www.aspfaq.com/[/url]
> (Reverse address to reply.)
>
>

[Aaron [SQL Server MVP]]

> objComm.CommandType = adCmdStoredProc <<< The error points ot this

> line??????

Well, did you include adovbs.inc?
See [url]http://www.aspfaq.com/2112[/url]

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)

[Brad]

Hi Aaron,

I had not included this file, and after reading the link you sent me. That
was my problem.

Thanks again for ALL your help,

It is finally working now...................

~Brad
;))
ps: "You learn a new thing, everyday!"

"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:uKGrEuKeEHA.1356@TK2MSFTNGP09.phx.gbl...

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

>
> Well, did you include adovbs.inc?
> See [url]http://www.aspfaq.com/2112[/url]
>
> --
> [url]http://www.aspfaq.com/[/url]
> (Reverse address to reply.)
>
>