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.

Appeon 2.8 Tutorial - Cannot ping to ASA db using jdbc

5 posts in Appeon (partner product) Last posting was on 2004-09-16 10:39:24.0Z
Stephan Donati Posted on 2004-09-14 14:03:50.0Z
From: "Stephan Donati" <sdonati@rogers.com>
Newsgroups: sybase.public.appeon
Subject: Appeon 2.8 Tutorial - Cannot ping to ASA db using jdbc
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: gateway.elections.ca
Message-ID: <4146fbfc$1@forums-2-dub>
X-Original-Trace: 14 Sep 2004 07:11:08 -0700, gateway.elections.ca
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 14 Sep 2004 06:51:48 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 14 Sep 2004 07:03:50 -0700
X-Trace: forums-1-dub 1095170630 10.22.108.75 (14 Sep 2004 07:03:50 -0700)
X-Original-Trace: 14 Sep 2004 07:03:50 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:409
Article PK: 12522

I cannot setup a jdbc Connection Cache which will ping successfully. It
appears that all the jdbc Connection Caches which are pre-installed cannot
ping successfully either. If I use odbc it works; but, I need to setup a
jdbc connection.

Here is what I use:
GENERAL TABPAGE:
Database Type: Sybase_ASA
Server Name: jdbc:odbc:appeontutor
User Name: dba
Password: sql

DRIVER TABPAGE:
Database Driver Type: JDBC
DLL or Class Name: ianywhere.ml.jdbcodbc.IDriver

When I click Ping I get the following error:
Ping of appeontutor Connection Cache failed: Ping Failed
Main Exception: Error: Connection cache for server jdbc:odbc:appeontutor
does not exist.

Stephan


Julie Jiang Posted on 2004-09-15 07:09:18.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
Organization: 61.144.207.174
References: <4146fbfc$1@forums-2-dub>
X-Newsreader: AspNNTP 1.50 (Takeshi Eto)
Subject: Re: Appeon 2.8 Tutorial - Cannot ping to ASA db using jdbc
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: web110.discountasp.net
X-Original-NNTP-Posting-Host: web110.discountasp.net
Message-ID: <4147ea9e$1@forums-1-dub>
Date: 15 Sep 2004 00:09:18 -0700
X-Trace: forums-1-dub 1095232158 64.79.161.40 (15 Sep 2004 00:09:18 -0700)
X-Original-Trace: 15 Sep 2004 00:09:18 -0700, web110.discountasp.net
Lines: 58
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:410
Article PK: 12523

Stephan,

Section 7.2.6: Ping connection cache fails when using the ASA JDBC driver in the
Troubleshooting Guide provides the cause and solution. I copy the section here
for your easy reference.

