Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Deploying PocketPB app to PocketPC 2002 emulator

7 posts in Pocket PowerBuilder Last posting was on 2003-09-03 22:19:34.0Z
Brian Vickery Posted on 2003-09-02 19:52:09.0Z
From: "Brian Vickery" <nospamplsvick9935@yahoo.com>
Newsgroups: sybase.public.pocketpowerbuilder
Subject: Deploying PocketPB app to PocketPC 2002 emulator
Keywords: PocketPB,ODBC,ASA,emulator
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 12-255-194-112.client.attbi.com
X-Original-NNTP-Posting-Host: 12-255-194-112.client.attbi.com
Message-ID: <3f54f4e9$1@forums-1-dub>
Date: 2 Sep 2003 12:52:09 -0700
X-Trace: forums-1-dub 1062532329 12.255.194.112 (2 Sep 2003 12:52:09 -0700)
X-Original-Trace: 2 Sep 2003 12:52:09 -0700, 12-255-194-112.client.attbi.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:333
Article PK: 266870

I am looking for a simple set of instructions that takes me "from cradle to
grave" when deploying a PocketPB app to the PocketPC 2002 emulator. Here is
what I've done:

1. Deployed the PocketPB x86 CAB file to the emulator successfully
2. Deployed the ASA8 x86 CAB file to the emulator successfully
3. Deployed the PocketPB app successfully

Here is what I am looking for...

I seem to be missing the steps in the ASA db deployment (I'm not even at the
point where I can start talking synchronization). I have a central ASA
database that is currently about 8MB...but I want a subset of tables (and
table data) to make it to the pocketPC. Therefore, I went ahead and created
another blank ASA database. I can use the Windows CE File Viewer to copy
this blank database over to the pocketPC, but how do I setup the typical
ODBC profile to connect to it? In fact, I am having to use the Windows CE
File Viewer because I am developing on a laptop...which doesn't have two COM
ports (therefore, I cannot setup an ActiveSync partnership to the emulator).

I've tried to wade through the iAnywhere help file, but I can't seem to find
a nice example of how to deploy an ASA database with subsets of tables and
data. I am not cross-posting to the iAnywhere site because I would like
someone with a PocketPB hat to answer the question.

I would like to get to the point where I have this remote db with just a few
records, so I can confirm that my PocketPB app is working fine. Then, I can
start researching how to setup the synchronization scripts.

As an aside, I did try to execute the application, and it came up with a
dialog to select the datasource. I selected the db filename, and it forced
the emulator to restart. When it came back up, I had lost all of the work
established in the three steps above (deploying using CAB files). I had
ensured that I had exited the emulator gracefully...a number of
times...saving the state each time. I would have thought that would have
protected me...did the emulator somehow go back to factory settings?

Thanks for the help.

Brian


Reed Shilts [Sybase] Posted on 2003-09-03 00:17:49.0Z
From: "Reed Shilts [Sybase]" <reed.dot.shilts.at.sybase.dot.com>
Newsgroups: sybase.public.pocketpowerbuilder
Subject: Re: Deploying PocketPB app to PocketPC 2002 emulator
Organization: Sybase
Message-ID: <9icalvk3olba6bf8moi8ssc1qskfav77s3@4ax.com>
References: <3f54f4e9$1@forums-1-dub>
X-Newsreader: Forte Agent 1.93/32.576 English (American)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: rshilts.sybase.com
X-Original-NNTP-Posting-Host: rshilts.sybase.com
Date: 2 Sep 2003 17:17:49 -0700
X-Trace: forums-1-dub 1062548269 10.18.61.76 (2 Sep 2003 17:17:49 -0700)
X-Original-Trace: 2 Sep 2003 17:17:49 -0700, rshilts.sybase.com
Lines: 56
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:335
Article PK: 266872

The goal of the tutorial was to provide
the "cradle to grave" recipe (mixing metaphors?)

Give that a try.

HTH,
Reed Shilts
PocketPB Development Manager
<Standard-Disclaimers-Apply/>


On 2 Sep 2003 12:52:09 -0700, "Brian Vickery"

<nospamplsvick9935@yahoo.com> wrote:

