| Author |
palm expansion card
|
|
| Brent Williams 2005-07-27, 11:24 am |
| I'm running version 9.0.2.3044
I'm having trouble creating my ultralite database on a palm expansion
card so I have some questions.
1. Does it matter where the application goes (.prc)?
2. Does it matter where the schema file goes?
Here is what I'm currently doing that doesn't seem to work. I get the
volume number for the card. I call ULEnableFileDB() (fyi, and
ULEnableStrongEncryp
tion) and ULInitDatabaseManage
r. Then I call
DatabaseManager-> CreateAndOpenDatabas
e(TheSqlca, connParms). My
connection parms look like:
UID=DBA;PWD=SQL;palm
_schema=ERxDBusm;DBK
EY=password;palm_db=
ERxu:2
This returns a null connection and the sql code is -82 (Unable to start
specified database).
Any ideas what I am doing wrong?
Thanks
| |
| Michael Thode 2005-07-27, 1:24 pm |
| 1. The application can go on the card, but that is not recommened. It will
run slower that way as it needs to copy the application into memory.
2. The schema file must be on the device.
Does this connection string work?
UID=DBA;PWD=SQL;palm
_schema=ERxDBusm;DBK
EY=password;palm_db=
ERxu:0 and
call ULEnablePalmRecordDB
()
This builds the udb on device. This will show if its the expansion is the
issue or not.
Are you using the simulator or a real device? Have you tried both?
Mike
"Brent Williams" < brentwilliams@bcbsal
.org> wrote in message
news:42e7a345$1@foru
ms-1-dub...
> I'm running version 9.0.2.3044
>
> I'm having trouble creating my ultralite database on a palm expansion
> card so I have some questions.
>
> 1. Does it matter where the application goes (.prc)?
> 2. Does it matter where the schema file goes?
>
> Here is what I'm currently doing that doesn't seem to work. I get the
> volume number for the card. I call ULEnableFileDB() (fyi, and
> ULEnableStrongEncryp
tion) and ULInitDatabaseManage
r. Then I call
> DatabaseManager-> CreateAndOpenDatabas
e(TheSqlca, connParms). My
> connection parms look like:
> UID=DBA;PWD=SQL;palm
_schema=ERxDBusm;DBK
EY=password;palm_db=
ERxu:2
>
> This returns a null connection and the sql code is -82 (Unable to start
> specified database).
>
> Any ideas what I am doing wrong?
>
> Thanks
| |
| Brent Williams 2005-08-17, 8:23 pm |
| I tried the connection string like you suggested with the hard coded 0
on the end and that works but I can't get it to work with the internal
card on the simulator or a real card on a device. Any other suggestions?
Michael Thode wrote:
> 1. The application can go on the card, but that is not recommened. It will
> run slower that way as it needs to copy the application into memory.
>
> 2. The schema file must be on the device.
>
> Does this connection string work?
> UID=DBA;PWD=SQL;palm
_schema=ERxDBusm;DBK
EY=password;palm_db=
ERxu:0 and
> call ULEnablePalmRecordDB
()
>
> This builds the udb on device. This will show if its the expansion is the
> issue or not.
>
> Are you using the simulator or a real device? Have you tried both?
>
> Mike
>
> "Brent Williams" < brentwilliams@bcbsal
.org> wrote in message
> news:42e7a345$1@foru
ms-1-dub...
>
>
>
>
| |
| Michael Thode 2005-08-18, 8:23 pm |
| Are you still seeing the same -82 sql error?
Just to be clear...If you use your original command line
UID=DBA;PWD=SQL;palm
_schema=ERxDBusm;DBK
EY=password;palm_db=
ERxu:2
and put the the schema file in the same spot you did in the example I asked
you to try then it still doesn't work?
Mike
"Brent Williams" < brentwilliams@bcbsal
.org> wrote in message
news:4303aefc$1@foru
ms-2-dub...[color=darkred]
> I tried the connection string like you suggested with the hard coded 0
> on the end and that works but I can't get it to work with the internal
> card on the simulator or a real card on a device. Any other suggestions?
>
>
> Michael Thode wrote:
will[color=darkred]
the[color=darkred]
| |
| Stella Lai 2005-08-22, 9:23 am |
| If the UL data store goes onto a SD card (for a NVFS device with both
internal and external
volume), the volume ordinal in palm_db should be set to 1. Volume ordinal
'0' is referring to
the internal volume.
Your command line would be as follows:
UID=DBA;PWD=SQL;palm
_schema=ERxDBusm;DBK
EY=password;palm_db=
ERxu:1
Again, the ULEnableFileDB() call should be made in this case.
- Stella Lai
iAnywhere Solutions
"Michael Thode" < mthode_no_spam@sybas
e.com> wrote in message
news:4304b70b$1@foru
ms-2-dub...
> Are you still seeing the same -82 sql error?
>
> Just to be clear...If you use your original command line
> UID=DBA;PWD=SQL;palm
_schema=ERxDBusm;DBK
EY=password;palm_db=
ERxu:2
> and put the the schema file in the same spot you did in the example I
> asked
> you to try then it still doesn't work?
>
> Mike
>
> "Brent Williams" < brentwilliams@bcbsal
.org> wrote in message
> news:4303aefc$1@foru
ms-2-dub...
> will
> the
>
>
| |
| Brent Williams 2005-08-22, 11:23 am |
| Yes, I am still seeing the same -82 sql error.
Here is what I did. I have the palm app and schema file in main memory.
I then call:
TheSqlca.Initialize()
ULEnableFileDB(TheSq
lca.GetCA());
ULEnableStrongEncryp
tion(TheSqlca.GetCA());
TheDBM = ULInitDatabaseManage
r(TheSqlca);
connParms = " UID=DBA;PWD=SQL;palm
_schema=ERxDBusm;DBK
EY=%s;palm_db=ERxu:2
"
connection = TheDBM-> CreateAndOpenDatabas
e(TheSqlca, connParms);
Does this seem to be correct? Is there something else I should try?
Michael Thode wrote:
> Are you still seeing the same -82 sql error?
>
> Just to be clear...If you use your original command line
> UID=DBA;PWD=SQL;palm
_schema=ERxDBusm;DBK
EY=password;palm_db=
ERxu:2
> and put the the schema file in the same spot you did in the example I asked
> you to try then it still doesn't work?
>
> Mike
>
> "Brent Williams" < brentwilliams@bcbsal
.org> wrote in message
> news:4303aefc$1@foru
ms-2-dub...
>
>
> will
>
>
> the
>
>
>
|
|
|
|