Highlighted

CF10 Data Source: is value in Driver Class required?

New Here ,
Sep 01, 2014

Copy link to clipboard

Copied

I'm trying to upgrade my SQL Anywhere database server from 10 to 16

I want to use the newer JDBC connection

( My database runs on a different machine/server than the CF server )

On my test system

Server Product    ColdFusion

Version    ColdFusion 10,282462

Edition    Developer 

Operating System    Windows 2003   Standard Service Pack 2

OS Version    5.2 

Update Level    /C:/ColdFusion10/cfusion/lib/updates/chf10000002.jar 

Adobe Driver Version    4.1 (Build 0001) 

Data sources using the old jdbc-odbc bridge driver work

CF data source name: -> demo

JDBC URL ->jdbc:ianywhere:driver=SQL Anywhere 10;dbn=demo;links=tcpip

(HOST=xx.0.0.xx;PORT=2620);eng=demo16

Driver Class -> ianywhere.ml.jdbcodbc.jdbc3.IDriver

Driver Name -> SQL Anywhere 10

User Name ->  dba

Password -> sql

(with, as you might expect, numeric values in place of xx)

In order for these to work I needed

dbjodbc10.dll and jodbc.jar in C:\ColdFusion10\cfusion\lib  ( Actually to be honest, I apparently installed a copy of Sybase Anywhere 10 on my web server out of desperation the last time I tried an upgrade so these are in that folder as well and I set CF classpath on the JVM  page -> "C:\Program Files\SQL Anywhere 10\java")

the new driver components are sajdbc4.jar and dbjdbc16.dll  so I put them in the same place

and SAP/Sybase/SQL Anywhere says that it does NOT use a driver name value

JDBC URL ->jdbc:ianywhere:dbn=demo;links=tcpip

(HOST=xx.0.0.xx;PORT=2620);eng=demo16

Driver Class ->

Driver Name -> SQL Anywhere 16

User Name ->  dba

Password -> sql

Connection verification failed for data source: demo

java.sql.SQLException: No suitable driver available for demo, please

check the driver setting in resources file,

I'm wondering if CF10 (and for that matter CF8 which my production machine is running) require Driver Class to be filled in.

Any clues?  and  What resources file ?

Views

419

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

CF10 Data Source: is value in Driver Class required?

New Here ,
Sep 01, 2014

Copy link to clipboard

Copied

I'm trying to upgrade my SQL Anywhere database server from 10 to 16

I want to use the newer JDBC connection

( My database runs on a different machine/server than the CF server )

On my test system

Server Product    ColdFusion

Version    ColdFusion 10,282462

Edition    Developer 

Operating System    Windows 2003   Standard Service Pack 2

OS Version    5.2 

Update Level    /C:/ColdFusion10/cfusion/lib/updates/chf10000002.jar 

Adobe Driver Version    4.1 (Build 0001) 

Data sources using the old jdbc-odbc bridge driver work

CF data source name: -> demo

JDBC URL ->jdbc:ianywhere:driver=SQL Anywhere 10;dbn=demo;links=tcpip

(HOST=xx.0.0.xx;PORT=2620);eng=demo16

Driver Class -> ianywhere.ml.jdbcodbc.jdbc3.IDriver

Driver Name -> SQL Anywhere 10

User Name ->  dba

Password -> sql

(with, as you might expect, numeric values in place of xx)

In order for these to work I needed

dbjodbc10.dll and jodbc.jar in C:\ColdFusion10\cfusion\lib  ( Actually to be honest, I apparently installed a copy of Sybase Anywhere 10 on my web server out of desperation the last time I tried an upgrade so these are in that folder as well and I set CF classpath on the JVM  page -> "C:\Program Files\SQL Anywhere 10\java")

the new driver components are sajdbc4.jar and dbjdbc16.dll  so I put them in the same place

and SAP/Sybase/SQL Anywhere says that it does NOT use a driver name value

JDBC URL ->jdbc:ianywhere:dbn=demo;links=tcpip

(HOST=xx.0.0.xx;PORT=2620);eng=demo16

Driver Class ->

Driver Name -> SQL Anywhere 16

User Name ->  dba

Password -> sql

Connection verification failed for data source: demo

java.sql.SQLException: No suitable driver available for demo, please

check the driver setting in resources file,

I'm wondering if CF10 (and for that matter CF8 which my production machine is running) require Driver Class to be filled in.

Any clues?  and  What resources file ?

Views

420

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Sep 01, 2014 0
New Here ,
Sep 02, 2014

Copy link to clipboard

Copied

I think your JDBC URL should be jdbc:sqlanywhere and not jdbc:ianywhere.

--J

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 02, 2014 0
Pat_M1 LATEST
New Here ,
Sep 02, 2014

Copy link to clipboard

Copied

You are certainly correct.. careless of me.

I also just applied hotfix 12  so I'm now at CF10, 286680

but alas, no better result

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 02, 2014 0