A connection cache is created but fails to function and creates an error
beginning with “Ping of Connection Cache failed…” The database uses Sybase
Adaptive Server Anywhere; iAnywhere JDBC-ODBC Bridge Driver is used for the
connection cache.
Cause: the ASA JDBC driver and EAServer possibly fail to locate the dbjodbc8.dll
file.
Solution: follow the suggested steps to rectify your problem.
STEP 1 – Upgrade ASA to ASA 8.0.2 build 4361 or ASA 9.
STEP 2 – Navigate to \Sybase\SQL Anywhere 8\java\jodbc.jar, and copy the
jodbc.jar file to the %JAGUAR%\java\lib folder.
STEP 3 – Navigate to \Sybase\SQL Anywhere 8\win32\dbjodbc8.dll, and copy the
dbjodbc8.dll file into the directory: \Sybase\Shared\jdkversion\ire\bin\.
Jdkversion indicates which version of JDK is used, for example, jdk1.2.2_10,
jdk1.3.1_06, or jdk1.4.1_03.
STEP 4 – Restart EAServer.
STEP 5 – (Assuming that ase_odbc is the data source which is set up in ODBC
manager and used to connect to ASE database) The ServerName will be similar to
"jdbc:odbc:dsn=ase_odbc"
For more information, refer to Sybase’s EAServer Troubleshooting Guide available
at (http://sybooks.sybase.com/onlinebooks/group-eag/eag0500e/eastg).

Regards,
Julie Jiang
Appeon Corporation

On 14 Sep 2004 07:03:50 -0700,
in sybase.public.appeon

Stephan Donati <sdonati@rogers.com> wrote:
>I cannot setup a jdbc Connection Cache which will ping successfully. It
>appears that all the jdbc Connection Caches which are pre-installed cannot
>ping successfully either. If I use odbc it works; but, I need to setup a
>jdbc connection.
>
>Here is what I use:
>GENERAL TABPAGE:
>Database Type: Sybase_ASA
>Server Name: jdbc:odbc:appeontutor
>User Name: dba
>Password: sql
>
>DRIVER TABPAGE:
>Database Driver Type: JDBC
>DLL or Class Name: ianywhere.ml.jdbcodbc.IDriver
>
>When I click Ping I get the following error:
>Ping of appeontutor Connection Cache failed: Ping Failed
>Main Exception: Error: Connection cache for server jdbc:odbc:appeontutor
>does not exist.
>
>Stephan
>
>


Stephan Donati Posted on 2004-09-15 18:12:49.0Z
From: "Stephan Donati" <sdonati@rogers.com>
Newsgroups: sybase.public.appeon
References: <4146fbfc$1@forums-2-dub> <4147ea9e$1@forums-1-dub>
Subject: Re: Appeon 2.8 Tutorial - Cannot ping to ASA db using jdbc
Lines: 77
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: ebra.elections.ca
X-Original-NNTP-Posting-Host: ebra.elections.ca
Message-ID: <41488621$1@forums-1-dub>
Date: 15 Sep 2004 11:12:49 -0700
X-Trace: forums-1-dub 1095271969 198.103.171.2 (15 Sep 2004 11:12:49 -0700)
X-Original-Trace: 15 Sep 2004 11:12:49 -0700, ebra.elections.ca
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:414
Article PK: 12525

What if I only have the full ASA 7 installed? I believe the Appeon
Installer only installs the ASA 8 runtimes.

Stephan

"Julie Jiang" <julie.jiang@appeon.net> wrote in message
news:4147ea9e$1@forums-1-dub...
> Stephan,
>
> Section 7.2.6: Ping connection cache fails when using the ASA JDBC driver
in the
> Troubleshooting Guide provides the cause and solution. I copy the section
here
> for your easy reference.
>
> A connection cache is created but fails to function and creates an error
> beginning with "Ping of Connection Cache failed." The database uses Sybase
> Adaptive Server Anywhere; iAnywhere JDBC-ODBC Bridge Driver is used for
the
> connection cache.
> Cause: the ASA JDBC driver and EAServer possibly fail to locate the
dbjodbc8.dll
> file.
> Solution: follow the suggested steps to rectify your problem.
> STEP 1 - Upgrade ASA to ASA 8.0.2 build 4361 or ASA 9.
> STEP 2 - Navigate to \Sybase\SQL Anywhere 8\java\jodbc.jar, and copy the
> jodbc.jar file to the %JAGUAR%\java\lib folder.
> STEP 3 - Navigate to \Sybase\SQL Anywhere 8\win32\dbjodbc8.dll, and copy
the
> dbjodbc8.dll file into the directory: \Sybase\Shared\jdkversion\ire\bin\.
> Jdkversion indicates which version of JDK is used, for example,
jdk1.2.2_10,
> jdk1.3.1_06, or jdk1.4.1_03.
> STEP 4 - Restart EAServer.
> STEP 5 - (Assuming that ase_odbc is the data source which is set up in
ODBC
> manager and used to connect to ASE database) The ServerName will be
similar to
> "jdbc:odbc:dsn=ase_odbc"
> For more information, refer to Sybase's EAServer Troubleshooting Guide
available
> at (http://sybooks.sybase.com/onlinebooks/group-eag/eag0500e/eastg).
>
> Regards,
> Julie Jiang
> Appeon Corporation
>
> On 14 Sep 2004 07:03:50 -0700,
> in sybase.public.appeon
> Stephan Donati <sdonati@rogers.com> wrote:
> >I cannot setup a jdbc Connection Cache which will ping successfully. It
> >appears that all the jdbc Connection Caches which are pre-installed
cannot
> >ping successfully either. If I use odbc it works; but, I need to setup a
> >jdbc connection.
> >
> >Here is what I use:
> >GENERAL TABPAGE:
> >Database Type: Sybase_ASA
> >Server Name: jdbc:odbc:appeontutor
> >User Name: dba
> >Password: sql
> >
> >DRIVER TABPAGE:
> >Database Driver Type: JDBC
> >DLL or Class Name: ianywhere.ml.jdbcodbc.IDriver
> >
> >When I click Ping I get the following error:
> >Ping of appeontutor Connection Cache failed: Ping Failed
> >Main Exception: Error: Connection cache for server jdbc:odbc:appeontutor
> >does not exist.
> >
> >Stephan
> >
> >


Stephan Donati Posted on 2004-09-15 21:18:49.0Z
From: "Stephan Donati" <sdonati@rogers.com>
Newsgroups: sybase.public.appeon
References: <4146fbfc$1@forums-2-dub> <4147ea9e$1@forums-1-dub>
Subject: Re: Appeon 2.8 Tutorial - Cannot ping to ASA db using jdbc
Lines: 79
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: ns.elections.ca
Message-ID: <4148b375$1@forums-2-dub>
X-Original-Trace: 15 Sep 2004 14:26:13 -0700, ns.elections.ca
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 15 Sep 2004 14:06:40 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 15 Sep 2004 14:18:49 -0700
X-Trace: forums-1-dub 1095283129 10.22.108.75 (15 Sep 2004 14:18:49 -0700)
X-Original-Trace: 15 Sep 2004 14:18:49 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:415
Article PK: 20737

I'm not sure if the upgrade to ASA 8 fixed the problem because I was still
unable to connect after applying the changes recommended. When I changed
the 'Server Name' from 'jdbc:odbc:appeontutor' to
'jdbc:odbc:dsn=appeontutor' I was finally able to establish a connection.

Stephan

"Julie Jiang" <julie.jiang@appeon.net> wrote in message
news:4147ea9e$1@forums-1-dub...
> Stephan,
>
> Section 7.2.6: Ping connection cache fails when using the ASA JDBC driver
in the
> Troubleshooting Guide provides the cause and solution. I copy the section
here
> for your easy reference.
>
> A connection cache is created but fails to function and creates an error
> beginning with "Ping of Connection Cache failed." The database uses Sybase
> Adaptive Server Anywhere; iAnywhere JDBC-ODBC Bridge Driver is used for
the
> connection cache.
> Cause: the ASA JDBC driver and EAServer possibly fail to locate the
dbjodbc8.dll
> file.
> Solution: follow the suggested steps to rectify your problem.
> STEP 1 - Upgrade ASA to ASA 8.0.2 build 4361 or ASA 9.
> STEP 2 - Navigate to \Sybase\SQL Anywhere 8\java\jodbc.jar, and copy the
> jodbc.jar file to the %JAGUAR%\java\lib folder.
> STEP 3 - Navigate to \Sybase\SQL Anywhere 8\win32\dbjodbc8.dll, and copy
the
> dbjodbc8.dll file into the directory: \Sybase\Shared\jdkversion\ire\bin\.
> Jdkversion indicates which version of JDK is used, for example,
jdk1.2.2_10,
> jdk1.3.1_06, or jdk1.4.1_03.
> STEP 4 - Restart EAServer.
> STEP 5 - (Assuming that ase_odbc is the data source which is set up in
ODBC
> manager and used to connect to ASE database) The ServerName will be
similar to
> "jdbc:odbc:dsn=ase_odbc"
> For more information, refer to Sybase's EAServer Troubleshooting Guide
available
> at (http://sybooks.sybase.com/onlinebooks/group-eag/eag0500e/eastg).
>
> Regards,
> Julie Jiang
> Appeon Corporation
>
> On 14 Sep 2004 07:03:50 -0700,
> in sybase.public.appeon
> Stephan Donati <sdonati@rogers.com> wrote:
> >I cannot setup a jdbc Connection Cache which will ping successfully. It
> >appears that all the jdbc Connection Caches which are pre-installed
cannot
> >ping successfully either. If I use odbc it works; but, I need to setup a
> >jdbc connection.
> >
> >Here is what I use:
> >GENERAL TABPAGE:
> >Database Type: Sybase_ASA
> >Server Name: jdbc:odbc:appeontutor
> >User Name: dba
> >Password: sql
> >
> >DRIVER TABPAGE:
> >Database Driver Type: JDBC
> >DLL or Class Name: ianywhere.ml.jdbcodbc.IDriver
> >
> >When I click Ping I get the following error:
> >Ping of appeontutor Connection Cache failed: Ping Failed
> >Main Exception: Error: Connection cache for server jdbc:odbc:appeontutor
> >does not exist.
> >
> >Stephan
> >
> >


Julie Jiang Posted on 2004-09-16 10:39:24.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
Organization: 61.144.207.174
References: <4146fbfc$1@forums-2-dub> <4147ea9e$1@forums-1-dub> <4148b375$1@forums-2-dub>
X-Newsreader: AspNNTP 1.50 (Takeshi Eto)
Subject: Re: Appeon 2.8 Tutorial - Cannot ping to ASA db using jdbc
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: web110.discountasp.net
X-Original-NNTP-Posting-Host: web110.discountasp.net
Message-ID: <41496d5c$1@forums-1-dub>
Date: 16 Sep 2004 03:39:24 -0700
X-Trace: forums-1-dub 1095331164 64.79.161.40 (16 Sep 2004 03:39:24 -0700)
X-Original-Trace: 16 Sep 2004 03:39:24 -0700, web110.discountasp.net
Lines: 89
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:418
Article PK: 20735

It is correct to change the server name from 'jdbc:odbc:appeontutor' to
'jdbc:odbc:dsn=appeontutor'. The document has not made it clear. Appeon will
make the correction to the document.

Regards,
Julie

On 15 Sep 2004 14:18:49 -0700,
in sybase.public.appeon

Stephan Donati <sdonati@rogers.com> wrote:
>I'm not sure if the upgrade to ASA 8 fixed the problem because I was still
>unable to connect after applying the changes recommended. When I changed
>the 'Server Name' from 'jdbc:odbc:appeontutor' to
>'jdbc:odbc:dsn=appeontutor' I was finally able to establish a connection.
>
>Stephan
>
>"Julie Jiang" <julie.jiang@appeon.net> wrote in message
>news:4147ea9e$1@forums-1-dub...
>> Stephan,
>>
>> Section 7.2.6: Ping connection cache fails when using the ASA JDBC driver
>in the
>> Troubleshooting Guide provides the cause and solution. I copy the section
>here
>> for your easy reference.
>>
>> A connection cache is created but fails to function and creates an error
>> beginning with "Ping of Connection Cache failed." The database uses Sybase
>> Adaptive Server Anywhere; iAnywhere JDBC-ODBC Bridge Driver is used for
>the
>> connection cache.
>> Cause: the ASA JDBC driver and EAServer possibly fail to locate the
>dbjodbc8.dll
>> file.
>> Solution: follow the suggested steps to rectify your problem.
>> STEP 1 - Upgrade ASA to ASA 8.0.2 build 4361 or ASA 9.
>> STEP 2 - Navigate to \Sybase\SQL Anywhere 8\java\jodbc.jar, and copy the
>> jodbc.jar file to the %JAGUAR%\java\lib folder.
>> STEP 3 - Navigate to \Sybase\SQL Anywhere 8\win32\dbjodbc8.dll, and copy
>the
>> dbjodbc8.dll file into the directory: \Sybase\Shared\jdkversion\ire\bin\.
>> Jdkversion indicates which version of JDK is used, for example,
>jdk1.2.2_10,
>> jdk1.3.1_06, or jdk1.4.1_03.
>> STEP 4 - Restart EAServer.
>> STEP 5 - (Assuming that ase_odbc is the data source which is set up in
>ODBC
>> manager and used to connect to ASE database) The ServerName will be
>similar to
>> "jdbc:odbc:dsn=ase_odbc"
>> For more information, refer to Sybase's EAServer Troubleshooting Guide
>available
>> at (http://sybooks.sybase.com/onlinebooks/group-eag/eag0500e/eastg).
>>
>> Regards,
>> Julie Jiang
>> Appeon Corporation
>>
>> On 14 Sep 2004 07:03:50 -0700,
>> in sybase.public.appeon
>> Stephan Donati <sdonati@rogers.com> wrote:
>> >I cannot setup a jdbc Connection Cache which will ping successfully. It
>> >appears that all the jdbc Connection Caches which are pre-installed
>cannot
>> >ping successfully either. If I use odbc it works; but, I need to setup a
>> >jdbc connection.
>> >
>> >Here is what I use:
>> >GENERAL TABPAGE:
>> >Database Type: Sybase_ASA
>> >Server Name: jdbc:odbc:appeontutor
>> >User Name: dba
>> >Password: sql
>> >
>> >DRIVER TABPAGE:
>> >Database Driver Type: JDBC
>> >DLL or Class Name: ianywhere.ml.jdbcodbc.IDriver
>> >
>> >When I click Ping I get the following error:
>> >Ping of appeontutor Connection Cache failed: Ping Failed
>> >Main Exception: Error: Connection cache for server jdbc:odbc:appeontutor
>> >does not exist.
>> >
>> >Stephan
>> >
>> >
>
>