1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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