B
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=MyDB"
%>
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
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=MyDB"
%>
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