SQL Anywhere database - SQL Anywhere and PocketBuilder

Author

SQL Anywhere and PocketBuilder

Dimitris Karistinos

2005-07-14, 3:23 am

Hello group,

If this is not the correct newsgroup for this question please guide me to
the correct one.

I would like to know if the following is able to be done:

If I have ASA client installed in my PocketPC and I have developed an
application using PocketBuilder....is it possible to connect that
application over GPRS to a database based in my company network? What I am
trying to avoid is to place a database on my PocketPC

Regards
Dimitris Karistinos

Rob Waywell

2005-07-14, 9:23 am

Hi Dimitris,
You may find it worthwhile to forward this question to the
sybase.public.pocketpowerbuilder forum.

The ASA client libraries will only care that you have a TCPIP stack
available and that you can find the database server through that TCPIP
connection. The fact that the TCPIP stack happens to be running over top of
a GPRS connection will be hidden to us. It would be unusual for the speed
and stability of a cellular connection to be suitable for an application,
which is why smart client applications using MobiLink to synchronize data
between the consolidated and a local datastore on the handheld are so
effective, but this connection option is available to you.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
"Dimitris Karistinos" <dkaris@relational.gr> wrote in message
news:42d620a6@forums
-1-dub...
> Hello group,
>
> If this is not the correct newsgroup for this question please guide me to
> the correct one.
>
> I would like to know if the following is able to be done:
>
> If I have ASA client installed in my PocketPC and I have developed an
> application using PocketBuilder....is it possible to connect that
> application over GPRS to a database based in my company network? What I
> am trying to avoid is to place a database on my PocketPC
>
>
> Regards
> Dimitris Karistinos
>

Greg Fenton

2005-07-14, 9:23 am

Dimitris Karistinos wrote:
>
> If I have ASA client installed in my PocketPC and I have developed an
> application using PocketBuilder....is it possible to connect that
> application over GPRS to a database based in my company network? What I am
> trying to avoid is to place a database on my PocketPC
>

Yes, provided that the database server is accessible over the network
(i.e. via TCP/IP).

Assuming that your device can access the db server via TCP, then you
simply need to provide the write connection parameters to the ASA client
library such that it can connect to the server.

Here's an example connection string:

uid=DBA;pwd=SQL;eng=
DB_SERVER;links=TCPI
P(host=db1.mycorp.com;dobroad=none)

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/

Dimitris Karistinos

2005-07-14, 9:23 am

Thank you for your responses,

That is what I had in mind but I was not sure....After all if I have the
client in the pocketpc all I have to do is find a way to conect it to my
network.

After that it behaves like any othe pc client in the network.

Thank you again
Regards
Dimitris Karistinos
"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:42d66a14$1@foru
ms-2-dub...
> Dimitris Karistinos wrote:
>
> Yes, provided that the database server is accessible over the network
> (i.e. via TCP/IP).
>
> Assuming that your device can access the db server via TCP, then you
> simply need to provide the write connection parameters to the ASA client
> library such that it can connect to the server.
>
> Here's an example connection string:
>
> uid=DBA;pwd=SQL;eng=
DB_SERVER;links=TCPI
P(host=db1.mycorp.com;dobroad=none)
>
> 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/

Sponsored Links