All,

I am having a problem connecting to an ASA 9 dev edition server from another
machine on the network. I can ping the server IP address, so I know tcpip
works, but ISQL tells me that the database server cannot be found.

Is this allowed with the dev edition? I am evaluating and trying to test our
C/S app with it.

Thanks,

--

-----Jon Springs-----

Yes it is allowed.

Can you give us the command line options that you user to start your server,
and the connection options that you are using on the client?

Have you tried using dbping?

Have you tried using the connection options "Debug=Yes"
e.g. dbping -c "uid=dba;pwd=sql;eng=your_engine_name;links=tcpip; debug=yes"
The "debug=yes" will give you lots of diagnostic information on what it is
doing while it is trying to connect.

Is it possible that either the client or the server boxes have a firewall
running on them? (BTW: What OS and version are you using?)

Are the two machines in the same subnet?
--
Mark Culp
ASA Development
-------------------------------------------------------------------------
** Whitepapers, TechDocs, bug fixes are all available through the **
** iAnywhere Developer Community at http://www.ianywhere.com/developer **
-------------------------------------------------------------------------


Jon Springs wrote:

Try changing the "Check Network for Database Servers" checkbox located under
the startline entry on the connection dialog Database tab page. If that does
not work, click the Find button and verify that the server can be found.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

************************************************** **************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

************************************************** **************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

************************************************** **************************
*

"Jon Springs" <jspringsNO (AT) SPAMjontandshe (DOT) org> wrote

Jon Springs wrote:

In the ASA 9.0.0 docs, see the section:

ASA Database Administration Guide
Connecting to a Database
- Troubleshooting connections


Yes, absolutely.

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

Thanks for the responses, I found the problem and have ordered version 9 for
our upgrade.

-----Jon-----

"Jon Springs" <jspringsNO (AT) SPAMjontandshe (DOT) org> wrote