Coldfusion + Sybase + Authentication = SQL Anywhere Error -217
Porting a legacy ColdFusion + Sybase application from CF8 to CF11. Using the jTDS driver for SQL11 I can connect to the database BUT when I need to authenticate with the following code:
<cfquery datasource="#application.datasource#" name="AUTH">
SET TEMPORARY OPTION CONNECTION_AUTHENTICATION='Company=zzz;Application=zzz;Signature=zzz'
</cfquery>
I am getting a CF dump saying:
SQL Anywhere Error -217: The option 'CONNECTION_AUTHENTICATION' cannot be set from within a procedure
Any ideas?
Additional info: If I remove the above statement from the .cfm application and I try to log into the database as a user, if I have the wrong credentials it tells me so. If I have CORRECT credentials, I get a CF exception dump saying "TDS protocol error: Invalid packet type 0x01"
Any help would be appreciated.
+3
source to share
No one has answered this question yet
See similar questions:
or similar: