|
|
|
|
|
| | |
| |
PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
ASP call to Access Stored Proc |
|
From: |
J. Robinson |
|
Date: |
2/22/1999 5:19:27 PM |
|
IP: |
205.147.245.41 |
How can you call a Stored Procedure (Access Module) from ASP? I have followed instructions found in the ASP roadmap but am getting this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access 97 Driver]Syntax error or access violation (call)
I am trying to execute the following code (which outputs the results of a select query to a file in .xls format):
DoCmd.OutputTo (acOutputTable, "crstages", acFormatXLS, "crstages.xls")
Here's my ASP code:
<%
set cnn = server.createobject("ADODB.Connection")
cnn.open "dsn=dsnsiebk"
set cmd = server.createobject("adodb.command")
cmd.activeconnection = cnn
cmd.commandtype = 4
'cmdtext = "sub crsumtoexcel() "
cmdtext = cmdtext & " DoCmd.OutputTo (acOutputTable, 'crstages', acFormatXLS, "
cmdtext = cmdtext & Server.MapPath ("/siebel/files") & " '\new.xls') "
'cmdtext = cmdtext & " end sub "
'cmdtext = cmdtext & " call crsumtoexcel()"
cmd.commandtext = cmdtext
cmd.prepared = true
cmd.execute
%>
Thanks to anyone that can help |
Follow Up - Re: ASP call to Access Stored Proc - Ray 3/2/1999 9:15:50 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
