i setup a sql anywhere 9 on an ubuntu 6.10 server, am manage
to connect from client pc using sql anywhere 9 with ODBC but
when i try to connect using sql anywhere 6 with ODBC it
return the error database server not running. i have patch
the server until 9.0.2 build 3397 and client pc until 6.0.4
build 3799. i try setup the same database into windows xp
and it work for the sqlanywhere 6. can any1 help me..thanks

chris wrote in news:49b77322.1fd6.1681692777 (AT) sybase (DOT) com
of sybase.public.sqlanywhere.linux:

c> i setup a sql anywhere 9 on an ubuntu 6.10 server, am manage
c> to connect from client pc using sql anywhere 9 with ODBC but
c> when i try to connect using sql anywhere 6 with ODBC it
c> return the error database server not running. i have patch
c> the server until 9.0.2 build 3397 and client pc until 6.0.4
c> build 3799. i try setup the same database into windows xp
c> and it work for the sqlanywhere 6. can any1 help me..thanks

Lets start with some details.

For the combination that does not work.

1. Show us the dbsrv6 command line used.
2. Show us the dbisql (I assume you are using this to test) command
line used to connect.
3. Show us what hosts each of the above are executing on.
4. Show us the IP address of each of the hosts.
5. Show us the version (i.e. 6.0.4.3799 or 9.0.2.3397) of both the
client and the server for each host.


Is there a reason you are still using 6.x? Is it around 9 years old
at this point. Version 11 is out.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng11 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase....ctDocumentList

Documentation
http://dcx.sybase.com/

6.x to connect or the application cant run properly


1. i used the odbc in window xp to connect to the server,
the settings in like this ,dsn=mfx_old;server
name=xpdbsrv1;database name=mfx,tcpip=IP=192.168.0.2

2. i din't use dbisql to test

3.the host for the server is ubuntu server 6.10 while the
client side is win xp pro service pack 2

4.server ip is 192.168.0.2, client ip is 192.168.0.71 to
192.168.0.76

5.version for the server is 9.0.2.3397 while client is
6.0.4.3799

chris wrote in news:49b87738.3a2c.1681692777 (AT) sybase (DOT) com
of sybase.public.sqlanywhere.linux:


c>> 1. Show us the dbsrv6 command line used.

c> 1. i used the odbc in window xp to connect to the server,
c> the settings in like this ,dsn=mfx_old;server
c> name=xpdbsrv1;database name=mfx,tcpip=IP=192.168.0.2

I want to see how you are starting dbsrv6 on the _Ubuntu_ server, the
actual command line.

Given the above, it should be something like this:
dbsrv6 -x tcpip -n xpdbsrv1 /mfx.db



c>> 2. Show us the dbisql (I assume you are using this to
c>> test) command line used to connect.

c> 2. i din't use dbisql to test

Okay, only use dbisql until you get it to successfully connect. This
takes your application out of the picture.

Again, given the dbsrv6 command line above, then from your XP box
running ASA 9.0.2 you would issue:
dbisql -c uid=dba;pwd=sql;eng=xpdbsrv1;dbn=mfx;links=tcpip


c>> 3. Show us what hosts each of the above are executing on.
c> 3.the host for the server is ubuntu server 6.10 while the
c> client side is win xp pro service pack 2


c>> 4. Show us the IP address of each of the hosts.
c> 4.server ip is 192.168.0.2, client ip is 192.168.0.71 to
c> 192.168.0.76

Okay, so they are all within the same subnet. That is what I was
really checking for.


c>> 5. Show us the version (i.e. 6.0.4.3799 or 9.0.2.3397) of
c>> both the client and the server for each host.
c> 5.version for the server is 9.0.2.3397 while client is
c> 6.0.4.3799

Did you get the backwards?
I thought the server was running 6.x and the client was 9.x.

If I have it backwards (which is much more likely ) then reverse
things. You will issue the dbsrv9 command line on the Ubuntu server
and that will most likely be a dbisqlc.exe line for the 6.x client.

But make sure the 9.x dbisql (or dbisqlc) can connect first before you
try the 6.x dbisqlc.


If the 9.x dbisql connects and the 6.x dbisqlc does not, then:
1. Restart the server using -o eng.txt -Z
2. Try your 6.x dbisqlc again
3. Post the output of eng.txt

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng11 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase....ctDocumentList

Documentation
http://dcx.sybase.com/

just to be clear.. i am using 9.0.2 server and 6.0.4 on
client side.. i also have 9.0.2 installed on client side.

the command line for the server:
dbsrv9 -ud -c 512m -ch 512m -sb 0 -pc /mfx/mfx.db -n
mfx

i successfully connect using 9.x dbisql and dbisqlc but when
i try it on the 6.x dbisql it cannot connect & come out with
error msg "Database server not running". i follow your
instruction restart the server with -o eng.txt -Z but the
eng.txt did not exist.

the dbisql command i used:
dbisql -c
uid=dba;pwd=mfxsql;eng=xpdbsrv1;dbn=mfx;links=tcpi p(IP=192.168.1.3)

chris wrote in news:49befe9a.6308.1681692777 (AT) sybase (DOT) com of
sybase.public.sqlanywhere.linux:

Could you try this:
dbisql -c uid=dba;pwd=mfxsql;eng=xpdbsrv1;dbn=mfx;links=tcpi p(host=
192.168.1.3;DoBroadcast=No)

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng11 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase....ctDocumentList

Documentation
http://dcx.sybase.com/

"David Fishburn [Sybase]" <fishburn_spam_off (AT) ianywhere (DOT) com> wrote in
news:Xns9BD75E4AEB54Cfishburnsybasecom (AT) 10 (DOT) 22.241.106
of sybase.public.sqlanywhere.linux:


Actually, things have changed over time, so try this (thanks
Graeme):
dbisql -c uid=dba;pwd=mfxsql;eng=xpdbsrv1;dbn=mfx;links=tcpi p(host=
192.168.1.3;UseUDP=No)

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng11 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase....ctDocumentList

Documentation
http://dcx.sybase.com/

i have tried connect using "dbisql -c
uid=dba;pwd=mfxsql;eng=xpdbsrv1;dbn=mfx;links=tcpi p(host=
192.168.1.3;UseUDP=No)' but unfortunately it still return
the same error msg "Database server not running".

could this be the bug of ASA on ubuntu 6.10 because i have
no problem when i setup the database server on windows XP. i
havent try using other version of ubuntu but the fedora core
i used be4 i switch to ubuntu have not encounter such
problem be4.