none
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' & [Microsoft][ODBC SQL Server Driver]Syntax error or access violatio

    Question

  • I use ASP to run a procedure, but when I open the page. I got the following:

    Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

    [Microsoft][ODBC SQL Server Driver]Syntax error or access violation

    /test.asp, line 19

     

     

    test.asp code is

    <!-- #include file="includes/adovbs.inc" -->
    <!-- #include file="includes/incServer.asp" -->
    <%
    Function fExecDTS()

    dim strUID

    strUID = fGetUser()

    'Connect to the Database
    fConnectDB

        Set cmd = Server.CreateObject("ADODB.Command")
        Set cmd.ActiveConnection = oConn
       
        cmd.CommandText = "Myproc" 
        cmd.CommandType = adCmdStoredProc
       
        cmd.Execute     --Line 19

    fCloseDB

    End Function
    %>
    <html>
    <body>

    <form name="test" method=post>
    <input type=button value=submit onclick="<% call fExecDTS %>">
    </form>
    </body>
    </html>

     

    What's the matter

    Friday, July 25, 2008 6:35 AM