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.

UltraLite DB from existing ASA DB on WinMO 6.5

15 posts in Ultralite Last posting was on 2012-06-22 06:17:19.0Z
Ryan VanAlstine Posted on 2012-03-16 05:26:06.0Z
Sender: 5071.4f62ce2b.1804289383@sybase.com
From: Ryan VanAlstine
Newsgroups: sybase.public.sqlanywhere.ultralite
Subject: UltraLite DB from existing ASA DB on WinMO 6.5
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f62ceee.5098.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 15 Mar 2012 21:26:06 -0800
X-Trace: forums-1-dub 1331875566 172.20.134.41 (15 Mar 2012 21:26:06 -0800)
X-Original-Trace: 15 Mar 2012 21:26:06 -0800, 172.20.134.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12695
Article PK: 1048484

Hello,
I am working to port an existing Windows Mobile 6.5
application to the iPhone. The WinMo app has an existing
ASA database that I would like to port to UltraLite so I can
use it in the project. I believe that once I have the base
db working I can sync it with the servers.

Is this possible?

Thanks,
Ryan


Jeff Albion [Sybase iAnywhere] Posted on 2012-03-16 20:55:58.0Z
From: "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@sybase.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere.ultralite
Subject: Re: UltraLite DB from existing ASA DB on WinMO 6.5
References: <4f62ceee.5098.1681692777@sybase.com>
In-Reply-To: <4f62ceee.5098.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f63a8de$1@forums-1-dub>
Date: 16 Mar 2012 12:55:58 -0800
X-Trace: forums-1-dub 1331931358 10.22.241.152 (16 Mar 2012 12:55:58 -0800)
X-Original-Trace: 16 Mar 2012 12:55:58 -0800, vip152.sybase.com
Lines: 41
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12697
Article PK: 1048483

Hi Ryan,

On 16/03/2012 1:26 AM, Ryan VanAlstine wrote:
> Hello,
> I am working to port an existing Windows Mobile 6.5
> application to the iPhone. The WinMo app has an existing
> ASA database that I would like to port to UltraLite so I can
> use it in the project. I believe that once I have the base
> db working I can sync it with the servers.
>
> Is this possible?

This is "possible", but aside from the database schema in SQL Anywhere,
there unfortunately won't be very many parts that will be transferable
from your original project.

To transfer the schema to UltraLite from SQL Anywhere, see "ulinit -a":
http://dcx.sybase.com/index.html#1201/en/uladmin/ulinit-ulcs-utilities.html

The rest of the conversion will be moving from the Windows Mobile
ESQL/ODBC/CF.NET project to Objective-C and converting your SQL Anywhere
calls into UltraLite-compatible calls.

You should keep in mind that UltraLite has more restrictions on its use
than SQL Anywhere does:

http://dcx.sybase.com/index.html#1201/en/uladmin/fo-intro-s-5247753.html

Regards,

--
Jeff Albion, Sybase iAnywhere, an SAP Company

SQL Anywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
SQL Anywhere Documentation : http://dcx.sybase.com/
Archived SQL Anywhere Documentation :
http://manuals.sybase.com/onlinebooks/group-sas/
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/


Ryan VanAlstine Posted on 2012-03-20 05:39:59.0Z
Sender: 7236.4f68177f.1804289383@sybase.com
From: Ryan VanAlstine
Newsgroups: sybase.public.sqlanywhere.ultralite
Subject: Re: UltraLite DB from existing ASA DB on WinMO 6.5
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f68182f.726c.1681692777@sybase.com>
References: <4f63a8de$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 19 Mar 2012 21:39:59 -0800
X-Trace: forums-1-dub 1332221999 172.20.134.41 (19 Mar 2012 21:39:59 -0800)
X-Original-Trace: 19 Mar 2012 21:39:59 -0800, 172.20.134.41
Lines: 56
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12700
Article PK: 1048487


