Coldfusion 9, Sybase 11.02 on Redhat Linux 5.3

Forum|Forum|15 years ago
August 17, 2010
1 reply
1061 views

I've got Coldfusion 9 installed and working as well as Sybase. But I cannot get Coldfusion to see Sybase, I assume it needs to see the interfaces file, but I'm not sure how to do that.

Any help would be much appreciated! Joel

This topic has been closed for replies.

J

JR__Bob__Dobbs

Inspiring

What edition of ColdFusion are you using (Standard or Enterprise)?

It looks like the lowest Sybase version supported by the database drivers bundled with ColdFusion is Sybase 11.5

http://www.adobe.com/products/coldfusion/systemreqs/

If you have a JDBC driver for your version of Sybase you can try configuring your own datasource.

http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf3639b1-7fe6.html

http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fe9.html

J

jfs123Author

Participant

[ColdFusion] Coldfusion 9, Sybase 11.02 on Redhat Linux 5.3

Thanks for the reply!

I did get the latest version of Sybase ASE Express Edition, version 15.5. But...I have the Standard edition of Coldfusion 9. I still can't get CF to see Sybase. Looking at the database platform support, it doesn't include Sybase. I've been running Coldfusion since version 5 at least, with Sybase 11 on a Windows OS, so I didn't expect there to be any problem, but I do use an ODBC connection.

Any ideas would be appreciated. Would unixODBC be a route to try, or would I be better off trying to get the JDBC driver you suggested below?

Thanks again, Joel

J

JR__Bob__Dobbs

Inspiring

Things to try/options:

1. Verify that the CF server and Sybase server are able to "talk", check that the TCP/IP ports used by Sybase are not blocked by a firewall and that the account that CF user to login has sufficient rights.

2. Try an alternate JDBC driver. If you're using a version of Sybase released after CF9 you may need a newer driver.

3. You could try ODBC but this should be the last option. CF requires and additional server to use ODBC and ODBC is generally considered to be less performant than JDBC.

Questions:

1. What does " I still can't get CF to see Sybase" mean?

2. Are you getting any error messages logged by CF, the operating system, or database server?

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded