1

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:

  • Vista
  • ColdFusion 9
  • Sybase 6.1.0 (SQL Anywhere 12 / QAnywhere 12)
Leigh
  • 28,765
  • 10
  • 55
  • 103
Fransis
  • 275
  • 1
  • 5
  • 15

2 Answers2

1

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

Leigh
  • 28,765
  • 10
  • 55
  • 103
vas
  • 2,078
  • 9
  • 39
  • 60
1

"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.

Graeme Perrow
  • 56,086
  • 21
  • 82
  • 121