>I am looking for a simple set of instructions that takes me "from cradle to
>grave" when deploying a PocketPB app to the PocketPC 2002 emulator. Here is
>what I've done:
>
>1. Deployed the PocketPB x86 CAB file to the emulator successfully
>2. Deployed the ASA8 x86 CAB file to the emulator successfully
>3. Deployed the PocketPB app successfully
>
>Here is what I am looking for...
>
>I seem to be missing the steps in the ASA db deployment (I'm not even at the
>point where I can start talking synchronization). I have a central ASA
>database that is currently about 8MB...but I want a subset of tables (and
>table data) to make it to the pocketPC. Therefore, I went ahead and created
>another blank ASA database. I can use the Windows CE File Viewer to copy
>this blank database over to the pocketPC, but how do I setup the typical
>ODBC profile to connect to it? In fact, I am having to use the Windows CE
>File Viewer because I am developing on a laptop...which doesn't have two COM
>ports (therefore, I cannot setup an ActiveSync partnership to the emulator).
>
>I've tried to wade through the iAnywhere help file, but I can't seem to find
>a nice example of how to deploy an ASA database with subsets of tables and
>data. I am not cross-posting to the iAnywhere site because I would like
>someone with a PocketPB hat to answer the question.
>
>I would like to get to the point where I have this remote db with just a few
>records, so I can confirm that my PocketPB app is working fine. Then, I can
>start researching how to setup the synchronization scripts.
>
>As an aside, I did try to execute the application, and it came up with a
>dialog to select the datasource. I selected the db filename, and it forced
>the emulator to restart. When it came back up, I had lost all of the work
>established in the three steps above (deploying using CAB files). I had
>ensured that I had exited the emulator gracefully...a number of
>times...saving the state each time. I would have thought that would have
>protected me...did the emulator somehow go back to factory settings?
>
>Thanks for the help.
>
>Brian
>


dw-extreme Posted on 2003-09-03 02:41:16.0Z
Sender: 649b.3f55531b.1804289383@sybase.com
From: dw-extreme
Newsgroups: sybase.public.pocketpowerbuilder
Subject: Re: Deploying PocketPB app to PocketPC 2002 emulator
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f5554cc.64b3.846930886@sybase.com>
References: <3f54f4e9$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Sep 2003 19:41:16 -0700
X-Trace: forums-1-dub 1062556876 10.22.241.41 (2 Sep 2003 19:41:16 -0700)
X-Original-Trace: 2 Sep 2003 19:41:16 -0700, 10.22.241.41
Lines: 75
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:336
Article PK: 266873

That is precisely the problem I encountered with the
documentation. You want a top down solution and the
documentation is object oriented.

To do x you must set up y go to the y setup page
To set up y requires process b go to that page
To set up process b go the the chapter on processes page 34
processes require ____ on this document
goto top replace x with a and start over

Seriously

You need to make sure you have a file dsn set up on your
device. Create the file on your workstation and move it to
the device. The dsn file needs to be located on the root
directory (so I read). Make sure before you do your connect
that you use FILEDSN= and not DSN= in your connectstring.

Once its set up it works great, I am really impressed with
PPB and all the goodies that are added.

Hope this helps.

dwx

> I am looking for a simple set of instructions that takes
> me "from cradle to grave" when deploying a PocketPB app to
> the PocketPC 2002 emulator. Here is what I've done:
>
> 1. Deployed the PocketPB x86 CAB file to the emulator
> successfully 2. Deployed the ASA8 x86 CAB file to the
> emulator successfully 3. Deployed the PocketPB app
> successfully
>
> Here is what I am looking for...
>
> I seem to be missing the steps in the ASA db deployment
> (I'm not even at the point where I can start talking
> synchronization). I have a central ASA database that is
> currently about 8MB...but I want a subset of tables (and
> table data) to make it to the pocketPC. Therefore, I went
> ahead and created another blank ASA database. I can use
> the Windows CE File Viewer to copy this blank database
> over to the pocketPC, but how do I setup the typical ODBC
> profile to connect to it? In fact, I am having to use the
> Windows CE File Viewer because I am developing on a
> laptop...which doesn't have two COM ports (therefore, I
> cannot setup an ActiveSync partnership to the emulator).
>
> I've tried to wade through the iAnywhere help file, but I
> can't seem to find a nice example of how to deploy an ASA
> database with subsets of tables and data. I am not
> cross-posting to the iAnywhere site because I would like
> someone with a PocketPB hat to answer the question.
>
> I would like to get to the point where I have this remote
> db with just a few records, so I can confirm that my
> PocketPB app is working fine. Then, I can start
> researching how to setup the synchronization scripts.
>
> As an aside, I did try to execute the application, and it
> came up with a dialog to select the datasource. I
> selected the db filename, and it forced the emulator to
> restart. When it came back up, I had lost all of the work
> established in the three steps above (deploying using CAB
> files). I had ensured that I had exited the emulator
> gracefully...a number of times...saving the state each
> time. I would have thought that would have protected
> me...did the emulator somehow go back to factory settings?
>
> Thanks for the help.
>
> Brian
>
>


