Please accept my apology for the multi post ~was not my intention to SPAM
the boards....
~Brad
"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:eKfaJMKeEHA.2044@TK2MSFTNGP10.phx.gbl...[color=blue]
>
http://www.aspfaq.com/5003
>
> --
>
http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>
>
> "Brad" <info@webdevcreations.com> wrote in message
> news:UtsPc.6447$Jq2.376603@news20.bellglobal.com.. .[color=green]
> >
> >
> > Dear friends,
> >
> >
> >
> > I am working on a App. at my work place, now wanting to set it up at[/color][/color]
home[color=blue][color=green]
> > 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[/color][/color]
the[color=blue][color=green]
> > same connection works fine at work, I am missing something and am[/color][/color]
looking[color=blue][color=green]
> > for some help please,
> >
> > Any ideas would be greatly appreciated,
> >
> >
> >
> > Thanks in advance,
> >
> > ~Brad
> >
> > ----------------------------------------------
> > Brad Isaacs
> > Web/Application Developer & Client Support
> >
www.webdevcreations.com
> >
> >
> >
> >[/color]
>
>[/color]
