SQL @ ASP

[Bill atwell]

Can someone contact me in respect to using ASP with an SQL Server?

[Andres]

You should work (i.e.)with vbscript.
Make a conection like


<% set conUsers = server.CreateObject("ADODB.Connection")
set cmd = Server.CreateObject("ADODB.Command")
conUsers.Open "ODBC;DSN=xxxxx;UID=sa;PWD=anything;driver={SQ L Server};server=XXXX;database=YYYYYY;"
Set cmd.ActiveConnection = conUsers
cmd.CommandType = 4
cmd.CommandText = "SP_xxsxxxx"
cmd.Parameters.Refresh
cmd(1) = 0
cmd(2) = 0
cmd(2).direction = 3

cmd.Execute

serv=cstr(cmd(2))
Set cmd = Nothing
conUsers.Close
Set conUsers = Nothing

%>




On 6/25/98 11:44:54 AM, Bill atwell wrote:
> Can someone contact me in respect to using ASP with an SQL Server?