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.

Application on a stick

6 posts in Commercial ISV's Last posting was on 2008-06-20 14:12:54.0Z
Ken Judkins Posted on 2008-06-04 14:24:47.0Z
From: "Ken Judkins" <nospam@nospam.com>
Newsgroups: sybase.public.commercial-isv.general
Subject: Application on a stick
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4846a5af@forums-1-dub>
Date: 4 Jun 2008 07:24:47 -0700
X-Trace: forums-1-dub 1212589487 10.22.241.152 (4 Jun 2008 07:24:47 -0700)
X-Original-Trace: 4 Jun 2008 07:24:47 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:124
Article PK: 103842

A thought passed through my head, and I figured I'd gather some input from
those more experienced than I.

If I wrote an application (PB9/PFC/ASA) that is designed to be installed on
a USB memory stick, what are some things I would need to consider?

Copy Protection? How do I protect an application that by definition is
meant to be portable? Do USB sticks have unique IDs that remain the same
from PC to PC?

ODBC Database Settings? Will I be leaving an ODBC residue on every PC that
has run my application? Must I manually wipe it when the application
closes?

How to handle the database transactions so if the user pulls the stick
without disconnecting I don't lose data?

Other considerations?


M. Searer Posted on 2008-06-09 17:19:09.0Z
From: "M. Searer" <nospam@nospam.com>
Newsgroups: sybase.public.commercial-isv.general
References: <4846a5af@forums-1-dub>
In-Reply-To: <4846a5af@forums-1-dub>
Subject: Re: Application on a stick
Lines: 47
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18000
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <484d660d$1@forums-1-dub>
Date: 9 Jun 2008 10:19:09 -0700
X-Trace: forums-1-dub 1213031949 10.22.241.152 (9 Jun 2008 10:19:09 -0700)
X-Original-Trace: 9 Jun 2008 10:19:09 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:125
Article PK: 103843

Copy - are you preventing it from being copied from the memory stick, or
from being used on an unlicensed computer?
Are you trying to prevent the same company from using your app over and over
again, or from a different company?


ODBC - I'm not sure, but I would assume that ASA would have to have parts of
it registered on the computer in order to run?
I would think that as long as the database client dlls are in the same
directory as the rest of the app, you won't have anything to worry about.
IF you are talking about dsn file etc.; you don't need to use that. Just
setup the connection settings in your code (since the db is on your 'stick',
I would assume you could hard code everything?)

stick pull - if the database is on the stick, I think database corruption
would be the bigger concern.
Database transactions will be rolled back automatically by the database if
the database connection is lost (sql any does this)

"Ken Judkins" <nospam@nospam.com> wrote in message
news:4846a5af@forums-1-dub...
>A thought passed through my head, and I figured I'd gather some input from
>those more experienced than I.
>
> If I wrote an application (PB9/PFC/ASA) that is designed to be installed
> on a USB memory stick, what are some things I would need to consider?
>
> Copy Protection? How do I protect an application that by definition is
> meant to be portable? Do USB sticks have unique IDs that remain the same
> from PC to PC?
>
> ODBC Database Settings? Will I be leaving an ODBC residue on every PC
> that has run my application? Must I manually wipe it when the application
> closes?
>
> How to handle the database transactions so if the user pulls the stick
> without disconnecting I don't lose data?
>
> Other considerations?
>
>
>
>
>
>


M. Searer Posted on 2008-06-09 17:30:50.0Z
From: "M. Searer" <nospam@nospam.com>
Newsgroups: sybase.public.commercial-isv.general
References: <4846a5af@forums-1-dub> <484d660d$1@forums-1-dub>
In-Reply-To: <484d660d$1@forums-1-dub>
Subject: Re: Application on a stick
Lines: 55
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18000
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <484d68ca$1@forums-1-dub>
Date: 9 Jun 2008 10:30:50 -0700
X-Trace: forums-1-dub 1213032650 10.22.241.152 (9 Jun 2008 10:30:50 -0700)
X-Original-Trace: 9 Jun 2008 10:30:50 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:126
Article PK: 103844

you might want to look at:
http://www.vilabs.com
for copy protection .