Brian Vickery Posted on 2003-09-03 17:12:34.0Z
From: "Brian Vickery" <nospamplsvick9935@yahoo.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f54f4e9$1@forums-1-dub> <3f5554cc.64b3.846930886@sybase.com>
Subject: Re: Deploying PocketPB app to PocketPC 2002 emulator
Lines: 112
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 12-255-194-112.client.attbi.com
X-Original-NNTP-Posting-Host: 12-255-194-112.client.attbi.com
Message-ID: <3f562102$1@forums-1-dub>
Date: 3 Sep 2003 10:12:34 -0700
X-Trace: forums-1-dub 1062609154 12.255.194.112 (3 Sep 2003 10:12:34 -0700)
X-Original-Trace: 3 Sep 2003 10:12:34 -0700, 12-255-194-112.client.attbi.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:356
Article PK: 266892

Now you are hitting on one of my issues. Yes, before I get to the
"cradle-to-grave" synchronization outlined in the tutorial, I want to test
my PPB application with a static ASA database.

1. I can create the database, and then put some sample data in there.
2. I could then move to the emulator using the PocketPC 2002 CE File Viewer
(pain to not have ActiveSynch available, but no extra COM port).
3. The .db file must be in the root directory itself...or just the odbc file
that points to the .db file? I deployed the sample ASA db to the emulator,
but I do not see any type of odbc.ini file in any of the directories.

With your reference to FILEDSN (which I could find no help on in the
PocketPB help), would my sample profile change:

Example:

// Profile MYTESTDB
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=MYTESTDB;UID=myuser;PWD=mypass'"

Becomes...

// Profile MYTESTDB
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='FILEDSN=MYTESTDB;UID=myuser;PWD=mypass'"

Thanks for the help. Yes, PocketPB looks to be ideal for development
(especially if already aware of the power of datawindows and NVOs).

Brian


<dw-extreme> wrote in message news:3f5554cc.64b3.846930886@sybase.com...
That is precisely the problem I encountered with the
documentation. You want a top down solution and the
documentation is object oriented.

To do x you must set up y go to the y setup page
To set up y requires process b go to that page
To set up process b go the the chapter on processes page 34
processes require ____ on this document
goto top replace x with a and start over

Seriously

You need to make sure you have a file dsn set up on your
device. Create the file on your workstation and move it to
the device. The dsn file needs to be located on the root
directory (so I read). Make sure before you do your connect
that you use FILEDSN= and not DSN= in your connectstring.

Once its set up it works great, I am really impressed with
PPB and all the goodies that are added.

Hope this helps.

dwx

> I am looking for a simple set of instructions that takes
> me "from cradle to grave" when deploying a PocketPB app to
> the PocketPC 2002 emulator. Here is what I've done:
>
> 1. Deployed the PocketPB x86 CAB file to the emulator
> successfully 2. Deployed the ASA8 x86 CAB file to the
> emulator successfully 3. Deployed the PocketPB app
> successfully
>
> Here is what I am looking for...
>
> I seem to be missing the steps in the ASA db deployment
> (I'm not even at the point where I can start talking
> synchronization). I have a central ASA database that is
> currently about 8MB...but I want a subset of tables (and
> table data) to make it to the pocketPC. Therefore, I went
> ahead and created another blank ASA database. I can use
> the Windows CE File Viewer to copy this blank database
> over to the pocketPC, but how do I setup the typical ODBC
> profile to connect to it? In fact, I am having to use the
> Windows CE File Viewer because I am developing on a
> laptop...which doesn't have two COM ports (therefore, I
> cannot setup an ActiveSync partnership to the emulator).
>
> I've tried to wade through the iAnywhere help file, but I
> can't seem to find a nice example of how to deploy an ASA
> database with subsets of tables and data. I am not
> cross-posting to the iAnywhere site because I would like
> someone with a PocketPB hat to answer the question.
>
> I would like to get to the point where I have this remote
> db with just a few records, so I can confirm that my
> PocketPB app is working fine. Then, I can start
> researching how to setup the synchronization scripts.
>
> As an aside, I did try to execute the application, and it
> came up with a dialog to select the datasource. I
> selected the db filename, and it forced the emulator to
> restart. When it came back up, I had lost all of the work
> established in the three steps above (deploying using CAB
> files). I had ensured that I had exited the emulator
> gracefully...a number of times...saving the state each
> time. I would have thought that would have protected
> me...did the emulator somehow go back to factory settings?
>
> Thanks for the help.
>
> Brian
>
>


