Re:CONNECTION STRING PROB. HELP PSE??

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

Date: Mon, 2 Aug 2004 10:41:32 -0400

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=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

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

Relevant Pages