I've got another weird issue with 11.0.0.1526.

I have a table that contains 26 rows.
When I look in Sybase Central at the ultralite db I took from the handheld
there are 26 rows and my select statement select * from FS_User where id
='2018' works.
That same select statement when using ULCommand does not work and a select
count(*) from FS_User returns 15 rows.

This is CF 2.0 VS2005 C# code referencing ianwhere.Data.Ultralite
(11.0.0.1526)

What gives? This is the second weird behaviour with this library (The
required Dispose for command using parameters being the other)

Jonathan

Jonathan,

How big is this database? Can you post it to the newsgroup? Or if you do
not want it to be publicly posted you can send it directly to me.

Thanks

Kory Hodgson
Sybase iAnywhere



Jonathan Chapman wrote:

Kory,

The database is not very big. It's the same database that you have with the
exception that the items have been limite to 1000. Otherwise it should be
identical.

Jonathan

"Kory Hodgson (Sybase iAnywhere)" <khodgson_nospam (AT) sybase (DOT) com> wrote in
message news:4977f080$1 (AT) forums-1-dub (DOT) ..

Jonathan,

I tried doing what you had suggested, however I got the same results
with both Sybase Central and with a ULCommand object.

Sometimes what I have seen happen is if you add a file reference in
Visual Studio and then modify that file the Visual Studio version of
that file has been cached within your project and does not get updated.

Also, if you are developing on a mobile device, sometimes the deployment
is not copying over a new version of that database.

I would suggest removing the database from your project and then
re-adding it ensuring that all past references have been cleaned up.
This way you can try and make sure Visual Studio is using the same
version of the file you expect it to be using.

Thanks

Kory Hodgson
Sybase iAnywhere


Jonathan Chapman wrote:

Well I figured out what happens and it looks like it's a defect in Sybase
Central. If I open an Ultralite DB called c:\temp\test.udb and then
disconnect from it. I then open a db called c:\temp2\temp.udb (i.e. same
name but different folders) it says it opens the db but it actually uses
the original db. That is why I was seeing data in sybase central that was
not there during the application run.

Should I log in Case Express?

Thanks,
Jonathan

"Kory Hodgson (Sybase iAnywhere)" <khodgson_nospam (AT) sybase (DOT) com> wrote in
message news:49788e1b$1 (AT) forums-1-dub (DOT) ..

Jonathan,

They way are clients connect to a server, by design is as follows:

They look for a server running with the name specified: eg if you go to
connect to a database called temp.udb and a temp.udb is already running
it will connect to it even if it is in a different location than where
you specified. Please see the following link with a description of how a
client connects to a server:
http://dcx.sybase.com/index.php#http...edatabase.html

Thanks

Kory Hodgson
Sybase iAnywhere




Jonathan Chapman wrote:

How can I tell that a udb file is running? In this case I'm opening a file
directly so how can it be getting confused? It's talking about servers
and dbf's, which don't apply to udb files.

"Kory Hodgson (Sybase iAnywhere)" <khodgson_nospam (AT) sybase (DOT) com> wrote in
message news:4978d071 (AT) forums-1-dub (DOT) ..

Jonathan,

So if you open a temp.udb from folder 1 in Sybase Central and then
connect to it with dbisql. Then you disconnect from it in Sybase Central
and try to connect to temp.udb from folder 2 it will connect to the
original database since it is still running with the dbisql connection
even though you specified the database file path. This is because it
looks for the server name first.

This should only occur if the database .udb is already running. To check
this look at the processes tab in Task Manager and look for uleng11.exe

Thanks

Kory Hodgson
Sybase iAnywhere



Jonathan Chapman wrote:

Thanks,
I looked and as soon as I open an ultralite database uleng11 runs until
I close Sybase Central. Disconnecting from the database does not close
uleng. Opening more than one db does not start another uleng process. So
if I stay inside sybase central I have to rememeber which file I opened
first if I have two with the same name.


"Kory Hodgson (Sybase iAnywhere)" <khodgson_nospam (AT) sybase (DOT) com> wrote in
message news:4978e118$1 (AT) forums-1-dub (DOT) ..

Disconnecting from the database if you have not opened dbisql or another application should shutdown the engine. Please open a case with exact steps you use to connect, interact then disconnect. Check to make sure there is nothing in the Advance tab of the Connect dialog.

You can connect to 2 or more databases with the same name by specifying a different dbn (under the advanced tab).

---
Philippe Bertrand
Sybase iAnywhere

"Jonathan Chapman" <jonathan_chapman (AT) apexsi (DOT) com> wrote