Brian Vickery Posted on 2003-09-03 17:18:58.0Z
From: "Brian Vickery" <nospamplsvick9935@yahoo.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f54f4e9$1@forums-1-dub> <3f5554cc.64b3.846930886@sybase.com> <3f562102$1@forums-1-dub>
Subject: Re: Deploying PocketPB app to PocketPC 2002 emulator
Lines: 121
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 12-255-194-112.client.attbi.com
X-Original-NNTP-Posting-Host: 12-255-194-112.client.attbi.com
Message-ID: <3f562282$1@forums-1-dub>
Date: 3 Sep 2003 10:18:58 -0700
X-Trace: forums-1-dub 1062609538 12.255.194.112 (3 Sep 2003 10:18:58 -0700)
X-Original-Trace: 3 Sep 2003 10:18:58 -0700, 12-255-194-112.client.attbi.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:357
Article PK: 266893

Ack...my bad. Looks like I just found the .dsn file in the root directory
(for the sample ASA8 database).

Let me experiment with that...

Brian
"Brian Vickery" <nospamplsvick9935@yahoo.com> wrote in message
news:3f562102$1@forums-1-dub...
Now you are hitting on one of my issues. Yes, before I get to the
"cradle-to-grave" synchronization outlined in the tutorial, I want to test
my PPB application with a static ASA database.

1. I can create the database, and then put some sample data in there.
2. I could then move to the emulator using the PocketPC 2002 CE File Viewer
(pain to not have ActiveSynch available, but no extra COM port).
3. The .db file must be in the root directory itself...or just the odbc file
that points to the .db file? I deployed the sample ASA db to the emulator,
but I do not see any type of odbc.ini file in any of the directories.

With your reference to FILEDSN (which I could find no help on in the
PocketPB help), would my sample profile change:

Example:

// Profile MYTESTDB
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=MYTESTDB;UID=myuser;PWD=mypass'"

Becomes...

// Profile MYTESTDB
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='FILEDSN=MYTESTDB;UID=myuser;PWD=mypass'"

Thanks for the help. Yes, PocketPB looks to be ideal for development
(especially if already aware of the power of datawindows and NVOs).

Brian


<dw-extreme> wrote in message news:3f5554cc.64b3.846930886@sybase.com...
That is precisely the problem I encountered with the
documentation. You want a top down solution and the
documentation is object oriented.

To do x you must set up y go to the y setup page
To set up y requires process b go to that page
To set up process b go the the chapter on processes page 34
processes require ____ on this document
goto top replace x with a and start over

Seriously

You need to make sure you have a file dsn set up on your
device. Create the file on your workstation and move it to
the device. The dsn file needs to be located on the root
directory (so I read). Make sure before you do your connect
that you use FILEDSN= and not DSN= in your connectstring.

Once its set up it works great, I am really impressed with
PPB and all the goodies that are added.

Hope this helps.

dwx

