SQL Anywhere for Linux - Accessing ASA from ColdFusion Linux

Author

Accessing ASA from ColdFusion Linux

Alex Lake

2005-07-11, 1:23 pm

I've got ColdFusionMX running on a Linux (RH9) box that also has ASA8 - how
do I set up the datasource?

Thanks in advance!

Alex Lake

2005-07-12, 3:23 am

OK, let's try this another way...

How do I know if I've got jConnect installed?

Greg Fenton

2005-07-12, 9:23 am

Alex Lake wrote:
> OK, let's try this another way...
>
> How do I know if I've got jConnect installed?
>

To know if jConnect is installed, look for the jConnect library
(jconn2.jar).

But why are you considering using jConnect? I'm not a ColdFusion
user/developer, but CF is not Java (is it?) Does CF support ODBC?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Andre Schild

2005-07-13, 3:23 am

Greg Fenton schrieb:
> Alex Lake wrote:
>
>
> To know if jConnect is installed, look for the jConnect library
> (jconn2.jar).
>
> But why are you considering using jConnect? I'm not a ColdFusion
> user/developer, but CF is not Java (is it?) Does CF support ODBC?
>
> greg.fenton
New versions (since 2-3 years now) of CF are in fact Java !
So using jODBC or jConnect is appropriate.

André

Alex Lake

2005-07-18, 7:23 am

Thanks Greg.

I can definitely connect to this Linux server with jisql from a windows
machine. Now I'm wondering if my Linux box has the appropriate client-side
stuff on it. I've also since upgraded to CFMX6.1

The settings are:
JDBC URL: jdbc:sybase:Tds:M700
3:2638? ServiceName=bh2_M700
3
Driver Class: com.sybase.jdbc2.jdbc.SybDriver

The error is now:
Connection verification failed for data source: bh2_M7003
[]java.sql.SQLException: No suitable driver available for bh2_m7003, please
check the driver setting in jrun-resources.xml, error:
com.sybase.jdbc2.jdbc.SybDriver
The root cause was that: java.sql.SQLException: No suitable driver available
for bh2_m7003, please check the driver setting in jrun-resources.xml, error:
com.sybase.jdbc2.jdbc.SybDriver

I've no idea where/how the driver should be installed, or if there's some
clever technique whereby some bit of Java automatically downloads a
clientside driver from somewhere. I may have to see if I can install jisql
on the Linux box to narrow the focus to CF...

"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:42d3c9e0$1@foru
ms-1-dub...
> Alex Lake wrote:
>
> To know if jConnect is installed, look for the jConnect library
> (jconn2.jar).
>
> But why are you considering using jConnect? I'm not a ColdFusion
> user/developer, but CF is not Java (is it?) Does CF support ODBC?
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/

Alex Lake

2005-07-18, 7:23 am

Just to let anyone following know - I've fixed the problem and it was simply
down to jconn2.jar not being in the classpath for the CF JVM.

Sponsored Links