Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

SQL Anywhere 12 JDBC 4.0 and Coldfusion 9.0.1

2 posts in General Discussion Last posting was on 2011-11-03 14:09:51.0Z
Billy Posted on 2011-11-01 21:13:02.0Z
From: Billy <billy>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.5) Gecko/20091204 Thunderbird/3.0
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: SQL Anywhere 12 JDBC 4.0 and Coldfusion 9.0.1
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4eb060de$1@forums-1-dub>
Date: 1 Nov 2011 13:13:02 -0800
X-Trace: forums-1-dub 1320181982 10.22.241.152 (1 Nov 2011 13:13:02 -0800)
X-Original-Trace: 1 Nov 2011 13:13:02 -0800, vip152.sybase.com
Lines: 27
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8160
Article PK: 7175

I'm trying to create a new JDBC data source in Coldfusion 9.0.1 and am
unable to connect to database. When I do the connection test, it
crashes or hangs my coldfusion service. This however works with SQL
Anywhere 10. Here is the connection string I was using with no issues
(SA 10):

jdbc:odbc:driver=SQL Anywhere
10;CommLinks=tcpip(dobroadcast=NONE;HOST=192.168.1.210;serverport=2639);eng=sqlany1;dbn=mydatabase

Driver Class: ianywhere.ml.jdbcodbc.IDriver



Here is what I'm using for my SA 12.0.1.x with no success (locks up
Coldfusion).

jdbc:sqlanywhere:ServerName=sqlany1;DatabaseName=mydatabase;Host=192.168.1.210:2639

Driver Class: sybase.jdbc4.sqlanywhere.IDriver

i've copied the sajdbc4.jar to the \lib directory and copied the
dbjdbc12.dll and dbjodbc12.dll in the windows\system32 directory.

What am I doing wrong here????

Thanks,
Billy


Billy Posted on 2011-11-03 14:09:51.0Z
From: Billy <billy>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.16) Gecko/20101125 Thunderbird/3.0.11
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: SQL Anywhere 12 JDBC 4.0 and Coldfusion 9.0.1
References: <4eb060de$1@forums-1-dub>
In-Reply-To: <4eb060de$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4eb2a0af$1@forums-1-dub>
Date: 3 Nov 2011 06:09:51 -0800
X-Trace: forums-1-dub 1320329391 10.22.241.152 (3 Nov 2011 06:09:51 -0800)
X-Original-Trace: 3 Nov 2011 06:09:51 -0800, vip152.sybase.com
Lines: 36
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8161
Article PK: 7173

Umm, can someone tell me the correct JDBC connection string parameters
to use???? There really isn't much documentation on this. The .pdf
documents aren't much help. Also, if there are other dependency .dll's
besides dbjdbc12.dll and dbjodbc12.dll please let me know....

On 11/1/2011 4:13 PM, Billy wrote:
> I'm trying to create a new JDBC data source in Coldfusion 9.0.1 and am
> unable to connect to database. When I do the connection test, it crashes
> or hangs my coldfusion service. This however works with SQL Anywhere 10.
> Here is the connection string I was using with no issues (SA 10):
>
> jdbc:odbc:driver=SQL Anywhere
> 10;CommLinks=tcpip(dobroadcast=NONE;HOST=192.168.1.210;serverport=2639);eng=sqlany1;dbn=mydatabase
>
>
> Driver Class: ianywhere.ml.jdbcodbc.IDriver
>
>
>
> Here is what I'm using for my SA 12.0.1.x with no success (locks up
> Coldfusion).
>
> jdbc:sqlanywhere:ServerName=sqlany1;DatabaseName=mydatabase;Host=192.168.1.210:2639
>
>
> Driver Class: sybase.jdbc4.sqlanywhere.IDriver
>
> i've copied the sajdbc4.jar to the \lib directory and copied the
> dbjdbc12.dll and dbjodbc12.dll in the windows\system32 directory.
>
> What am I doing wrong here????
>
> Thanks,
> Billy