Highlighted

ColdFusion ODBC Error

New Here ,
Aug 18, 2020

Copy link to clipboard

Copied

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>

Views

27

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

ColdFusion ODBC Error

New Here ,
Aug 18, 2020

Copy link to clipboard

Copied

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>

Views

28

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Aug 18, 2020 0

Have something to add?

Join the conversation