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





All Articles