| Author |
Multi-user databases
|
|
| Evan Mandel 2005-08-12, 8:23 pm |
| I am carrying out a test that involves two programs on the same Pocket PC
utilizing the same handheld UltraLite database at the same time. Attempting
to use one to modify the database while the other is working on the
database, it presents me with an error "Database server not running in
multi-user mode." Where would I be able to set or otherwise put the
database into multi-user mode?
My version is 9.0.2.2451 .
| |
| Greg Fenton 2005-08-13, 7:23 am |
| Evan Mandel wrote:
> I am carrying out a test that involves two programs on the same Pocket PC
> utilizing the same handheld UltraLite database at the same time. Attempting
> to use one to modify the database while the other is working on the
> database, it presents me with an error "Database server not running in
> multi-user mode." Where would I be able to set or otherwise put the
> database into multi-user mode?
You would need to install and start the database with the UltraLite
engine (dbuleng.exe). Then you can connect to the engine.
In the SQLAnywhere 9.x online docs see:
UltraLite Database User's Guide
UltraLite Databases
The UltraLite runtime
- Using the UltraLite engine
Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
| Evan Mandel 2005-08-15, 11:23 am |
| "Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:42fd51ec$1@foru
ms-1-dub...
> Evan Mandel wrote:
>
> You would need to install and start the database with the UltraLite engine
> (dbuleng.exe). Then you can connect to the engine.
>
> In the SQLAnywhere 9.x online docs see:
>
> UltraLite Database User's Guide
> UltraLite Databases
> The UltraLite runtime
> - Using the UltraLite engine
>
> Hope this helps,
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
I'm already following the procedure outlined in that section, excepting
setting the StartLine parameter; presently I'm just leaving dbuleng.exe in
my handheld's Windows directory. Could that be the cause of the problem?
| |
| Michael Thode 2005-08-15, 11:23 am |
| Are you linking your application against ulrtc.lib?
Mike
"Evan Mandel" <emandel.NOSPAM@harris.com> wrote in message
news:4300ab5d@forums
-2-dub...
> "Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
> news:42fd51ec$1@foru
ms-1-dub...
PC[color=darkred]
engine[color=darkred
]
>
> I'm already following the procedure outlined in that section, excepting
> setting the StartLine parameter; presently I'm just leaving dbuleng.exe in
> my handheld's Windows directory. Could that be the cause of the problem?
>
>
| |
| Evan Mandel 2005-08-15, 8:23 pm |
| No, I'm linking against ulnetclient9.dll (in particular, the one found in
\ultralite\UltraLite
.NET\ce\arm\ in my UltraLite installation). The
applications are both .NET C# .
Evan
"Michael Thode" < mthode_no_spam@sybas
e.com> wrote in message
news:4300b7c7$1@foru
ms-1-dub...
> Are you linking your application against ulrtc.lib?
>
> Mike
>
> "Evan Mandel" <emandel.NOSPAM@harris.com> wrote in message
> news:4300ab5d@forums
-2-dub...
> PC
> engine
>
>
| |
| Tom Slee 2005-08-16, 1:25 pm |
| It is possible that the error is actually that one application is trying
to access a row that is still locked by the other application. Do you
have any open transactions? If so, you may want to be sure they are closed.
Tom
Evan Mandel wrote:
> No, I'm linking against ulnetclient9.dll (in particular, the one found in
> \ultralite\UltraLite
.NET\ce\arm\ in my UltraLite installation). The
> applications are both .NET C# .
>
> Evan
>
> "Michael Thode" < mthode_no_spam@sybas
e.com> wrote in message
> news:4300b7c7$1@foru
ms-1-dub...
>
>
>
| |
| Michael Thode 2005-08-16, 8:23 pm |
| What opperation are you attempting when you get the error?
Mike
"Evan Mandel" <emandel.NOSPAM@harris.com> wrote in message
news:4300c58e@forums
-1-dub...
> No, I'm linking against ulnetclient9.dll (in particular, the one found in
> \ultralite\UltraLite
.NET\ce\arm\ in my UltraLite installation). The
> applications are both .NET C# .
>
> Evan
>
> "Michael Thode" < mthode_no_spam@sybas
e.com> wrote in message
> news:4300b7c7$1@foru
ms-1-dub...
Pocket[color=darkred
]
problem?[color=darkred]
>
>
| |
| Evan Mandel 2005-08-18, 9:40 am |
| I am in fact attempting to insert into the database while a sync is ongoing.
I've tried this both attempting to insert into a table that has data to be
uploaded to the backend, and attempting to insert to a table that is
published for syncing but has no data that needs to be uploaded, and I've
been given the same error in both cases. Are all published tables locked
during a sync upload?
Evan
"Tom Slee" <Tom.Slee@ianywhere.com> wrote in message
news:43022e66$1@foru
ms-1-dub...[color=darkred]
> It is possible that the error is actually that one application is trying
> to access a row that is still locked by the other application. Do you have
> any open transactions? If so, you may want to be sure they are closed.
>
> Tom
>
> Evan Mandel wrote:
| |
| Michael Thode 2005-08-18, 11:24 am |
| Yes, all tables (even ones not involved in syncronization) are locked for
writes during the upload phase of the synchronization. If you get this
error you can retry after some period of time.
BTW we'll be changing the sql code in a future release to make this clearer.
Mike
"Evan Mandel" <emandel.NOSPAM@harris.com> wrote in message
news:43049716$1@foru
ms-2-dub...
> I am in fact attempting to insert into the database while a sync is
ongoing.
> I've tried this both attempting to insert into a table that has data to be
> uploaded to the backend, and attempting to insert to a table that is
> published for syncing but has no data that needs to be uploaded, and I've
> been given the same error in both cases. Are all published tables locked
> during a sync upload?
>
> Evan
>
> "Tom Slee" <Tom.Slee@ianywhere.com> wrote in message
> news:43022e66$1@foru
ms-1-dub...
have[color=darkred]
in[color=darkred]
Pocket[color=darkred
]
excepting[color=dark
red]
dbuleng.exe[color=darkred]
>
|
|
|
|