Microsoft OLE DB Provider for SQL Server error '80040e14'

Discussion in 'C#' started by omerlevy, Oct 16, 2012.

  1. #1
    i have this function and i get an error :


    the error:
    _________________________________________________



    Microsoft OLE DB Provider for SQL Server error '80040e14'


    Incorrect syntax near the keyword 'DEFAULT'.


    /ziv/lib/dblib.asp, line 154 'see bold line
    ______________________________________________

    the code:


    '---------------------------- GetRS------------------------------------------------
    ' Description: Executes an SQL statement using the main connection object and returns a recordset.
    ' parameters:
    ' objSource: SQL statement to be executed or command object
    ' icursorType: cursor type to be used.
    ' Example: set objRS = GetRS("SELEcT * FROM .... ", adOpenForwardOnly)
    '---------------------------------------------------------------------------------
    Function GetRS(objSource, icursorType)
    Dim objconn
    Dim objRS


    set objRS = Server.createObject("ADODB.Recordset")


    set objconn = GetDBconn
    i have this function and i get an error :


    error:


    if IsObject(objSource) then




    **objRS.Open objSource, , icursorType**
    else


    objRS.Open objSource, objconn, icursorType
    end if


    set GetRS = objRS


    'set objconn = nothing
    End Function


    ***************************************************************************


    the sql statment can vary. for examle: "SELEcT * FROM pages_tbl WHERE page_id =15165"


    any suggestions ?
     
    omerlevy, Oct 16, 2012 IP