Error 46 & error 100 -> Pervasive.SQL


"Rob Berkers" <rberkers@...
 

Hi group,

Recently we did upgrade Btrieve 6.10 on our Novell-filerserver to
Pervasive.SQL. Our Magic 5.60c applications is running most of the time
really good. We did convert our Btrieve 5.x files to Btrieve 7.0 files.

But every now and then we run into an error 46 or an error 100. I can't get
an real reason for these errors.

Anyone an idea in which direction to look for the cause of these errors????

Thanks,

Cheers,
Rob.


slevine@...
 

Rob,

To my knowledge, the error 46 problem is limited to version 5 files.
When Pervasive wrote btrieve 7, they somehow interpreted magic's "Read
only" file open (This task can only read the file) as "This file can
only be read, and not written to, by ANYBODY!"

When the "first" user of a file opens it in write/write mode,
subsequent users are fine. However, when the "first" user of a file
opens it in Magic read/write mode, all subsequent users who attempt to
update a record in the file will crash with error 46.

You may have some version 5 files hanging around, and they may be the
cause of the problem. Also, did you set btrieve to create any new
files in version 7 format?

Pervasive has a series of service release patches on their website
www.pervasive.com, however one of our clients has had multiple server
abends, which appears have been solved only by "last week's patch",
which may or may not be available on the server. I'll try to find out
the current patch version and post it when I have it.

I haven't heard of "error 100" problems, but...

Another day, another patch!

Sherm Levine


On 12/21/98 00:01:04 you wrote:

From: "Rob Berkers" <rberkers@...>

Hi group,

Recently we did upgrade Btrieve 6.10 on our Novell-filerserver to
Pervasive.SQL. Our Magic 5.60c applications is running most of the time
really good. We did convert our Btrieve 5.x files to Btrieve 7.0 files.

But every now and then we run into an error 46 or an error 100. I can't get
an real reason for these errors.

Anyone an idea in which direction to look for the cause of these errors????

Thanks,

Cheers,
Rob.




------------------------------------------------------------------------
To unsubscribe from this mailing list, or to change your subscription
to digest, go to the ONElist web site, at http://www.onelist.com and
select the User Center link from the menu bar on the left.
------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------
------------------------------
Please ensure that you respect other users of this list, and do not flame or insult others.
Any problems please contact peter.stewart@...
-----------------------------------------------------------------------------------------------
--------------------------------



Sherman Levine
MIT
Management of Information Technologies, Inc
(914)-967-7212 voice
(914)-967-7460 fax


Bret Wiener <bret@...
 

Wow!!! Thank you Sherman!!!

This outlined our problem EXACTLY. After taking a closer look, it turns out
that some of our files are still "prior to version 6" (as reported by
BUTIL). All I have to do is convert such files to 6 or newer and the error
46's go away!

Thanks so much!!

Bret Wiener
Rapattoni Corporation
mailto:bret@...

-----Original Message-----
From: slevine@... [mailto:slevine@...]
Sent: Sunday, December 20, 1998 5:43 PM
To: rberkers@...; magicu-l@...
Subject: [magicu-l] Re: Error 46 & error 100 -> Pervasive.SQL


From: slevine@...

Rob,

To my knowledge, the error 46 problem is limited to version 5 files.
When Pervasive wrote btrieve 7, they somehow interpreted magic's "Read
only" file open (This task can only read the file) as "This file can
only be read, and not written to, by ANYBODY!"

When the "first" user of a file opens it in write/write mode,
subsequent users are fine. However, when the "first" user of a file
opens it in Magic read/write mode, all subsequent users who attempt to
update a record in the file will crash with error 46.

You may have some version 5 files hanging around, and they may be the
cause of the problem. Also, did you set btrieve to create any new
files in version 7 format?

Pervasive has a series of service release patches on their website
www.pervasive.com, however one of our clients has had multiple server
abends, which appears have been solved only by "last week's patch",
which may or may not be available on the server. I'll try to find out
the current patch version and post it when I have it.

I haven't heard of "error 100" problems, but...

Another day, another patch!

Sherm Levine


On 12/21/98 00:01:04 you wrote:

From: "Rob Berkers" <rberkers@...>

Hi group,

Recently we did upgrade Btrieve 6.10 on our Novell-filerserver to
Pervasive.SQL. Our Magic 5.60c applications is running most of the time
really good. We did convert our Btrieve 5.x files to Btrieve 7.0 files.

But every now and then we run into an error 46 or an error 100. I can't get
an real reason for these errors.

Anyone an idea in which direction to look for the cause of these errors????

Thanks,

Cheers,
Rob.




------------------------------------------------------------------------
To unsubscribe from this mailing list, or to change your subscription
to digest, go to the ONElist web site, at http://www.onelist.com and
select the User Center link from the menu bar on the left.
------------------------------------------------------------------------
---------------------------------------------------------------------------
--------------------
------------------------------
Please ensure that you respect other users of this list, and do not flame
or insult others.
Any problems please contact peter.stewart@...
---------------------------------------------------------------------------
--------------------
--------------------------------



Sherman Levine
MIT
Management of Information Technologies, Inc
(914)-967-7212 voice
(914)-967-7460 fax


------------------------------------------------------------------------
To unsubscribe from this mailing list, or to change your subscription
to digest, go to the ONElist web site, at http://www.onelist.com and
select the User Center link from the menu bar on the left.
------------------------------------------------------------------------
----------------------------------------------------------------------------
-------------------------------------------------
Please ensure that you respect other users of this list, and do not flame or
insult others.
Any problems please contact peter.stewart@...
----------------------------------------------------------------------------
---------------------------------------------------