Skip to main content
Participant
August 18, 2020
Question

ColdFusion ODBC Error

  • August 18, 2020
  • 0 replies
  • 156 views

Starting getting this error on the ODBC connection last week. 

[Macromedia][SequeLink JDBC Driver][ODBC Socket][TOD][ODBC][Unknown]OPTCHG: Option value changed

 

ColdFusion has been running on this server without issue since 2015 and I can find any changes to the server that would have caused this.

Simply query to a AcuXDBC connection


<cfsetting requestTimeOut = "360">
<CFSET SOURCE = 'CUSTOMER'>
<CFSET KEY = '12345678'>
<CFQUERY NAME="SHIPPED" DATASOURCE='#SOURCE#'>
SELECT COUNT(*) AS SCOUNT
FROM PUBLIC.CFDRN
where PO_NUMBER = '#KEY#'
</cfquery>

    This topic has been closed for replies.