> I am looking for a simple set of instructions that takes
> me "from cradle to grave" when deploying a PocketPB app to
> the PocketPC 2002 emulator. Here is what I've done:
>
> 1. Deployed the PocketPB x86 CAB file to the emulator
> successfully 2. Deployed the ASA8 x86 CAB file to the
> emulator successfully 3. Deployed the PocketPB app
> successfully
>
> Here is what I am looking for...
>
> I seem to be missing the steps in the ASA db deployment
> (I'm not even at the point where I can start talking
> synchronization). I have a central ASA database that is
> currently about 8MB...but I want a subset of tables (and
> table data) to make it to the pocketPC. Therefore, I went
> ahead and created another blank ASA database. I can use
> the Windows CE File Viewer to copy this blank database
> over to the pocketPC, but how do I setup the typical ODBC
> profile to connect to it? In fact, I am having to use the
> Windows CE File Viewer because I am developing on a
> laptop...which doesn't have two COM ports (therefore, I
> cannot setup an ActiveSync partnership to the emulator).
>
> I've tried to wade through the iAnywhere help file, but I
> can't seem to find a nice example of how to deploy an ASA
> database with subsets of tables and data. I am not
> cross-posting to the iAnywhere site because I would like
> someone with a PocketPB hat to answer the question.
>
> I would like to get to the point where I have this remote
> db with just a few records, so I can confirm that my
> PocketPB app is working fine. Then, I can start
> researching how to setup the synchronization scripts.
>
> As an aside, I did try to execute the application, and it
> came up with a dialog to select the datasource. I
> selected the db filename, and it forced the emulator to
> restart. When it came back up, I had lost all of the work
> established in the three steps above (deploying using CAB
> files). I had ensured that I had exited the emulator
> gracefully...a number of times...saving the state each
> time. I would have thought that would have protected
> me...did the emulator somehow go back to factory settings?
>
> Thanks for the help.
>
> Brian
>
>


Peg Ostlund Posted on 2003-09-03 17:32:21.0Z
From: "Peg Ostlund" <peggy.ostlund@sybase.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f54f4e9$1@forums-1-dub> <3f5554cc.64b3.846930886@sybase.com> <3f562102$1@forums-1-dub> <3f562282$1@forums-1-dub>
Subject: Re: Deploying PocketPB app to PocketPC 2002 emulator
Lines: 147
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4920.2300
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4920.2300
NNTP-Posting-Host: postlundw2k.sybase.com
X-Original-NNTP-Posting-Host: postlundw2k.sybase.com
Message-ID: <3f5625a5$1@forums-1-dub>
Date: 3 Sep 2003 10:32:21 -0700
X-Trace: forums-1-dub 1062610341 204.167.46.233 (3 Sep 2003 10:32:21 -0700)
X-Original-Trace: 3 Sep 2003 10:32:21 -0700, postlundw2k.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:358
Article PK: 266896

It's the .DSN file that 'points' to the db that needs to be in the root
directory.
In that file, you specify the location of the .db file. The dsn file for
the ASA Sample db is below. Note the "databasefile=" line that gives the
path and name of the db file.

[ODBC]
uid=dba
pwd=sql
enginename=asademo
databasename=asademo
databasefile=\Program Files\Sybase\ASA\asademo.db
start=\Program Files\Sybase\ASA\dbsrv8.exe

Incidentally, "DSN" in the connect string works for me.

Peg

