SQL Anywhere database - Connecting from desktop to running db server on Pocket PC

Author

Connecting from desktop to running db server on Pocket PC

Tim

2005-08-17, 8:23 pm

I've tried as many ways as I can think of to get connected with no success.
Here's what I'm using in an odbc datasource:

I've selected TCP/IP and put in:

host=127.0.0.1;dobroadcast=none
also
host=192.168.15.31;dobroadcast=none (device IP while connected to network
via wifi)
also
host=192.168.15. 31;dobroadcast=direc
t

If I typed all the different ways I tried, it would be over a page.

I get "Connection failed. Database server not found"

I've set the registry on my desktop that has activesync to
HKEY_LOCAL_MACHINE\S
OFTWARE\Microsoft\Wi
ndows CE Services\ProxyPorts to 2369

I've tried it with ActiveSync only, withn wifi only, with the device's IP,
with 127.0.0.1, with the port - 192.168.15.31:2369

Has someone actually done this lately? If so, what did you do? I'd like to
connect via Interactive SQL or Sybase Central

Thanks,
Tim

Greg Fenton

2005-08-17, 8:23 pm

Tim wrote:
>
> Has someone actually done this lately? If so, what did you do? I'd like to
> connect via Interactive SQL or Sybase Central
>

There are a few ways to do this.

One is posted at:

http://www.sybase.com/detail?id=1025441

> host=127.0.0.1;dobroadcast=none

When connected via ActiveSync, the PC's IP address is the magical IP of
192.168.55.100 and the device's IP is 192.168.55.101.

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

Joshua Savill

2005-08-18, 9:40 am

Tim,

I've heard of this problem with ASA 9.0.2 using Windows Mobile 2003 and
2005. What version of Windows CE is the Pocket PC running? What version and
build of ASA are you running?

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

"Tim" <nospam@nospam.com> wrote in message news:4303c272$1@foru
ms-2-dub...
> I've tried as many ways as I can think of to get connected with no
> success.
> Here's what I'm using in an odbc datasource:
>
> I've selected TCP/IP and put in:
>
> host=127.0.0.1;dobroadcast=none
> also
> host=192.168.15.31;dobroadcast=none (device IP while connected to
> network
> via wifi)
> also
> host=192.168.15. 31;dobroadcast=direc
t
>
> If I typed all the different ways I tried, it would be over a page.
>
>
> I get "Connection failed. Database server not found"
>
> I've set the registry on my desktop that has activesync to
> HKEY_LOCAL_MACHINE\S
OFTWARE\Microsoft\Wi
ndows CE Services\ProxyPorts to
> 2369
>
> I've tried it with ActiveSync only, withn wifi only, with the device's IP,
> with 127.0.0.1, with the port - 192.168.15.31:2369
>
> Has someone actually done this lately? If so, what did you do? I'd like to
> connect via Interactive SQL or Sybase Central
>
> Thanks,
> Tim
>
>

Tim

2005-08-18, 9:40 am

Joshua,
I am using Windows Mobile 2003 Second Edition on a new iPAQ, which I believe
is CE version 4.21.1088
ASA version 9.0.2.2451 (does this include build?)

The server window says "Access to the server is limited to 2 seat(s)". All
other messages in window look good.

I'm able to ping the ipaq from the desktop when it is connected via wifi and
I have confirmed that the database server is running.

I also had tried what Gregg suggested on his reply.

-Tim

"Joshua Savill" <jsavill@ianywhere.com> wrote in message
news:43047f57$1@foru
ms-1-dub...
> Tim,
>
> I've heard of this problem with ASA 9.0.2 using Windows Mobile 2003 and
> 2005. What version of Windows CE is the Pocket PC running? What version
and
> build of ASA are you running?
>
> --
> Joshua Savill
> iAnywhere Solutions - Product Support Analyst
>
> "Tim" <nospam@nospam.com> wrote in message news:4303c272$1@foru
ms-2-dub...
IP,[color=darkred]
to[color=darkred]
>
>

Donna Osburn

2005-08-18, 11:23 am

Just a few pointers.
Make sure db on hand held is running and hand held is turned
on (the obvious things first)
We add the following in our dsn on the hand held.

commlinks=ShMem
start=\Program Files\ASA9\dbsrv9.exe -c 4M -x
tcpip& #123;dobroadcast=no}

On the desktop side (because we do this often) we set up a
dsn that points to the mobile computer
in that dsn, fill in user name and password, then on network
tab. click tcpip and put in "host=192.168.1.156" where the
address is your hand held address and click the shared
memory box as well.
THis works for us every time.
Donna

> Joshua,
> I am using Windows Mobile 2003 Second Edition on a new
> iPAQ, which I believe is CE version 4.21.1088
> ASA version 9.0.2.2451 (does this include build?)
>
> The server window says "Access to the server is limited to
> 2 seat(s)". All other messages in window look good.
>
> I'm able to ping the ipaq from the desktop when it is
> connected via wifi and I have confirmed that the database
> server is running.
>
> I also had tried what Gregg suggested on his reply.
>
> -Tim
>
>
>
> "Joshua Savill" <jsavill@ianywhere.com> wrote in message
> news:43047f57$1@foru
ms-1-dub...
> Pocket PC running? What version and
> HKEY_LOCAL_MACHINE\S
OFTWARE\Microsoft\Wi
ndows CE
> with the device's IP,
> you do? I'd like to
>
>

Tim

2005-08-18, 8:23 pm

Got it. By starting my server on the device by launching it manually instead
of using my app and letting it start the server by connecting with it's own
connection string, and following the article
http://www.sybase.com/detail?id=1025441, I got it to work.
Thanks for the help.

"Tim" <nospam@nospam.com> wrote in message news:4303c272$1@foru
ms-2-dub...
> I've tried as many ways as I can think of to get connected with no
success.
> Here's what I'm using in an odbc datasource:
>
> I've selected TCP/IP and put in:
>
> host=127.0.0.1;dobroadcast=none
> also
> host=192.168.15.31;dobroadcast=none (device IP while connected to
network
> via wifi)
> also
> host=192.168.15. 31;dobroadcast=direc
t
>
> If I typed all the different ways I tried, it would be over a page.
>
>
> I get "Connection failed. Database server not found"
>
> I've set the registry on my desktop that has activesync to
> HKEY_LOCAL_MACHINE\S
OFTWARE\Microsoft\Wi
ndows CE Services\ProxyPorts to
2369
>
> I've tried it with ActiveSync only, withn wifi only, with the device's IP,
> with 127.0.0.1, with the port - 192.168.15.31:2369
>
> Has someone actually done this lately? If so, what did you do? I'd like to
> connect via Interactive SQL or Sybase Central
>
> Thanks,
> Tim
>
>

Sponsored Links