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.

Probelm connecting to ASA8

9 posts in General Discussion Last posting was on 2004-08-19 19:37:02.0Z
Mike Sutton Posted on 2004-08-17 16:36:43.0Z
Sender: 695e.41223183.1804289383@sybase.com
From: Mike Sutton
Newsgroups: ianywhere.public.general
Subject: Probelm connecting to ASA8
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4122356d.699f.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 17 Aug 2004 09:42:21 -0700, 10.22.241.42
Lines: 18
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Aug 2004 09:27:25 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Aug 2004 09:36:43 -0700
X-Trace: forums-1-dub 1092760603 10.22.108.75 (17 Aug 2004 09:36:43 -0700)
X-Original-Trace: 17 Aug 2004 09:36:43 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3394
Article PK: 7301

I have a client running a PB 8 application connected to an
ASA 8.0.2 database. They are using dbsrv8.exe as the
network database server that's running on a server machine
that is on a different subnet than the client. When they
initially launched the application, they would recieve an
error stating that the application cannot connect to the
database; the applicaton cannot run unless it can conect to
the database. After searching the Sybase site, I had them
add the following parameters to the network tab of the ODBC
System DSN: host=IPAddressOfServer;dobroad=direct;port=2638.
After entering this, they tested the connection which
tested successfully and they were able to launch the
application OK. What they found after starting, stopping
and restarting the application is that the app will only
launch OK if the ODBC DSN is tested first before starting
the application otherwise they receive a connect error. Can
anyone help me determine what's causing this and how to fix
it? Any assistance would be greatly appreciated.


Rick Blythe Posted on 2004-08-17 18:04:34.0Z
Reply-To: "Rick Blythe" <nospam__rickb@sybase.com>
From: "Rick Blythe" <nospam__rickb@sybase.com>
Newsgroups: ianywhere.public.general
References: <4122356d.699f.1681692777@sybase.com>
Subject: Re: Probelm connecting to ASA8
Lines: 25
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: rickb-pc.sybase.com
Message-ID: <41224a06$1@forums-2-dub>
X-Original-Trace: 17 Aug 2004 11:10:14 -0700, rickb-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Aug 2004 10:55:17 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Aug 2004 11:04:34 -0700
X-Trace: forums-1-dub 1092765874 10.22.108.75 (17 Aug 2004 11:04:34 -0700)
X-Original-Trace: 17 Aug 2004 11:04:34 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3396
Article PK: 7302

On the network tab uncheck shared memory and check tcpip.



<Mike Sutton> wrote in message news:4122356d.699f.1681692777@sybase.com...
I have a client running a PB 8 application connected to an
ASA 8.0.2 database. They are using dbsrv8.exe as the
network database server that's running on a server machine
that is on a different subnet than the client. When they
initially launched the application, they would recieve an
error stating that the application cannot connect to the
database; the applicaton cannot run unless it can conect to
the database. After searching the Sybase site, I had them
add the following parameters to the network tab of the ODBC
System DSN: host=IPAddressOfServer;dobroad=direct;port=2638.
After entering this, they tested the connection which
tested successfully and they were able to launch the
application OK. What they found after starting, stopping
and restarting the application is that the app will only
launch OK if the ODBC DSN is tested first before starting
the application otherwise they receive a connect error. Can
anyone help me determine what's causing this and how to fix
it? Any assistance would be greatly appreciated.


Rick Blythe Posted on 2004-08-17 18:07:44.0Z
Reply-To: "Rick Blythe" <nospam__rickb@sybase.com>
From: "Rick Blythe" <nospam__rickb@sybase.com>
Newsgroups: ianywhere.public.general
References: <4122356d.699f.1681692777@sybase.com>
Subject: Re: Probelm connecting to ASA8
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: rickb-pc.sybase.com
Message-ID: <41224ac2$1@forums-2-dub>
X-Original-Trace: 17 Aug 2004 11:13:22 -0700, rickb-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Aug 2004 10:58:25 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Aug 2004 11:07:44 -0700
X-Trace: forums-1-dub 1092766064 10.22.108.75 (17 Aug 2004 11:07:44 -0700)
X-Original-Trace: 17 Aug 2004 11:07:44 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3397
Article PK: 7303

On the database tab make sure you put a servername at least.