"Brian Vickery" <nospamplsvick9935@yahoo.com> wrote in message
news:3f562282$1@forums-1-dub...
> Ack...my bad. Looks like I just found the .dsn file in the root directory
> (for the sample ASA8 database).
>
> Let me experiment with that...
>
> Brian
> "Brian Vickery" <nospamplsvick9935@yahoo.com> wrote in message
> news:3f562102$1@forums-1-dub...
> Now you are hitting on one of my issues. Yes, before I get to the
> "cradle-to-grave" synchronization outlined in the tutorial, I want to test
> my PPB application with a static ASA database.
>
> 1. I can create the database, and then put some sample data in there.
> 2. I could then move to the emulator using the PocketPC 2002 CE File
Viewer
> (pain to not have ActiveSynch available, but no extra COM port).
> 3. The .db file must be in the root directory itself...or just the odbc
file
> that points to the .db file? I deployed the sample ASA db to the
emulator,
> but I do not see any type of odbc.ini file in any of the directories.
>
> With your reference to FILEDSN (which I could find no help on in the
> PocketPB help), would my sample profile change:
>
> Example:
>
> // Profile MYTESTDB
> SQLCA.DBMS = "ODBC"
> SQLCA.AutoCommit = False
> SQLCA.DBParm = "ConnectString='DSN=MYTESTDB;UID=myuser;PWD=mypass'"
>
> Becomes...
>
> // Profile MYTESTDB
> SQLCA.DBMS = "ODBC"
> SQLCA.AutoCommit = False
> SQLCA.DBParm = "ConnectString='FILEDSN=MYTESTDB;UID=myuser;PWD=mypass'"
>
> Thanks for the help. Yes, PocketPB looks to be ideal for development
> (especially if already aware of the power of datawindows and NVOs).
>
> Brian
>
>
> <dw-extreme> wrote in message news:3f5554cc.64b3.846930886@sybase.com...
> That is precisely the problem I encountered with the
> documentation. You want a top down solution and the
> documentation is object oriented.
>
> To do x you must set up y go to the y setup page
> To set up y requires process b go to that page
> To set up process b go the the chapter on processes page 34
> processes require ____ on this document
> goto top replace x with a and start over
>
> Seriously
>
> You need to make sure you have a file dsn set up on your
> device. Create the file on your workstation and move it to
> the device. The dsn file needs to be located on the root
> directory (so I read). Make sure before you do your connect
> that you use FILEDSN= and not DSN= in your connectstring.
>
> Once its set up it works great, I am really impressed with
> PPB and all the goodies that are added.
>
> Hope this helps.
>
> dwx
>
> > I am looking for a simple set of instructions that takes
> > me "from cradle to grave" when deploying a PocketPB app to
> > the PocketPC 2002 emulator. Here is what I've done:
> >
> > 1. Deployed the PocketPB x86 CAB file to the emulator
> > successfully 2. Deployed the ASA8 x86 CAB file to the
> > emulator successfully 3. Deployed the PocketPB app
> > successfully
> >
> > Here is what I am looking for...
> >
> > I seem to be missing the steps in the ASA db deployment
> > (I'm not even at the point where I can start talking
> > synchronization). I have a central ASA database that is
> > currently about 8MB...but I want a subset of tables (and
> > table data) to make it to the pocketPC. Therefore, I went
> > ahead and created another blank ASA database. I can use
> > the Windows CE File Viewer to copy this blank database
> > over to the pocketPC, but how do I setup the typical ODBC
> > profile to connect to it? In fact, I am having to use the
> > Windows CE File Viewer because I am developing on a
> > laptop...which doesn't have two COM ports (therefore, I
> > cannot setup an ActiveSync partnership to the emulator).
> >
> > I've tried to wade through the iAnywhere help file, but I
> > can't seem to find a nice example of how to deploy an ASA
> > database with subsets of tables and data. I am not
> > cross-posting to the iAnywhere site because I would like
> > someone with a PocketPB hat to answer the question.
> >
> > I would like to get to the point where I have this remote
> > db with just a few records, so I can confirm that my
> > PocketPB app is working fine. Then, I can start
> > researching how to setup the synchronization scripts.
> >
> > As an aside, I did try to execute the application, and it
> > came up with a dialog to select the datasource. I
> > selected the db filename, and it forced the emulator to
> > restart. When it came back up, I had lost all of the work
> > established in the three steps above (deploying using CAB
> > files). I had ensured that I had exited the emulator
> > gracefully...a number of times...saving the state each
> > time. I would have thought that would have protected
> > me...did the emulator somehow go back to factory settings?
> >
> > Thanks for the help.
> >
> > Brian
> >
> >
>
>
>


dw-extreme Posted on 2003-09-03 22:19:34.0Z
Sender: 6d7d.3f56683d.1804289383@sybase.com
From: dw-extreme
Newsgroups: sybase.public.pocketpowerbuilder
Subject: Re: Deploying PocketPB app to PocketPC 2002 emulator
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f566942.6d88.846930886@sybase.com>
References: <3f54f4e9$1@forums-1-dub> <3f5554cc.64b3.846930886@sybase.com><3f562102$1@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 3 Sep 2003 15:20:50 -0700, 10.22.241.42
Lines: 142
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Sep 2003 15:17:23 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Sep 2003 15:19:34 -0700
X-Trace: forums-1-dub 1062627574 10.22.108.75 (3 Sep 2003 15:19:34 -0700)
X-Original-Trace: 3 Sep 2003 15:19:34 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:364
Article PK: 266900

Yes you are right about FILEDSN. I actually have not run
ASA on the emulator, only on a device. The db file can be
in any directory, the dsn file must be in the root
directory. there is no odbc.ini you create the dsn file
from that data.

Here is a dsn file
[ODBC]
DRIVER=dbodbc8.dll
UID=dba
Compress=No
DisableMultiRowFetch=No
Debug=No
Integrated=No
AutoStop=Yes
enginename=mobile_client
DatabaseName=mobile_client
DatabaseFile=\My Documents\Personal\mobile_client.db
start=\Program Files\Sybase\ASA\dbsrv8.exe -q

