Can't Open SQL Query

Results 1 to 2 of 2

Thread: Can't Open SQL Query

  1. #1
    Join Date
    Dec 1969

    Default Can't Open SQL Query

    I have downloaded a message board and I&#039;m trying to modify it to work with SQL Server. Most of it is straight forward, but I have run across the following error message:<BR><BR>Microsoft OLE DB Provider for SQL Server (0x80040E14)<BR>Line 1: Incorrect syntax near &#039;12&#039;<BR><BR>This happens when it executes the following function:<BR><BR>Function GetRecordset(sRSSource)<BR> Dim objRSGetRecordset<BR> <BR> Set objRSGetRecordset = Server.CreateObject("ADODB.RecordSet")<BR> objRSGetRecordset.Open sRSSource, cnnForumDC, adOpenStatic, adLockReadOnly // this is the line causing the problem.<BR> <BR> Set GetRecordset = objRSGetRecordset<BR> <BR> &#039;objRSGetRecordset.Close<BR> Set objRSGetRecordset = Nothing<BR>End Function<BR><BR>If anyone has any ideas, plese let me know. I&#039;m using SQL Server 2000.<BR><BR>Thanks,<BR>Jesse

  2. #2
    Join Date
    Dec 1969

    Default RE: Can't Open SQL Query

    &#062;&#062;Line 1: Incorrect syntax near &#039;12&#039;<BR>This is obvious that there is a syntax error in your source statement(sql).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts