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

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
 
B

Brad

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

~Brad
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,901
Latest member
Noble71S45

Latest Threads

Top