ODBC Drivers error ' 80040e14'

Results 1 to 2 of 2

Thread: ODBC Drivers error ' 80040e14'

  1. #1
    Join Date
    Dec 1969

    Default ODBC Drivers error ' 80040e14'

    I don&#039t get it, this code works on another server, but when I transfered the code from production to live intranet. I get this error. Any suggestions? Thanks in advance!!!<BR>Kelly:)<BR><BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e14&#039 <BR><BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword &#039ORDER&#039. <BR><BR>/contact/delete.asp, line 106<BR><BR>set acn = server.CreateObject("ADODB.Connection")<BR>acn.Ope n application("dbconn")<BR>set rcd = server.CreateObject("ADODB.Recordset")<BR>sqlstr = "Select * from SkyWeb_Contacts where DepartmentID=" & varDeptID & " ORDER BY Name"<BR>set rcd.ActiveConnection = acn<BR>rcd.Open sqls<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: ODBC Drivers error ' 80040e14'

    You have <BR>rcd.Open sqls<BR>try<BR>rcd.Open sqlstr

Posting Permissions

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