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
coldfusion sybase jtds coldfusion-11


source to share


No one has answered this question yet

See similar questions:

3
JDBC Connection for Sybase with Authentication Request

or similar:

3
Encryption and Integrity of Database Connections Using ColdFusion and Oracle Thin Client
1
ColdFusion Report Builder - How can you install different data sources externally between prod / staging / dev?
1
find login / password for Sybase DB / Coldfusion code
0
ColdFusion Sybase data source configuration error
0
Sybase SQL Anywhere 16 SAConnection.Close () Exception
0
ColdFusion URL Encryption Error
0
Splitting column values ​​with Sybase and ColdFusion
0
Does ColdFusion function return "The system tried to use an undefined value" error?
0
Sybase Sql Anywhere Backup
0
I am getting persistent but intermittent "PRIMARY KEY constraint violation" Errors



All Articles
Loading...
X
Show
Funny
Dev
Pics