> Hi Ryan,
>
> On 16/03/2012 1:26 AM, Ryan VanAlstine wrote:
> > Hello,
> > I am working to port an existing Windows Mobile 6.5
> > application to the iPhone. The WinMo app has an
> > existing ASA database that I would like to port to
> > UltraLite so I can use it in the project. I believe
> > that once I have the base db working I can sync it with
> the servers. >
> > Is this possible?
>
> This is "possible", but aside from the database schema in
> SQL Anywhere, there unfortunately won't be very many
> parts that will be transferable from your original
> project.
>
> To transfer the schema to UltraLite from SQL Anywhere, see
> "ulinit -a":
>
http://dcx.sybase.com/index.html#1201/en/uladmin/ulinit-ulcs-utilities.html
>
> The rest of the conversion will be moving from the Windows
> Mobile ESQL/ODBC/CF.NET project to Objective-C and
> converting your SQL Anywhere calls into
> UltraLite-compatible calls.
>
> You should keep in mind that UltraLite has more
> restrictions on its use than SQL Anywhere does:
>
>
http://dcx.sybase.com/index.html#1201/en/uladmin/fo-intro-s-5247753.html
>
> Regards,
>
> --
> Jeff Albion, Sybase iAnywhere, an SAP Company
>
> SQL Anywhere Developer Community :
>
http://www.sybase.com/developer/library/sql-anywhere-techcorner
> SQL Anywhere Documentation : http://dcx.sybase.com/
> Archived SQL Anywhere Documentation :
> http://manuals.sybase.com/onlinebooks/group-sas/
> SQL Anywhere Patches and EBFs :
>
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
> Report a Bug/Open a Case :
> http://case-express.sybase.com/cx/

Hi Jeff,
Thanks for the response and the pointers on how to do this.
Fortunately, all I need is the database schema so I will try
it out. Thanks again.

Ryan


Ryan VanAlstine Posted on 2012-04-24 05:44:40.0Z
Sender: 161f.4f963bf5.1804289383@sybase.com
From: Ryan VanAlstine
Newsgroups: sybase.public.sqlanywhere.ultralite
Subject: Re: UltraLite DB from existing ASA DB on WinMO 6.5
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f963dc8.163e.1681692777@sybase.com>
References: <4f68182f.726c.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 23 Apr 2012 22:44:40 -0700
X-Trace: forums-1-dub 1335246280 172.20.134.41 (23 Apr 2012 22:44:40 -0700)
X-Original-Trace: 23 Apr 2012 22:44:40 -0700, 172.20.134.41
Lines: 70
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12713
Article PK: 1048543


> > Hi Ryan,
> >
> > On 16/03/2012 1:26 AM, Ryan VanAlstine wrote:
> > > Hello,
> > > I am working to port an existing Windows Mobile 6.5
> > > application to the iPhone. The WinMo app has an
> > > existing ASA database that I would like to port to
> > > UltraLite so I can use it in the project. I believe
> > > that once I have the base db working I can sync it
> > with the servers. >
> > > Is this possible?
> >
> > This is "possible", but aside from the database schema
> > in SQL Anywhere, there unfortunately won't be very many
> > parts that will be transferable from your original
> > project.
> >
> > To transfer the schema to UltraLite from SQL Anywhere,
> > see "ulinit -a":
> >
>
http://dcx.sybase.com/index.html#1201/en/uladmin/ulinit-ulcs-utilities.html
> >
> > The rest of the conversion will be moving from the
> > Windows Mobile ESQL/ODBC/CF.NET project to Objective-C
> > and converting your SQL Anywhere calls into
> > UltraLite-compatible calls.
> >
> > You should keep in mind that UltraLite has more
> > restrictions on its use than SQL Anywhere does:
> >
> >
>
http://dcx.sybase.com/index.html#1201/en/uladmin/fo-intro-s-5247753.html
> >
> > Regards,
> >
> > --
> > Jeff Albion, Sybase iAnywhere, an SAP Company
> >
> > SQL Anywhere Developer Community :
> >
>
http://www.sybase.com/developer/library/sql-anywhere-techcorner
> > SQL Anywhere Documentation : http://dcx.sybase.com/
> > Archived SQL Anywhere Documentation :
> > http://manuals.sybase.com/onlinebooks/group-sas/
> > SQL Anywhere Patches and EBFs :
> >
>
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
> > Report a Bug/Open a Case :
> > http://case-express.sybase.com/cx/
>
> Hi Jeff,
> Thanks for the response and the pointers on how to do
> this. Fortunately, all I need is the database schema so I
> will try it out. Thanks again.
>
> Ryan

Hi Jeff,
I have built out the rest of the app and I now have to get
the db ported over. The issue that I am running into is
that the DB was created with SQL Anywhere v9 which appears
to be EOL'ed. So, when I try to connect to it I get an
error that says it was created with an older version. Is
there anyway around this?
Thanks again for all the help.
Ryan