<Mike Sutton> wrote in message news:4122356d.699f.1681692777@sybase.com...
I have a client running a PB 8 application connected to an
ASA 8.0.2 database. They are using dbsrv8.exe as the
network database server that's running on a server machine
that is on a different subnet than the client. When they
initially launched the application, they would recieve an
error stating that the application cannot connect to the
database; the applicaton cannot run unless it can conect to
the database. After searching the Sybase site, I had them
add the following parameters to the network tab of the ODBC
System DSN: host=IPAddressOfServer;dobroad=direct;port=2638.
After entering this, they tested the connection which
tested successfully and they were able to launch the
application OK. What they found after starting, stopping
and restarting the application is that the app will only
launch OK if the ODBC DSN is tested first before starting
the application otherwise they receive a connect error. Can
anyone help me determine what's causing this and how to fix
it? Any assistance would be greatly appreciated.


Mike Sutton Posted on 2004-08-17 18:36:04.0Z
Sender: 695e.41223183.1804289383@sybase.com
From: Mike Sutton
Newsgroups: ianywhere.public.general
Subject: Re: Probelm connecting to ASA8
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41225167.6c2a.1681692777@sybase.com>
References: <41224ac2$1@forums-2-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 17 Aug 2004 11:41:43 -0700, 10.22.241.42
Lines: 38
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Aug 2004 11:26:46 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Aug 2004 11:36:04 -0700
X-Trace: forums-1-dub 1092767764 10.22.108.75 (17 Aug 2004 11:36:04 -0700)
X-Original-Trace: 17 Aug 2004 11:36:04 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3398
Article PK: 7304

On the database tab the server name is there and on the
network tab, the tcpip box is checked. As a troubleshooting
test, the user's IT person physically relocated the user's
pc to the same subnet as the server and the application
worked just fine. I have other users who are in a similar
situation (client and server on different subnets) with the
parameters, including the server name and tcpip checked box,
and their application runs just fine.

> On the database tab make sure you put a servername at
> least.
>
>
> <Mike Sutton> wrote in message
> news:4122356d.699f.1681692777@sybase.com... I have a
> client running a PB 8 application connected to an ASA
> 8.0.2 database. They are using dbsrv8.exe as the network
> database server that's running on a server machine that is
> on a different subnet than the client. When they
> initially launched the application, they would recieve an
> error stating that the application cannot connect to the
> database; the applicaton cannot run unless it can conect
> to the database. After searching the Sybase site, I had
> them add the following parameters to the network tab of
> the ODBC System DSN: host=IPAddressOfServer;dobroad=direct
> ;port=2638.
> After entering this, they tested the connection which
> tested successfully and they were able to launch the
> application OK. What they found after starting, stopping
> and restarting the application is that the app will only
> launch OK if the ODBC DSN is tested first before starting
> the application otherwise they receive a connect error.
> Can anyone help me determine what's causing this and how
> to fix it? Any assistance would be greatly appreciated.
>
>


Rick Blythe Posted on 2004-08-17 18:41:17.0Z
Reply-To: "Rick Blythe" <nospam__rickb@sybase.com>
From: "Rick Blythe" <nospam__rickb@sybase.com>
Newsgroups: ianywhere.public.general
References: <41224ac2$1@forums-2-dub> <41225167.6c2a.1681692777@sybase.com>
Subject: Re: Probelm connecting to ASA8
Lines: 45
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: rickb-pc.sybase.com
Message-ID: <4122529f$1@forums-2-dub>
X-Original-Trace: 17 Aug 2004 11:46:55 -0700, rickb-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Aug 2004 11:31:58 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Aug 2004 11:41:17 -0700
X-Trace: forums-1-dub 1092768077 10.22.108.75 (17 Aug 2004 11:41:17 -0700)
X-Original-Trace: 17 Aug 2004 11:41:17 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3399
Article PK: 7306

Is your database already started on this server?
Can you ping it from the other subnet?


<Mike Sutton> wrote in message news:41225167.6c2a.1681692777@sybase.com...
On the database tab the server name is there and on the
network tab, the tcpip box is checked. As a troubleshooting
test, the user's IT person physically relocated the user's
pc to the same subnet as the server and the application
worked just fine. I have other users who are in a similar
situation (client and server on different subnets) with the
parameters, including the server name and tcpip checked box,
and their application runs just fine.