"M. Searer" <nospam@nospam.com> wrote in message
news:484d660d$1@forums-1-dub...
> Copy - are you preventing it from being copied from the memory stick, or
> from being used on an unlicensed computer?
> Are you trying to prevent the same company from using your app over and
> over again, or from a different company?
>
>
> ODBC - I'm not sure, but I would assume that ASA would have to have parts
> of it registered on the computer in order to run?
> I would think that as long as the database client dlls are in the same
> directory as the rest of the app, you won't have anything to worry about.
> IF you are talking about dsn file etc.; you don't need to use that. Just
> setup the connection settings in your code (since the db is on your
> 'stick', I would assume you could hard code everything?)
>
> stick pull - if the database is on the stick, I think database corruption
> would be the bigger concern.
> Database transactions will be rolled back automatically by the database if
> the database connection is lost (sql any does this)
>
>
> "Ken Judkins" <nospam@nospam.com> wrote in message
> news:4846a5af@forums-1-dub...
>>A thought passed through my head, and I figured I'd gather some input from
>>those more experienced than I.
>>
>> If I wrote an application (PB9/PFC/ASA) that is designed to be installed
>> on a USB memory stick, what are some things I would need to consider?
>>
>> Copy Protection? How do I protect an application that by definition is
>> meant to be portable? Do USB sticks have unique IDs that remain the same
>> from PC to PC?
>>
>> ODBC Database Settings? Will I be leaving an ODBC residue on every PC
>> that has run my application? Must I manually wipe it when the
>> application closes?
>>
>> How to handle the database transactions so if the user pulls the stick
>> without disconnecting I don't lose data?
>>
>> Other considerations?
>>
>>
>>
>>
>>
>>
>


Ken Judkins Posted on 2008-06-20 14:12:54.0Z
From: "Ken Judkins" <nospam@nospam.com>
Newsgroups: sybase.public.commercial-isv.general
References: <4846a5af@forums-1-dub> <484d660d$1@forums-1-dub> <484d68ca$1@forums-1-dub>
Subject: Re: Application on a stick
Lines: 75
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <485bbae6$1@forums-1-dub>
Date: 20 Jun 2008 07:12:54 -0700
X-Trace: forums-1-dub 1213971174 10.22.241.152 (20 Jun 2008 07:12:54 -0700)
X-Original-Trace: 20 Jun 2008 07:12:54 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:129
Article PK: 103846

Sounds like the ODBC registration will be a given, if I use the runtime
database. I can live with that. I'm more concerned with protecting the
application than leaving traces of it.

I think I would want it to be licensed to the stick. The person could go to
any PC and their work would go with them. It would be a custom application,
with its own database, that I would not want to have to install on any PC.
The user would need to run the application on a PC not necessarily connected
to the Internet. I wouldn't want the application to be copied and used on
the PC or another memory stick. Moved is OK, copied is not.

I'll check out this site over the weekend. Thanks!

Ken

"M. Searer" <nospam@nospam.com> wrote in message
news:484d68ca$1@forums-1-dub...
> you might want to look at:
> http://www.vilabs.com
> for copy protection .
>
>
> "M. Searer" <nospam@nospam.com> wrote in message
> news:484d660d$1@forums-1-dub...
>> Copy - are you preventing it from being copied from the memory stick, or
>> from being used on an unlicensed computer?
>> Are you trying to prevent the same company from using your app over and
>> over again, or from a different company?
>>
>>
>> ODBC - I'm not sure, but I would assume that ASA would have to have parts
>> of it registered on the computer in order to run?
>> I would think that as long as the database client dlls are in the same
>> directory as the rest of the app, you won't have anything to worry about.
>> IF you are talking about dsn file etc.; you don't need to use that. Just
>> setup the connection settings in your code (since the db is on your
>> 'stick', I would assume you could hard code everything?)
>>
>> stick pull - if the database is on the stick, I think database corruption
>> would be the bigger concern.
>> Database transactions will be rolled back automatically by the database
>> if the database connection is lost (sql any does this)
>>
>>
>> "Ken Judkins" <nospam@nospam.com> wrote in message
>> news:4846a5af@forums-1-dub...
>>>A thought passed through my head, and I figured I'd gather some input
>>>from those more experienced than I.
>>>
>>> If I wrote an application (PB9/PFC/ASA) that is designed to be installed
>>> on a USB memory stick, what are some things I would need to consider?
>>>
>>> Copy Protection? How do I protect an application that by definition is
>>> meant to be portable? Do USB sticks have unique IDs that remain the
>>> same from PC to PC?
>>>
>>> ODBC Database Settings? Will I be leaving an ODBC residue on every PC
>>> that has run my application? Must I manually wipe it when the
>>> application closes?
>>>
>>> How to handle the database transactions so if the user pulls the stick
>>> without disconnecting I don't lose data?
>>>
>>> Other considerations?
>>>
>>>
>>>
>>>
>>>
>>>
>>
>