Jeff Albion [Sybase iAnywhere] Posted on 2012-04-24 16:15:46.0Z
From: "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@sybase.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:11.0) Gecko/20120327 Thunderbird/11.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere.ultralite
Subject: Re: UltraLite DB from existing ASA DB on WinMO 6.5
References: <4f68182f.726c.1681692777@sybase.com> <4f963dc8.163e.1681692777@sybase.com>
In-Reply-To: <4f963dc8.163e.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f96d1b2$1@forums-1-dub>
Date: 24 Apr 2012 09:15:46 -0700
X-Trace: forums-1-dub 1335284146 10.22.241.152 (24 Apr 2012 09:15:46 -0700)
X-Original-Trace: 24 Apr 2012 09:15:46 -0700, vip152.sybase.com
Lines: 26
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12714
Article PK: 1048520

Hi Ryan,

On 24/04/2012 1:44 AM, Ryan VanAlstine wrote:
> So, when I try to connect to it I get an
> error that says it was created with an older version. Is
> there anyway around this?

Yes, if you want to run the older 9.0 database on newer software (10.0
and up), it must be rebuilt (unloaded and reloaded) first. The
documentation describes the procedure on how to do this:

http://dcx.sybase.com/index.html#1201/en/sachanges/unloading-reloading-upgrading-newjasper.html

Regards,

--
Jeff Albion, Sybase iAnywhere, an SAP Company

SQL Anywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
SQL Anywhere Documentation : http://dcx.sybase.com/
Archived SQL Anywhere Documentation :
http://manuals.sybase.com/onlinebooks/group-sas/
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/


Ryan VanAlstine Posted on 2012-05-17 04:14:20.0Z
Sender: 46a0.4fb461ef.1804289383@sybase.com
From: Ryan VanAlstine
Newsgroups: sybase.public.sqlanywhere.ultralite
Subject: Re: UltraLite DB from existing ASA DB on WinMO 6.5
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fb47b1c.4a20.1681692777@sybase.com>
References: <4f96d1b2$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 16 May 2012 21:14:20 -0700
X-Trace: forums-1-dub 1337228060 172.20.134.41 (16 May 2012 21:14:20 -0700)
X-Original-Trace: 16 May 2012 21:14:20 -0700, 172.20.134.41
Lines: 59
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12726
Article PK: 1048534

Hi Jeff,
Thanks for the help. I am able to connect to the database
from within my iPhone app now. This leads me to the next
section to tackle.

The database that I converted is simply the tables and not
the data. When I run the app for the first time, I have to
do a sync before I can see any of the data.
I wanted to run my understanding of how to do this by you to
make sure I'm heading the right direction.

The current product uses WinMo and does a network call to
start. The response is a set of XML that includes the
Upload Dll (iAnywhere.Data.AsaClient.dll) , the connect
class (iAnywhere.Data.AsaClient.AsaConnection) and the local
database server executable with some options (dbsrv9.exe -gd
all -qi -c 8M -x)
After that, there is some credentials/info about the server
and then a bunch of SQL commands.

So, in order to get this infrastructure to work with my
UltraLite DB, do we need to set up MobiLink to go in between
the current server and the iPhone app so that I can sync all
the data?

Thanks,
Ryan

> Hi Ryan,
>
> On 24/04/2012 1:44 AM, Ryan VanAlstine wrote:
> > So, when I try to connect to it I get an
> > error that says it was created with an older version.
> > Is there anyway around this?
>
> Yes, if you want to run the older 9.0 database on newer
> software (10.0 and up), it must be rebuilt (unloaded and
> reloaded) first. The documentation describes the
> procedure on how to do this:
>
>
http://dcx.sybase.com/index.html#1201/en/sachanges/unloading-reloading-upgrading-newjasper.html
>
> Regards,
>
> --
> Jeff Albion, Sybase iAnywhere, an SAP Company
>
> SQL Anywhere Developer Community :
>
http://www.sybase.com/developer/library/sql-anywhere-techcorner
> SQL Anywhere Documentation : http://dcx.sybase.com/
> Archived SQL Anywhere Documentation :
> http://manuals.sybase.com/onlinebooks/group-sas/
> SQL Anywhere Patches and EBFs :
>
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
> Report a Bug/Open a Case :
> http://case-express.sybase.com/cx/


Jeff Albion [Sybase iAnywhere] Posted on 2012-05-17 20:08:58.0Z
From: "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@sybase.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere.ultralite
Subject: Re: UltraLite DB from existing ASA DB on WinMO 6.5
References: <4f96d1b2$1@forums-1-dub> <4fb47b1c.4a20.1681692777@sybase.com>
In-Reply-To: <4fb47b1c.4a20.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4fb55ada$1@forums-1-dub>
Date: 17 May 2012 13:08:58 -0700
X-Trace: forums-1-dub 1337285338 10.22.241.152 (17 May 2012 13:08:58 -0700)
X-Original-Trace: 17 May 2012 13:08:58 -0700, vip152.sybase.com
Lines: 56
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12727
Article PK: 1048565

