CODEWITHSUNDEEP
coldfusioncoldfusion-9sqlanywhere
Fransis
Fransis

Reputation: 285

Not able to connect Coldfusion 9 to Sybase

I am trying to add a datasource in the ColdFusion 9 administrator by connecting it to a Sybase database. I even supplied the port number as 2638 (Sybase). But I keep getting errors like:

unable to connect and connection limits reached

What should I do to allow CF to communicate with Sybase ODBC? Should I install JDBC? Any precautions or specific steps to follow? The Adobe documentation seems to be incomplete.

Environment:

Upvotes: 1

Views: 288

Answers (2)

vas
vas

Reputation: 2096

I think you need to install "jConnect". Kindly look at the following links:

Upvotes: 1

Graeme Perrow
Graeme Perrow

Reputation: 57248

"Connection limit reached" implies that you are using the personal server (dbeng12.exe), which has a limit of 10 simultaneous connections and does not allow connections over a network. You likely need to use the network server (dbsrv12.exe) which has no connection limit (other than licensing) and does allow network connections.

Disclaimer: I work for Sybase in SQL Anywhere engineering.

Upvotes: 1

Related Questions