Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Database Connection problem

11 views
Skip to first unread message

Jeff

unread,
May 1, 2010, 3:50:45 AM5/1/10
to
Hi guys, I know this is old news but it seems the posts are quite old
and may not cater to me. I'm currently using PocketPB 2.5 build 1273,
and sql anywhere 11.0.1 build 2331. and the same old problem is still
there.

My unit is a samsung omnia II running winmo 6.5, I know that its a
little beyond what pocketPB 2.5 has specified but I am still trying to
see if this is the problem. Just the the rest, my application does
complain that "dbms odbc is not supported in your current
installation" Just like the rest of the posts. Looking at the older
posts though, I noticed they failed to give a small information. What
I observed is that, installation "may not" be the problem. I think
this is so, because all of the sample application that gets installed
along with ASA11 actually runs! that is what I don't understand, they
have the esql program, the ADO.NET, and even an ODBC sample, and
everything runs just fine, So I believe that this is not an OS issue
or an installation problem.

Any help would be appreciated

TIA,
Jeff

Mike T

unread,
May 2, 2010, 12:58:30 PM5/2/10
to
Hi Jeff,
You have to use an ultralite DB,

This code can be used. One is for the descktop testing, The other for
the application.

SQLCA.DBMS = "UL10"
SQLCA.AutoCommit = False

GetEnvironment(g_Env)

// let's select between the two supported styles
IF g_Env.ostype = WindowsNT! THEN
SQLCA.DBParm = "ConnectString='DBF=c:\sybase\pocketbuilder
\SalesDB.udb;UID=;PWD='"
else
SQLCA.DBParm = "ConnectString='DBF=\Program Files
\SalesDB.udb;UID=;PWD='"
end if

Jeff

unread,
May 3, 2010, 1:25:40 AM5/3/10
to
Hi Mike,

I am currently using ASA9, which comes with Ultralite 9, I did try
using Ultralite 9 but I still get the same error.

Jeff

unread,
May 3, 2010, 1:28:09 AM5/3/10
to
I forgot to mention, if I do tests on my desktop, everything works,
its only when I try running it on my mobile. Hoping you'd find this
clue useful

Mike T

unread,
May 8, 2010, 2:53:31 PM5/8/10
to
Jeff,

As I recall the Pocketbuilder documentation refers to UL09.

If it works on the desktop is should work on the PPC. but the folder
definition will be different as is the case in my example.

Mike

> > > > Jeff- Hide quoted text -
>
> - Show quoted text -

0 new messages