> On the database tab make sure you put a servername at
> least.
>
>
> <Mike Sutton> wrote in message
> news:4122356d.699f.1681692777@sybase.com... I have a
> client running a PB 8 application connected to an ASA
> 8.0.2 database. They are using dbsrv8.exe as the network
> database server that's running on a server machine that is
> on a different subnet than the client. When they
> initially launched the application, they would recieve an
> error stating that the application cannot connect to the
> database; the applicaton cannot run unless it can conect
> to the database. After searching the Sybase site, I had
> them add the following parameters to the network tab of
> the ODBC System DSN: host=IPAddressOfServer;dobroad=direct
> ;port=2638.
> After entering this, they tested the connection which
> tested successfully and they were able to launch the
> application OK. What they found after starting, stopping
> and restarting the application is that the app will only
> launch OK if the ODBC DSN is tested first before starting
> the application otherwise they receive a connect error.
> Can anyone help me determine what's causing this and how
> to fix it? Any assistance would be greatly appreciated.
>
>


Greg Fenton Posted on 2004-08-18 08:42:46.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20040803)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Probelm connecting to ASA8
References: <4122529f$1@forums-2-dub> <4122589c.6ce8.1681692777@sybase.com>
In-Reply-To: <4122589c.6ce8.1681692777@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 63.81.200.102
X-Original-NNTP-Posting-Host: 63.81.200.102
Message-ID: <41231686$1@forums-1-dub>
Date: 18 Aug 2004 01:42:46 -0700
X-Trace: forums-1-dub 1092818566 63.81.200.102 (18 Aug 2004 01:42:46 -0700)
X-Original-Trace: 18 Aug 2004 01:42:46 -0700, 63.81.200.102
Lines: 25
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3401
Article PK: 7307


Mike Sutton wrote:
> The service and the database are started. They can ping the
> server box from the client machine and access network drives
> mapped to this server. Are there any other parameters that
> you know of that could be tried in conjunction with those
> already being used?
>

Can you try the dbping utility from the client machine in question to
see if your connection parameters actually locate and connect to the
database:

dbping -d -c "uid=dba;pwd=sql;eng=foo;links=tcpip(host=...)"

If you still can't connect, try adding ";LOG=C:\dbping.out" to the
connection parameters and post the log file.

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


Mike Sutton Posted on 2004-08-18 16:24:48.0Z
Sender: 34e1.41235b08.1804289383@sybase.com
From: Mike Sutton
Newsgroups: ianywhere.public.general
Subject: Re: Probelm connecting to ASA8
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <412382d0.3ac5.1681692777@sybase.com>
References: <41231686$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Aug 2004 09:24:48 -0700
X-Trace: forums-1-dub 1092846288 10.22.241.41 (18 Aug 2004 09:24:48 -0700)
X-Original-Trace: 18 Aug 2004 09:24:48 -0700, 10.22.241.41
Lines: 31
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3403
Article PK: 7308

The client's IT person was able to run the utility and
successfully ping the database...

> Mike Sutton wrote:
> > The service and the database are started. They can ping
> > the server box from the client machine and access
> > network drives mapped to this server. Are there any
> > other parameters that you know of that could be tried in
> > conjunction with those already being used?
> >
>
> Can you try the dbping utility from the client machine in
> question to see if your connection parameters actually
> locate and connect to the database:
>
> dbping -d -c "uid=dba;pwd=sql;eng=foo
> ;links=tcpip(host=...)"
>
> If you still can't connect, try adding "
> ;LOG=C:\dbping.out" to the connection parameters and post
> the log file.
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/


Greg Fenton Posted on 2004-08-19 19:37:02.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20040803)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Probelm connecting to ASA8
References: <41231686$1@forums-1-dub> <412382d0.3ac5.1681692777@sybase.com>
In-Reply-To: <412382d0.3ac5.1681692777@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: charger.intuit.com
X-Original-NNTP-Posting-Host: charger.intuit.com
Message-ID: <4125015e@forums-1-dub>
Date: 19 Aug 2004 12:37:02 -0700
X-Trace: forums-1-dub 1092944222 208.240.243.170 (19 Aug 2004 12:37:02 -0700)
X-Original-Trace: 19 Aug 2004 12:37:02 -0700, charger.intuit.com
Lines: 16
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3410
Article PK: 7315


Mike Sutton wrote:
> The client's IT person was able to run the utility and
> successfully ping the database...
>

So all is good now? If not, can you post the LOG I mentioned in my
previous post?

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