-
SQL @ ASP
Can someone contact me in respect to using ASP with an SQL Server?
-
SQL @ ASP (reply)
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|