SQL Anywhere database - PDA connect to another ASA in Lan

Author

PDA connect to another ASA in Lan

Sunshine

2005-10-28, 7:23 am

I want to know if application deployed in PDA can connect to ASA server in
LAN .
Of course PDA is in the LAN via WiFi.
Thanks a lot!

Greg Fenton

2005-10-28, 7:23 am

Sunshine wrote:
> I want to know if application deployed in PDA can connect to ASA server in
> LAN .
> Of course PDA is in the LAN via WiFi.

Which OS and version is on the PDA ?
Which version and build number of SQLAnywhere are you using? (e.g. use
the command "dbeng9 -v" for SQLAnywhere 9.x)
Which database API are you looking to work with? (ODBC? ESQL? ADO.NET?
etc...)

There is client ASA software for versions of WinCE, which can indeed
connect via TCP/IP to a network server.

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

Sunshine

2005-10-30, 8:23 pm

Hi
My PDA OS is ppc 2003.
ASA build number is 9.0.0.2415
I want to connect ASA via ODBC, and create a file DSN in PDA like ASA demo.
The only difference is my DSN file connect to another db engine in the lan,
demo connect to local engine
My DSN file content as follow:
--------------------------------------------
[ODBC]
DRIVER=Adaptive Server Anywhere 9.0
UID=dba
Integrated=No
AutoStop=Yes
EngineName=SalesDB_r
emote
--------------------------------------------
what is wrong?
And I want to build my application by PocketBuilder.Could you give me some
suggestion about PocketBuilder to connect database in Lan, such as ASA,
ASE,Oracle etc?
Thanks a lot!
"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com>
??????:43621667$1@forums-2-dub...
> Sunshine wrote:
>
> Which OS and version is on the PDA ?
> Which version and build number of SQLAnywhere are you using? (e.g. use the
> command "dbeng9 -v" for SQLAnywhere 9.x)
> Which database API are you looking to work with? (ODBC? ESQL? ADO.NET?
> etc...)
>
> There is client ASA software for versions of WinCE, which can indeed
> connect via TCP/IP to a network server.
>
> 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

2005-10-30, 8:23 pm

Sunshine wrote:
> --------------------------------------------
> [ODBC]
> DRIVER=Adaptive Server Anywhere 9.0
> UID=dba
> Integrated=No
> AutoStop=Yes
> EngineName=SalesDB_r
emote
> --------------------------------------------

With tihs DSN, the ASA client (the ODBC library in your case) will first
attempt to connect to a locally running server named "SalesDB_remote".
Should it fail to find such an engine, it would broadcast out to the
network (using a UDP broadcast) looking for a server with that name.
Should one respond, the client will attempt to log into that server.

If you know the host (or IP address) and port the server is running on,
then you could specify that information in the LINKS parameter:

Links=tcpip(host=my_
db_machine;port=2368
;dobroadcast=none)

[the above also tell the client to not bother broadcasting over the
network].

You could add a LOG parameter to your DSN to have the client library log
some debug information about its connection attempt:

Log=\asa_connection.txt

That file will contain information about what the client did in its
attempt to find the server, in the order of its attempt.

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/

Sunshine

2005-10-31, 3:23 am

Hi Greg
I have modifid my DSN file as follows:
--------------------------------------------------------------
[ODBC]
DRIVER=Adaptive Server Anywhere 9.0
UID=dba
Integrated=No
AutoStop=Yes
EngineName=SalesDB_r
emote
Links=tcpip(host=192
.168.0. 55;port=2638;dobroad
cast=none)
Log=\asa_connection.txt
----------------------------------------------------------------
There is stilll an error "SQLSTATE = IM003 [Sybase][ODBC Driver Loader]
Unable to load driver Adaptive Server Anywhere 9.0"
Why?
Thanks

"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com>
??????:436577c0@forums-2-dub...
> Sunshine wrote:
>
> With tihs DSN, the ASA client (the ODBC library in your case) will first
> attempt to connect to a locally running server named "SalesDB_remote".
> Should it fail to find such an engine, it would broadcast out to the
> network (using a UDP broadcast) looking for a server with that name.
> Should one respond, the client will attempt to log into that server.
>
> If you know the host (or IP address) and port the server is running on,
> then you could specify that information in the LINKS parameter:
>
> Links=tcpip(host=my_
db_machine;port=2368
;dobroadcast=none)
>
> [the above also tell the client to not bother broadcasting over the
> network].
>
> You could add a LOG parameter to your DSN to have the client library log
> some debug information about its connection attempt:
>
> Log=\asa_connection.txt
>
> That file will contain information about what the client did in its
> attempt to find the server, in the order of its attempt.
>
> 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/

Chance

2005-10-31, 9:23 am

Hi,
Mmmm...I use this to connect my pocket pc to a wireless access point at
my work. See my file DSN below... (Note, doesn't have to be wireless.
Same principal applies. For example, I do a similar thing to hit a
consolidated database for a mobilink project but that is a different
project..Anyway, I digress...)

Are you sure you have a network database engine running on this box? In
this example, I would have done the following on the LAN computer:

dbsrv9 -n blwserver blwmed.db

Then...on the box where the database engine is running, make sure I
have the right I.P. adress by using ipconfig.

Finally, modify the I.P address (if necessary) and then use active-sync
to put this file DSN (shown below) in the root directory of my pocket
pc.

[ODBC]
uid=dba
pwd=sql
enginename=blwserver

CommLinks=TCPIP(dobr
oadcast=DIRECT;HOST=
192.168.1.101;port=2638)
databasename=blwmed
driver=dbodbc9.dll

HTH,
chance.

p.s.
If you get Powerbuilders Developers Journal, you might be interested in
looking for an article entitled "A Real-Time Physical Inventory
Solution using PocketBuilder, ASA and a WI-FI connection" in next
months issue. It is based on my own experience learning about this and
a presenation I gave at this year's TechWave. If you don't, feel free
to e-mail me and I will send you a copy.

Sunshine wrote:[color=darkred
]
> Hi Greg
> I have modifid my DSN file as follows:
> --------------------------------------------------------------
> [ODBC]
> DRIVER=Adaptive Server Anywhere 9.0
> UID=dba
> Integrated=No
> AutoStop=Yes
> EngineName=SalesDB_r
emote
> Links=tcpip(host=192
.168.0. 55;port=2638;dobroad
cast=none)
> Log=\asa_connection.txt
> ----------------------------------------------------------------
> There is stilll an error "SQLSTATE = IM003 [Sybase][ODBC Driver Loader]
> Unable to load driver Adaptive Server Anywhere 9.0"
> Why?
> Thanks
>
> "Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com>
> ??????:436577c0@forums-2-dub...

Chris Keating(iAnywhere Solutions)

2005-10-31, 9:23 am

The DRIVER should be the path and file name of the ODBC driver on WinCE
as there is no Driver Manager. The ODBC driver is dbodbc9.dll.

For example,

DRIVER=\windows\dbod
bc9.dll
--

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 Case Express to report bugs http://case-express.sybase.com

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

Sponsored Links