Hi Ryan,

On 17/05/2012 12:14 AM, Ryan VanAlstine wrote:
> The current product uses WinMo and does a network call to
> start. The response is a set of XML that includes the
> Upload Dll (iAnywhere.Data.AsaClient.dll) , the connect
> class (iAnywhere.Data.AsaClient.AsaConnection) and the local
> database server executable with some options (dbsrv9.exe -gd
> all -qi -c 8M -x)
> After that, there is some credentials/info about the server
> and then a bunch of SQL commands.

I am going to summarize the above as:

"We deploy a stand-alone SQL Anywhere server to the WM device and
connect to it in CF.NET locally using iAnywhere.Data.AsaClient"

Is that correct?

> So, in order to get this infrastructure to work with my
> UltraLite DB, do we need to set up MobiLink to go in between
> the current server and the iPhone app so that I can sync all
> the data?

I am also going to assume you've never synchronized the aforementioned
Windows Mobile SQL Anywhere database before using MobiLink?

---

Once you have an UltraLite database designed and deployed on the device,
you're going to want to set up a MobiLink server to your consolidated
database and program the UltraLite device to perform synchronizations
from your Objective-C code.

See "Lesson 6: Adding Synchronization" in the UltraLite iPhone tutorial:

http://dcx.sybase.com/index.html#1201/en/ulc/ulc-add-synch.html

You may also want to review the MobiLink documentation if you're not
familiar with the technology:

http://dcx.sybase.com/index.html#1201/en/mlstart/ml-basics.html

Regards,

--
Jeff Albion, Sybase iAnywhere, an SAP Company

SQL Anywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
SQL Anywhere Documentation : http://dcx.sybase.com/
Archived SQL Anywhere Documentation :
http://manuals.sybase.com/onlinebooks/group-sas/
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/


Jeff Albion [Sybase iAnywhere] Posted on 2012-06-07 15:25:40.0Z
From: "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@sybase.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere.ultralite
Subject: Re: UltraLite DB from existing ASA DB on WinMO 6.5
References: <4fb55ada$1@forums-1-dub> <4fd05072.784f.1681692777@sybase.com>
In-Reply-To: <4fd05072.784f.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4fd0c7f4$1@forums-1-dub>
Date: 7 Jun 2012 08:25:40 -0700
X-Trace: forums-1-dub 1339082740 10.22.241.152 (7 Jun 2012 08:25:40 -0700)
X-Original-Trace: 7 Jun 2012 08:25:40 -0700, vip152.sybase.com
Lines: 49
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12729
Article PK: 1048717

Hi Ryan,

That's great - glad to hear that you're making some progress!

On 07/06/2012 2:55 AM, Ryan VanAlstine wrote:
> result that I am trying to select. For instance, when I
> select a couple of columns from a table, I would like to be
> able to check the type of one of the columns, save it, and
> move onto the next column. I'm thinking that I need to use
> the ULResultSetSchema class but I'm a bit unclear on how to
> do that.

Yep, you're definitely in the correct area with your searches. There is
a brief section in the documentation that closely describes what you're
trying to do, with a very brief code snippet:

http://dcx.sybase.com/index.html#1201/en/ulc/schema-af-development.html

=====================================================================
// This code demonstrates proper use of the ULResultSetSchema class:
const ULResultSetSchema & rss = prepStmt->GetResultSetSchema();
ccount = prepStmt->GetSchema().GetColumnCount();

// This code demonstrates proper use of the ULDatabaseSchema class:
ULDatabaseSchema * dbs = conn->GetResultSetSchema();
tcount = dbs->GetTableCount();
dbs->Close(); // This line is required.

// This code demonstrates improper use of the ULDatabaseSchema class
// because the object needs to be closed using the Close method:
tcount = conn->GetResultSetSchema()->GetTableCount();
=====================================================================

Are you trying to get the schema of a ULPreparedStatement, ULResultSet
or a ULTable?

Regards,

--
Jeff Albion, Sybase iAnywhere, an SAP Company

SQL Anywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
SQL Anywhere Documentation : http://dcx.sybase.com/
Archived SQL Anywhere Documentation :
http://manuals.sybase.com/onlinebooks/group-sas/
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/