"Reed Shilts [Sybase]" Posted on 2008-06-09 19:15:38.0Z
From: "Reed Shilts [Sybase]" <reed dot shilts at sybase dot com>
Newsgroups: sybase.public.commercial-isv.general
Subject: Re: Application on a stick
Message-ID: <360r44p39oavn6g6so4uouktei6vaqdab5@4ax.com>
References: <4846a5af@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: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 9 Jun 2008 12:15:38 -0700
X-Trace: forums-1-dub 1213038938 10.22.241.152 (9 Jun 2008 12:15:38 -0700)
X-Original-Trace: 9 Jun 2008 12:15:38 -0700, vip152.sybase.com
Lines: 29
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:127
Article PK: 103845

For the database aspect - I'd look into using UltraLite from
iAnywhere. From PowerBuilder this looks like any other
ODBC style data source, however this has no need for
any ODBC manager or other "residue".

Basically the DBParm points to the UDB file - and that's it...

About the transactions - maybe the iAnywhere folks have addressed
that. On the PocketPC they listen for the various device and power
notifications to know when to do "stuff" - whether it's what you
want is outside what I know...

HTH,
Reed Shilts
<Standard-Disclaimers-Apply/>



On 4 Jun 2008 07:24:47 -0700, "Ken Judkins" <nospam@nospam.com> wrote:

>ODBC Database Settings? Will I be leaving an ODBC residue on every PC that
>has run my application? Must I manually wipe it when the application
>closes?
>
>How to handle the database transactions so if the user pulls the stick
>without disconnecting I don't lose data?
>


Jason Hinsperger Posted on 2008-06-10 13:12:09.0Z
From: "Jason Hinsperger" <NO_jason_hinsperger_SPAM@hotmail.com>
Newsgroups: sybase.public.commercial-isv.general
References: <4846a5af@forums-1-dub>
Subject: Re: Application on a stick
Lines: 50
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <484e7da9$1@forums-1-dub>
Date: 10 Jun 2008 06:12:09 -0700
X-Trace: forums-1-dub 1213103529 10.22.241.152 (10 Jun 2008 06:12:09 -0700)
X-Original-Trace: 10 Jun 2008 06:12:09 -0700, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:128
Article PK: 103849

With SQL Anywhere, the database server can recover from pulling the drive,
so you shouldn't have any problems there.
As far as ODBC goes, you can make a connection without using a DSN (you must
specify the DRIVER parameter in your DBParm). You can also talk directly to
the ODBC driver without having to register the driver on the machine, but I
don't think you can do this with PowerBuilder.
I think you need to have the odbc driver registered on the machine in order
to use it with PB. This would involve running "regsvr32 dbodbc10.dll"
before the app runs, and running "regsvr32 -u dbodbc10.dll" after the app
finishes.
If your app. did not shut down cleanly you would basically leave the 2
registry entries referring to the ODBC driver hanging around.

--
Jason Hinsperger
Product Manager
Sybase iAnywhere

SQL Anywhere Developer Community
http://www.ianywhere.com/developer

"Ken Judkins" <nospam@nospam.com> wrote in message
news:4846a5af@forums-1-dub...
>A thought passed through my head, and I figured I'd gather some input from
>those more experienced than I.
>
> If I wrote an application (PB9/PFC/ASA) that is designed to be installed
> on a USB memory stick, what are some things I would need to consider?
>
> Copy Protection? How do I protect an application that by definition is
> meant to be portable? Do USB sticks have unique IDs that remain the same
> from PC to PC?
>
> ODBC Database Settings? Will I be leaving an ODBC residue on every PC
> that has run my application? Must I manually wipe it when the application
> closes?
>
> How to handle the database transactions so if the user pulls the stick
> without disconnecting I don't lose data?
>
> Other considerations?
>
>
>
>
>
>