good luck

> Now you are hitting on one of my issues. Yes, before I
> get to the "cradle-to-grave" synchronization outlined in
> the tutorial, I want to test my PPB application with a
> static ASA database.
>
> 1. I can create the database, and then put some sample
> data in there. 2. I could then move to the emulator using
> the PocketPC 2002 CE File Viewer (pain to not have
> ActiveSynch available, but no extra COM port). 3. The .db
> file must be in the root directory itself...or just the
> odbc file that points to the .db file? I deployed the
> sample ASA db to the emulator, but I do not see any type
> of odbc.ini file in any of the directories.
>
> With your reference to FILEDSN (which I could find no help
> on in the PocketPB help), would my sample profile change:
>
> Example:
>
> // Profile MYTESTDB
> SQLCA.DBMS = "ODBC"
> SQLCA.AutoCommit = False
> SQLCA.DBParm = "ConnectString='DSN=MYTESTDB;UID=myuser
> ;PWD=mypass'"
>
> Becomes...
>
> // Profile MYTESTDB
> SQLCA.DBMS = "ODBC"
> SQLCA.AutoCommit = False
> SQLCA.DBParm = "ConnectString='FILEDSN=MYTESTDB;UID=myuser
> ;PWD=mypass'"
>
> Thanks for the help. Yes, PocketPB looks to be ideal for
> development (especially if already aware of the power of
> datawindows and NVOs).
>
> Brian
>
>
> <dw-extreme> wrote in message
> news:3f5554cc.64b3.846930886@sybase.com... That is
> precisely the problem I encountered with the
> documentation. You want a top down solution and the
> documentation is object oriented.
>
> To do x you must set up y go to the y setup page
> To set up y requires process b go to that page
> To set up process b go the the chapter on processes page
> 34 processes require ____ on this document
> goto top replace x with a and start over
>
> Seriously
>
> You need to make sure you have a file dsn set up on your
> device. Create the file on your workstation and move it
> to the device. The dsn file needs to be located on the
> root directory (so I read). Make sure before you do your
> connect that you use FILEDSN= and not DSN= in your
> connectstring.
>
> Once its set up it works great, I am really impressed with
> PPB and all the goodies that are added.
>
> Hope this helps.
>
> dwx
>
> > I am looking for a simple set of instructions that takes
> > me "from cradle to grave" when deploying a PocketPB app
> > to the PocketPC 2002 emulator. Here is what I've done:
> >
> > 1. Deployed the PocketPB x86 CAB file to the emulator
> > successfully 2. Deployed the ASA8 x86 CAB file to the
> > emulator successfully 3. Deployed the PocketPB app
> > successfully
> >
> > Here is what I am looking for...
> >
> > I seem to be missing the steps in the ASA db deployment
> > (I'm not even at the point where I can start talking
> > synchronization). I have a central ASA database that is
> > currently about 8MB...but I want a subset of tables (and
> > table data) to make it to the pocketPC. Therefore, I
> > went ahead and created another blank ASA database. I
> > can use the Windows CE File Viewer to copy this blank
> > database over to the pocketPC, but how do I setup the
> > typical ODBC profile to connect to it? In fact, I am
> > having to use the Windows CE File Viewer because I am
> > developing on a laptop...which doesn't have two COM
> > ports (therefore, I cannot setup an ActiveSync
> partnership to the emulator). >
> > I've tried to wade through the iAnywhere help file, but
> > I can't seem to find a nice example of how to deploy an
> > ASA database with subsets of tables and data. I am not
> > cross-posting to the iAnywhere site because I would like
> > someone with a PocketPB hat to answer the question.
> >
> > I would like to get to the point where I have this
> > remote db with just a few records, so I can confirm that
> > my PocketPB app is working fine. Then, I can start
> > researching how to setup the synchronization scripts.
> >
> > As an aside, I did try to execute the application, and
> > it came up with a dialog to select the datasource. I
> > selected the db filename, and it forced the emulator to
> > restart. When it came back up, I had lost all of the
> > work established in the three steps above (deploying
> > using CAB files). I had ensured that I had exited the
> > emulator gracefully...a number of times...saving the
> > state each time. I would have thought that would have
> > protected me...did the emulator somehow go back to
> factory settings? >
> > Thanks for the help.
> >
> > Brian
> >
> >
>
>