Connection String from Include file ASP to SQL Server 2000????

[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 (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable
range, or are in conflict with one another.


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
www.webdevcreations.com

[Aaron [SQL Server MVP]]

http://www.aspfaq.com/5003

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


"Brad" <in**@webdevcreations.com> wrote in message
news:Ut*******************@news20.bellglobal.com.. .

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 (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable
range, or are in conflict with one another.


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
www.webdevcreations.com

[Brad]

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

~Brad
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:eK**************@TK2MSFTNGP10.phx.gbl...

http://www.aspfaq.com/5003

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


"Brad" <in**@webdevcreations.com> wrote in message
news:Ut*******************@news20.bellglobal.com.. .

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 (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable
range, or are in conflict with one another.


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
www.webdevcreations.com