Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #10042 > unrolled thread

DBF opening

Started byJames Martin <james@northwoodlumber.com>
First post2016-12-13 15:01 -0500
Last post2016-12-18 10:26 -0800
Articles 20 on this page of 26 — 10 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  DBF opening James Martin <james@northwoodlumber.com> - 2016-12-13 15:01 -0500
    Re: DBF opening JohnMartens <martens@tennishulp.info> - 2016-12-13 21:32 +0100
      Re: DBF opening James Martin <james@northwoodlumber.com> - 2016-12-13 16:17 -0500
    Re: DBF opening "Jamal" <noooospam@example.com> - 2016-12-14 00:58 -0500
      Re: DBF opening Frans Wauters <info@wautersit.com> - 2016-12-14 05:12 -0800
    Re: DBF opening dlzc <dlzc1@cox.net> - 2016-12-14 05:59 -0800
      Re: DBF opening James Martin <james@northwoodlumber.com> - 2016-12-14 11:27 -0500
        Re: DBF opening dlzc <dlzc1@cox.net> - 2016-12-14 11:35 -0800
          Re: DBF opening James Martin <james@northwoodlumber.com> - 2016-12-14 14:47 -0500
          Re: DBF opening James Martin <james@northwoodlumber.com> - 2016-12-15 10:23 -0500
            Re: DBF opening dlzc <dlzc1@cox.net> - 2016-12-15 07:51 -0800
              Re: DBF opening dlzc <dlzc1@cox.net> - 2016-12-15 07:52 -0800
                Re: DBF opening James Martin <james@northwoodlumber.com> - 2016-12-15 11:09 -0500
                  Re: DBF opening James Martin <james@northwoodlumber.com> - 2016-12-15 11:49 -0500
            Re: DBF opening "Jim" <nospam@example.com> - 2016-12-15 10:58 -0500
              Re: DBF opening James Martin <james@northwoodlumber.com> - 2016-12-15 11:08 -0500
                Re: DBF opening Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2016-12-15 17:38 +0100
                  Re: DBF opening James Martin <james@northwoodlumber.com> - 2016-12-15 11:51 -0500
                    Re: DBF opening James Martin <james@northwoodlumber.com> - 2016-12-15 12:16 -0500
                    Re: DBF opening "Jamal" <noooospam@example.com> - 2016-12-15 14:58 -0500
                      Re: DBF opening James Martin <james@northwoodlumber.com> - 2016-12-15 15:11 -0500
                        Re: DBF opening D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2016-12-16 10:56 +0100
    Re: DBF opening Kuno Egger <kuno@retailsoftware.com> - 2016-12-16 16:15 -0800
      Re: DBF opening "Jamal" <nospam@example.com> - 2016-12-16 23:59 -0500
      Re: DBF opening D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2016-12-18 18:03 +0100
      Re: DBF opening dlzc <dlzc1@cox.net> - 2016-12-18 10:26 -0800

Page 1 of 2  [1] 2  Next page →


#10042 — DBF opening

FromJames Martin <james@northwoodlumber.com>
Date2016-12-13 15:01 -0500
SubjectDBF opening
Message-ID<o2pk0u$l4c$1@dont-email.me>
Can anyone tell what Error Code: 21 [OPEN ERROR] means?

I've never had problems opening the database before. And an old program 
does work.

As far as I can see everything I did should not have affected the 
program. The path is correct. Makes no difference whether I use the 
network or access the file directly.

What I did do is add a Windows server to the network and I copied the 
files over to the new server. I copied them, but left them on the old 
server too. I did not change the old server at all. And the problem I'm 
having is on the old server.

Is there any way to diagnose this? The program does open 3 tables and 
they are kept open all the time the program is running. But I cannot 
open any other table.

I am terminal serving to the server itself, so the data does not go over 
the network. The terminal server, the data, and the program running are 
all on the same computer.

This seems like a grade 1 problem, but someone here may have an idea.

James

[toc] | [next] | [standalone]


#10043

FromJohnMartens <martens@tennishulp.info>
Date2016-12-13 21:32 +0100
Message-ID<o2plqa$qra$1@dont-email.me>
In reply to#10042
Could the files be read only ?

Op 13-12-2016 om 21:01 schreef James Martin:
> Can anyone tell what Error Code: 21 [OPEN ERROR] means?
>
> I've never had problems opening the database before. And an old program
> does work.
>
> As far as I can see everything I did should not have affected the
> program. The path is correct. Makes no difference whether I use the
> network or access the file directly.
>
> What I did do is add a Windows server to the network and I copied the
> files over to the new server. I copied them, but left them on the old
> server too. I did not change the old server at all. And the problem I'm
> having is on the old server.
>
> Is there any way to diagnose this? The program does open 3 tables and
> they are kept open all the time the program is running. But I cannot
> open any other table.
>
> I am terminal serving to the server itself, so the data does not go over
> the network. The terminal server, the data, and the program running are
> all on the same computer.
>
> This seems like a grade 1 problem, but someone here may have an idea.
>
> James

[toc] | [prev] | [next] | [standalone]


#10044

FromJames Martin <james@northwoodlumber.com>
Date2016-12-13 16:17 -0500
Message-ID<o2poev$61q$1@dont-email.me>
In reply to#10043
They are not read-only. Since some of them open it makes no sense that 
they are read-only.

An interesting fact is that on the same program has a backup routine 
that zips up every file and that does work. The problem seems to be with 
the CDX driver.

James

On 16-12-13 03:32 PM, JohnMartens wrote:
> Could the files be read only ?
>
> Op 13-12-2016 om 21:01 schreef James Martin:
>> Can anyone tell what Error Code: 21 [OPEN ERROR] means?
>>
>> I've never had problems opening the database before. And an old program
>> does work.
>>
>> As far as I can see everything I did should not have affected the
>> program. The path is correct. Makes no difference whether I use the
>> network or access the file directly.
>>
>> What I did do is add a Windows server to the network and I copied the
>> files over to the new server. I copied them, but left them on the old
>> server too. I did not change the old server at all. And the problem I'm
>> having is on the old server.
>>
>> Is there any way to diagnose this? The program does open 3 tables and
>> they are kept open all the time the program is running. But I cannot
>> open any other table.
>>
>> I am terminal serving to the server itself, so the data does not go over
>> the network. The terminal server, the data, and the program running are
>> all on the same computer.
>>
>> This seems like a grade 1 problem, but someone here may have an idea.
>>
>> James

[toc] | [prev] | [next] | [standalone]


#10046

From"Jamal" <noooospam@example.com>
Date2016-12-14 00:58 -0500
Message-ID<o2qn2c$rdp$1@news.albasani.net>
In reply to#10042
What is the full VOERROR.LOG error message related to code 21?
It may shed some light.


Jamal

"James Martin"  wrote in message news:o2pk0u$l4c$1@dont-email.me... 

Can anyone tell what Error Code: 21 [OPEN ERROR] means?

I've never had problems opening the database before. And an old program 
does work.

As far as I can see everything I did should not have affected the 
program. The path is correct. Makes no difference whether I use the 
network or access the file directly.

What I did do is add a Windows server to the network and I copied the 
files over to the new server. I copied them, but left them on the old 
server too. I did not change the old server at all. And the problem I'm 
having is on the old server.

Is there any way to diagnose this? The program does open 3 tables and 
they are kept open all the time the program is running. But I cannot 
open any other table.

I am terminal serving to the server itself, so the data does not go over 
the network. The terminal server, the data, and the program running are 
all on the same computer.

This seems like a grade 1 problem, but someone here may have an idea.

James

[toc] | [prev] | [next] | [standalone]


#10048

FromFrans Wauters <info@wautersit.com>
Date2016-12-14 05:12 -0800
Message-ID<659b913d-6a4c-43b3-8b63-7ee6e86fee96@googlegroups.com>
In reply to#10046
Check these list
http://stanislavs.org/helppc/dos_error_codes.html

[toc] | [prev] | [next] | [standalone]


#10051

Fromdlzc <dlzc1@cox.net>
Date2016-12-14 05:59 -0800
Message-ID<01c681ed-0835-4641-a209-1f8aeb336173@googlegroups.com>
In reply to#10042
Dear James Martin:

On Tuesday, December 13, 2016 at 1:01:54 PM UTC-7, James Martin wrote:
> Can anyone tell what Error Code: 21 [OPEN ERROR]
> means?

Looks like a lock violation, based on Frans' list.  Which means the account active when your code is running, does not have the ability to place a lock (requires write access) on a file.

David A. Smith

[toc] | [prev] | [next] | [standalone]


#10053

FromJames Martin <james@northwoodlumber.com>
Date2016-12-14 11:27 -0500
Message-ID<o2rrro$dbu$1@dont-email.me>
In reply to#10051
What makes this confusing is that an older version of the program works. 
I need the newer version because there a a few necessary features. 
dbLite opens the files. It seems that it is the amount of file open that 
makes a problem (this is a guess). The DOS error is of course a lock 
problem, but why can I open 3 tables but no more? The ones open can be 
browsed, etc.

The files all have full access to everyone. The share is read/write.

The error subcode is 1101, if that helps any.

Is there any way to diagnose this?

I might add that Windows did a upgrade over this time too. Could there 
be a open files setting somewhere?

James

On 16-12-14 08:59 AM, dlzc wrote:
> Dear James Martin:
>
> On Tuesday, December 13, 2016 at 1:01:54 PM UTC-7, James Martin wrote:
>> Can anyone tell what Error Code: 21 [OPEN ERROR]
>> means?
>
> Looks like a lock violation, based on Frans' list.  Which means the account active when your code is running, does not have the ability to place a lock (requires write access) on a file.
>
> David A. Smith
>

[toc] | [prev] | [next] | [standalone]


#10055

Fromdlzc <dlzc1@cox.net>
Date2016-12-14 11:35 -0800
Message-ID<23971559-488d-452a-9407-7d155066752b@googlegroups.com>
In reply to#10053
Dear James Martin:

On Wednesday, December 14, 2016 at 9:27:56 AM UTC-7, James Martin wrote:
...
> What makes this confusing is that an older version
> of the program works. 

Same number of files, same number of indexes?

> I need the newer version because there a a few
> necessary features. dbLite opens the files. It
> seems that it is the amount of file open that 
> makes a problem (this is a guess).

As good as any.  How can you disprove this?  Can you change the opening order, and see if it crashes on a different file?

> The DOS error is of course a lock problem, but
> why can I open 3 tables but no more?

Maybe something else has the file open already, and the "new program" initially tries for an exclusive lock?

> The ones open can be browsed, etc.
> 
> The files all have full access to everyone. The
> share is read/write.

... but the problem is the new code only?  How about machine / OS / etc.?

> The error subcode is 1101, if that helps any.
> 
> Is there any way to diagnose this?
> 
> I might add that Windows did a upgrade over this
> time too. Could there be a open files setting
> somewhere?

I doubt this is the problem, if you are getting a lock error.

David A. Smith

[toc] | [prev] | [next] | [standalone]


#10056

FromJames Martin <james@northwoodlumber.com>
Date2016-12-14 14:47 -0500
Message-ID<o2s7h0$qgu$1@dont-email.me>
In reply to#10055
I'm in the process of dumbing down the program and seeing if I can find 
anything. The old program uses the same numbers of files and index 
files. The Machine & OS is the same.

James

On 16-12-14 02:35 PM, dlzc wrote:
> Dear James Martin:
>
> On Wednesday, December 14, 2016 at 9:27:56 AM UTC-7, James Martin wrote:
> ...
>> What makes this confusing is that an older version
>> of the program works.
>
> Same number of files, same number of indexes?
>
>> I need the newer version because there a a few
>> necessary features. dbLite opens the files. It
>> seems that it is the amount of file open that
>> makes a problem (this is a guess).
>
> As good as any.  How can you disprove this?  Can you change the opening order, and see if it crashes on a different file?
>
>> The DOS error is of course a lock problem, but
>> why can I open 3 tables but no more?
>
> Maybe something else has the file open already, and the "new program" initially tries for an exclusive lock?
>
>> The ones open can be browsed, etc.
>>
>> The files all have full access to everyone. The
>> share is read/write.
>
> ... but the problem is the new code only?  How about machine / OS / etc.?
>
>> The error subcode is 1101, if that helps any.
>>
>> Is there any way to diagnose this?
>>
>> I might add that Windows did a upgrade over this
>> time too. Could there be a open files setting
>> somewhere?
>
> I doubt this is the problem, if you are getting a lock error.
>
> David A. Smith
>

[toc] | [prev] | [next] | [standalone]


#10059

FromJames Martin <james@northwoodlumber.com>
Date2016-12-15 10:23 -0500
Message-ID<o2ucfj$jd1$1@dont-email.me>
In reply to#10055
This is frustrating.

I made a simple program and with it I can open many many dbfs.

Is there any function to check the status of a file. In the origional 
program I can't even open the dbfs readonly. I have specified shared, 
readonly, and the RDD driver. It won't open.

James

On 16-12-14 02:35 PM, dlzc wrote:
> Dear James Martin:
>
> On Wednesday, December 14, 2016 at 9:27:56 AM UTC-7, James Martin wrote:
> ...
>> What makes this confusing is that an older version
>> of the program works.
>
> Same number of files, same number of indexes?
>
>> I need the newer version because there a a few
>> necessary features. dbLite opens the files. It
>> seems that it is the amount of file open that
>> makes a problem (this is a guess).
>
> As good as any.  How can you disprove this?  Can you change the opening order, and see if it crashes on a different file?
>
>> The DOS error is of course a lock problem, but
>> why can I open 3 tables but no more?
>
> Maybe something else has the file open already, and the "new program" initially tries for an exclusive lock?
>
>> The ones open can be browsed, etc.
>>
>> The files all have full access to everyone. The
>> share is read/write.
>
> ... but the problem is the new code only?  How about machine / OS / etc.?
>
>> The error subcode is 1101, if that helps any.
>>
>> Is there any way to diagnose this?
>>
>> I might add that Windows did a upgrade over this
>> time too. Could there be a open files setting
>> somewhere?
>
> I doubt this is the problem, if you are getting a lock error.
>
> David A. Smith
>

[toc] | [prev] | [next] | [standalone]


#10060

Fromdlzc <dlzc1@cox.net>
Date2016-12-15 07:51 -0800
Message-ID<6f6956be-61c4-43e5-b5fd-7443f79495eb@googlegroups.com>
In reply to#10059
Dear James Martin:

On Thursday, December 15, 2016 at 8:23:53 AM UTC-7, James Martin wrote:
> This is frustrating.
> 
> I made a simple program and with it I can open
> many many dbfs.

Ok, so you have a simple logic error, and you need to narrow it down to the offending step.  Can you write a trace to a file?
 
> Is there any function to check the status of a
> file. In the origional program I can't even
> open the dbfs readonly. I have specified shared, 
> readonly, and the RDD driver. It won't open.

Did you try to open, in your simple program, shared, *and* readonly?

Since I only do Clipper variants, do you have the equivalent of dbinfo()?
http://www.ousob.com/ng/53guide/ng28fbc.php

David A. Smith

[toc] | [prev] | [next] | [standalone]


#10061

Fromdlzc <dlzc1@cox.net>
Date2016-12-15 07:52 -0800
Message-ID<329c5f13-efd0-4191-b471-599b6661e921@googlegroups.com>
In reply to#10060
On Thursday, December 15, 2016 at 8:51:25 AM UTC-7, dlzc wrote:
> Dear James Martin:
> 
> On Thursday, December 15, 2016 at 8:23:53 AM UTC-7, James Martin wrote:
...
> > I have specified shared, readonly, and the
> RDD driver. It won't open.
> 
> Did you try to open, in your simple program, shared, *and* readonly?

Note that you are getting a lock error, yet telling it (by "shared") that you intend to apply locks.

David A. Smith

[toc] | [prev] | [next] | [standalone]


#10064

FromJames Martin <james@northwoodlumber.com>
Date2016-12-15 11:09 -0500
Message-ID<o2uf4g$sgm$2@dont-email.me>
In reply to#10061
I have narrowed down the lines that make the problem. I should know 
shortly what is the problem.

James

On 16-12-15 10:52 AM, dlzc wrote:
> On Thursday, December 15, 2016 at 8:51:25 AM UTC-7, dlzc wrote:
>> Dear James Martin:
>>
>> On Thursday, December 15, 2016 at 8:23:53 AM UTC-7, James Martin wrote:
> ...
>>> I have specified shared, readonly, and the
>> RDD driver. It won't open.
>>
>> Did you try to open, in your simple program, shared, *and* readonly?
>
> Note that you are getting a lock error, yet telling it (by "shared") that you intend to apply locks.
>
> David A. Smith
>

[toc] | [prev] | [next] | [standalone]


#10066

FromJames Martin <james@northwoodlumber.com>
Date2016-12-15 11:49 -0500
Message-ID<o2uhgl$7qg$1@dont-email.me>
In reply to#10064
Here is the offending line (the middle one):

SetDefault(SELF:cPath)
SetPath(SELF:cPath)
cFullPath	:= Alltrim(SELF:cPath) + "LProfile.dbf"

I had to comment out the middle line. The program works now, but I don't 
know why commenting out that fixed it. SELF:cPath is right - I checked 
it. I have hard coded this early in the program as a default:

cPath	:= "V:\data\"
SetPath(cPath)
SetDefault(cPath)

After playing around I realized that SELF:cPath was not trimmed (it came 
from a dbf). The program worked for years that way until this week! Oh 
well, it works now.

Thanks everybody.

James



On 16-12-15 11:09 AM, James Martin wrote:
> I have narrowed down the lines that make the problem. I should know
> shortly what is the problem.
>
> James
>
> On 16-12-15 10:52 AM, dlzc wrote:
>> On Thursday, December 15, 2016 at 8:51:25 AM UTC-7, dlzc wrote:
>>> Dear James Martin:
>>>
>>> On Thursday, December 15, 2016 at 8:23:53 AM UTC-7, James Martin wrote:
>> ...
>>>> I have specified shared, readonly, and the
>>> RDD driver. It won't open.
>>>
>>> Did you try to open, in your simple program, shared, *and* readonly?
>>
>> Note that you are getting a lock error, yet telling it (by "shared")
>> that you intend to apply locks.
>>
>> David A. Smith
>>

[toc] | [prev] | [next] | [standalone]


#10062

From"Jim" <nospam@example.com>
Date2016-12-15 10:58 -0500
Message-ID<o2uejj$ohu$1@gioia.aioe.org>
In reply to#10059
Again! What is the FULL error log from VOERROR.LOG?

Jamal

"James Martin"  wrote in message news:o2ucfj$jd1$1@dont-email.me...

This is frustrating.

I made a simple program and with it I can open many many dbfs.

Is there any function to check the status of a file. In the origional
program I can't even open the dbfs readonly. I have specified shared,
readonly, and the RDD driver. It won't open.

James

On 16-12-14 02:35 PM, dlzc wrote:
> Dear James Martin:
>
> On Wednesday, December 14, 2016 at 9:27:56 AM UTC-7, James Martin wrote:
> ...
>> What makes this confusing is that an older version
>> of the program works.
>
> Same number of files, same number of indexes?
>
>> I need the newer version because there a a few
>> necessary features. dbLite opens the files. It
>> seems that it is the amount of file open that
>> makes a problem (this is a guess).
>
> As good as any.  How can you disprove this?  Can you change the opening 
> order, and see if it crashes on a different file?
>
>> The DOS error is of course a lock problem, but
>> why can I open 3 tables but no more?
>
> Maybe something else has the file open already, and the "new program" 
> initially tries for an exclusive lock?
>
>> The ones open can be browsed, etc.
>>
>> The files all have full access to everyone. The
>> share is read/write.
>
> ... but the problem is the new code only?  How about machine / OS / etc.?
>
>> The error subcode is 1101, if that helps any.
>>
>> Is there any way to diagnose this?
>>
>> I might add that Windows did a upgrade over this
>> time too. Could there be a open files setting
>> somewhere?
>
> I doubt this is the problem, if you are getting a lock error.
>
> David A. Smith
> 

[toc] | [prev] | [next] | [standalone]


#10063

FromJames Martin <james@northwoodlumber.com>
Date2016-12-15 11:08 -0500
Message-ID<o2uf2m$sgm$1@dont-email.me>
In reply to#10062
It's 3.74 MB. How do I send it?

James

On 16-12-15 10:58 AM, Jim wrote:
> Again! What is the FULL error log from VOERROR.LOG?
>
> Jamal
>
> "James Martin"  wrote in message news:o2ucfj$jd1$1@dont-email.me...
>
> This is frustrating.
>
> I made a simple program and with it I can open many many dbfs.
>
> Is there any function to check the status of a file. In the origional
> program I can't even open the dbfs readonly. I have specified shared,
> readonly, and the RDD driver. It won't open.
>
> James
>
> On 16-12-14 02:35 PM, dlzc wrote:
>> Dear James Martin:
>>
>> On Wednesday, December 14, 2016 at 9:27:56 AM UTC-7, James Martin wrote:
>> ...
>>> What makes this confusing is that an older version
>>> of the program works.
>>
>> Same number of files, same number of indexes?
>>
>>> I need the newer version because there a a few
>>> necessary features. dbLite opens the files. It
>>> seems that it is the amount of file open that
>>> makes a problem (this is a guess).
>>
>> As good as any.  How can you disprove this?  Can you change the
>> opening order, and see if it crashes on a different file?
>>
>>> The DOS error is of course a lock problem, but
>>> why can I open 3 tables but no more?
>>
>> Maybe something else has the file open already, and the "new program"
>> initially tries for an exclusive lock?
>>
>>> The ones open can be browsed, etc.
>>>
>>> The files all have full access to everyone. The
>>> share is read/write.
>>
>> ... but the problem is the new code only?  How about machine / OS / etc.?
>>
>>> The error subcode is 1101, if that helps any.
>>>
>>> Is there any way to diagnose this?
>>>
>>> I might add that Windows did a upgrade over this
>>> time too. Could there be a open files setting
>>> somewhere?
>>
>> I doubt this is the problem, if you are getting a lock error.
>>
>> David A. Smith
>>
>

[toc] | [prev] | [next] | [standalone]


#10065

FromKarl Faller <mail_withoutthat_@_drei-f_andthat_.de>
Date2016-12-15 17:38 +0100
Message-ID<pmh55ctel1pa9dm17asan42edij21351d7@4ax.com>
In reply to#10063
James,
rename and provoke a new crash. The file is cumulative...

Karl

>It's 3.74 MB. How do I send it?
>
>James
>
>On 16-12-15 10:58 AM, Jim wrote:
>> Again! What is the FULL error log from VOERROR.LOG?
>>
>> Jamal
>>
>> "James Martin"  wrote in message news:o2ucfj$jd1$1@dont-email.me...
>>
>> This is frustrating.
>>
>> I made a simple program and with it I can open many many dbfs.
>>
>> Is there any function to check the status of a file. In the origional
>> program I can't even open the dbfs readonly. I have specified shared,
>> readonly, and the RDD driver. It won't open.
>>
>> James
>>
>> On 16-12-14 02:35 PM, dlzc wrote:
>>> Dear James Martin:
>>>
>>> On Wednesday, December 14, 2016 at 9:27:56 AM UTC-7, James Martin wrote:
>>> ...
>>>> What makes this confusing is that an older version
>>>> of the program works.
>>>
>>> Same number of files, same number of indexes?
>>>
>>>> I need the newer version because there a a few
>>>> necessary features. dbLite opens the files. It
>>>> seems that it is the amount of file open that
>>>> makes a problem (this is a guess).
>>>
>>> As good as any.  How can you disprove this?  Can you change the
>>> opening order, and see if it crashes on a different file?
>>>
>>>> The DOS error is of course a lock problem, but
>>>> why can I open 3 tables but no more?
>>>
>>> Maybe something else has the file open already, and the "new program"
>>> initially tries for an exclusive lock?
>>>
>>>> The ones open can be browsed, etc.
>>>>
>>>> The files all have full access to everyone. The
>>>> share is read/write.
>>>
>>> ... but the problem is the new code only?  How about machine / OS / etc.?
>>>
>>>> The error subcode is 1101, if that helps any.
>>>>
>>>> Is there any way to diagnose this?
>>>>
>>>> I might add that Windows did a upgrade over this
>>>> time too. Could there be a open files setting
>>>> somewhere?
>>>
>>> I doubt this is the problem, if you are getting a lock error.
>>>
>>> David A. Smith
>>>
>>
Regards

Karl

[toc] | [prev] | [next] | [standalone]


#10067

FromJames Martin <james@northwoodlumber.com>
Date2016-12-15 11:51 -0500
Message-ID<o2uhja$7qg$2@dont-email.me>
In reply to#10065
Program works now. It seems that white space in a setpath() statement 
caused this. Why it worked until this week is a mystery!

James

On 16-12-15 11:38 AM, Karl Faller wrote:
> James,
> rename and provoke a new crash. The file is cumulative...
>
> Karl
>
>> It's 3.74 MB. How do I send it?
>>
>> James
>>
>> On 16-12-15 10:58 AM, Jim wrote:
>>> Again! What is the FULL error log from VOERROR.LOG?
>>>
>>> Jamal
>>>
>>> "James Martin"  wrote in message news:o2ucfj$jd1$1@dont-email.me...
>>>
>>> This is frustrating.
>>>
>>> I made a simple program and with it I can open many many dbfs.
>>>
>>> Is there any function to check the status of a file. In the origional
>>> program I can't even open the dbfs readonly. I have specified shared,
>>> readonly, and the RDD driver. It won't open.
>>>
>>> James
>>>
>>> On 16-12-14 02:35 PM, dlzc wrote:
>>>> Dear James Martin:
>>>>
>>>> On Wednesday, December 14, 2016 at 9:27:56 AM UTC-7, James Martin wrote:
>>>> ...
>>>>> What makes this confusing is that an older version
>>>>> of the program works.
>>>>
>>>> Same number of files, same number of indexes?
>>>>
>>>>> I need the newer version because there a a few
>>>>> necessary features. dbLite opens the files. It
>>>>> seems that it is the amount of file open that
>>>>> makes a problem (this is a guess).
>>>>
>>>> As good as any.  How can you disprove this?  Can you change the
>>>> opening order, and see if it crashes on a different file?
>>>>
>>>>> The DOS error is of course a lock problem, but
>>>>> why can I open 3 tables but no more?
>>>>
>>>> Maybe something else has the file open already, and the "new program"
>>>> initially tries for an exclusive lock?
>>>>
>>>>> The ones open can be browsed, etc.
>>>>>
>>>>> The files all have full access to everyone. The
>>>>> share is read/write.
>>>>
>>>> ... but the problem is the new code only?  How about machine / OS / etc.?
>>>>
>>>>> The error subcode is 1101, if that helps any.
>>>>>
>>>>> Is there any way to diagnose this?
>>>>>
>>>>> I might add that Windows did a upgrade over this
>>>>> time too. Could there be a open files setting
>>>>> somewhere?
>>>>
>>>> I doubt this is the problem, if you are getting a lock error.
>>>>
>>>> David A. Smith
>>>>
>>>
> Regards
>
> Karl
>

[toc] | [prev] | [next] | [standalone]


#10068

FromJames Martin <james@northwoodlumber.com>
Date2016-12-15 12:16 -0500
Message-ID<o2uj2c$der$1@dont-email.me>
In reply to#10067
Here is the error message in VOError.log

Visual Objects (Version 2.8. Build 2.2830), Version 2.8 SP2

12/15/16 11:30:26

Application: C:\cavo28\Bin\Lumber1.DBG



Error message:

--------------

Error Code:  21 [ OPEN ERROR ]

Subsystem: DBFCDX

Error Subcode: 1101 (Open database)

Function: INIT

Filename: C:\Apps\Lumber\Data\

CallStack:

LPROFILE:INIT (Line:65)

ORDERLIST:PREINIT (Line:7)

ORDERLIST:INIT (Line:3)

LUMBERSHELLWINDOW:OPENORDERLIST (Line:11)

LUMBERSHELLWINDOW:DISPATCH (Line:17)



Error Object created:

--------------------

SubSystem       :DBFCDX

SubCode         :1101

GenCode         :Open error

OsCode          :2

ArgType         :NIL

FuncPtr         :0x00000000

ArgNum          :0

FuncSym         :INIT

Severity        :2

CanDefault      :.F.

CanRetry        :.T.

CanSubstitute   :.F.

Operation       :

Description     :

FileName        :C:\Apps\Lumber\Data\ 
                    \LPROFILE.DBF

Tries           :1

FileHandle      :0

SubCodeText     :Open database

Arg             :

ArgTypeReq      :NIL

MaxSize         :0

SubstituteType  :NIL

CallFuncSym     :

The Filename line did not format well here, but there is lots of white 
space between the path and the file name. I hadn't noticed that!

James

On 16-12-15 11:51 AM, James Martin wrote:
> Program works now. It seems that white space in a setpath() statement
> caused this. Why it worked until this week is a mystery!
>
> James
>
> On 16-12-15 11:38 AM, Karl Faller wrote:
>> James,
>> rename and provoke a new crash. The file is cumulative...
>>
>> Karl
>>
>>> It's 3.74 MB. How do I send it?
>>>
>>> James
>>>
>>> On 16-12-15 10:58 AM, Jim wrote:
>>>> Again! What is the FULL error log from VOERROR.LOG?
>>>>
>>>> Jamal
>>>>
>>>> "James Martin"  wrote in message news:o2ucfj$jd1$1@dont-email.me...
>>>>
>>>> This is frustrating.
>>>>
>>>> I made a simple program and with it I can open many many dbfs.
>>>>
>>>> Is there any function to check the status of a file. In the origional
>>>> program I can't even open the dbfs readonly. I have specified shared,
>>>> readonly, and the RDD driver. It won't open.
>>>>
>>>> James
>>>>
>>>> On 16-12-14 02:35 PM, dlzc wrote:
>>>>> Dear James Martin:
>>>>>
>>>>> On Wednesday, December 14, 2016 at 9:27:56 AM UTC-7, James Martin
>>>>> wrote:
>>>>> ...
>>>>>> What makes this confusing is that an older version
>>>>>> of the program works.
>>>>>
>>>>> Same number of files, same number of indexes?
>>>>>
>>>>>> I need the newer version because there a a few
>>>>>> necessary features. dbLite opens the files. It
>>>>>> seems that it is the amount of file open that
>>>>>> makes a problem (this is a guess).
>>>>>
>>>>> As good as any.  How can you disprove this?  Can you change the
>>>>> opening order, and see if it crashes on a different file?
>>>>>
>>>>>> The DOS error is of course a lock problem, but
>>>>>> why can I open 3 tables but no more?
>>>>>
>>>>> Maybe something else has the file open already, and the "new program"
>>>>> initially tries for an exclusive lock?
>>>>>
>>>>>> The ones open can be browsed, etc.
>>>>>>
>>>>>> The files all have full access to everyone. The
>>>>>> share is read/write.
>>>>>
>>>>> ... but the problem is the new code only?  How about machine / OS /
>>>>> etc.?
>>>>>
>>>>>> The error subcode is 1101, if that helps any.
>>>>>>
>>>>>> Is there any way to diagnose this?
>>>>>>
>>>>>> I might add that Windows did a upgrade over this
>>>>>> time too. Could there be a open files setting
>>>>>> somewhere?
>>>>>
>>>>> I doubt this is the problem, if you are getting a lock error.
>>>>>
>>>>> David A. Smith
>>>>>
>>>>
>> Regards
>>
>> Karl
>>

[toc] | [prev] | [next] | [standalone]


#10073

From"Jamal" <noooospam@example.com>
Date2016-12-15 14:58 -0500
Message-ID<o2uskv$i77$1@news.albasani.net>
In reply to#10067
So, is it working fine now and further help is no longer needed?

Jamal

"James Martin"  wrote in message news:o2uhja$7qg$2@dont-email.me...

Program works now. It seems that white space in a setpath() statement
caused this. Why it worked until this week is a mystery!

James

On 16-12-15 11:38 AM, Karl Faller wrote:
> James,
> rename and provoke a new crash. The file is cumulative...
>
> Karl
>
>> It's 3.74 MB. How do I send it?
>>
>> James
>>
>> On 16-12-15 10:58 AM, Jim wrote:
>>> Again! What is the FULL error log from VOERROR.LOG?
>>>
>>> Jamal
>>>
>>> "James Martin"  wrote in message news:o2ucfj$jd1$1@dont-email.me...
>>>
>>> This is frustrating.
>>>
>>> I made a simple program and with it I can open many many dbfs.
>>>
>>> Is there any function to check the status of a file. In the origional
>>> program I can't even open the dbfs readonly. I have specified shared,
>>> readonly, and the RDD driver. It won't open.
>>>
>>> James
>>>
>>> On 16-12-14 02:35 PM, dlzc wrote:
>>>> Dear James Martin:
>>>>
>>>> On Wednesday, December 14, 2016 at 9:27:56 AM UTC-7, James Martin 
>>>> wrote:
>>>> ...
>>>>> What makes this confusing is that an older version
>>>>> of the program works.
>>>>
>>>> Same number of files, same number of indexes?
>>>>
>>>>> I need the newer version because there a a few
>>>>> necessary features. dbLite opens the files. It
>>>>> seems that it is the amount of file open that
>>>>> makes a problem (this is a guess).
>>>>
>>>> As good as any.  How can you disprove this?  Can you change the
>>>> opening order, and see if it crashes on a different file?
>>>>
>>>>> The DOS error is of course a lock problem, but
>>>>> why can I open 3 tables but no more?
>>>>
>>>> Maybe something else has the file open already, and the "new program"
>>>> initially tries for an exclusive lock?
>>>>
>>>>> The ones open can be browsed, etc.
>>>>>
>>>>> The files all have full access to everyone. The
>>>>> share is read/write.
>>>>
>>>> ... but the problem is the new code only?  How about machine / OS / 
>>>> etc.?
>>>>
>>>>> The error subcode is 1101, if that helps any.
>>>>>
>>>>> Is there any way to diagnose this?
>>>>>
>>>>> I might add that Windows did a upgrade over this
>>>>> time too. Could there be a open files setting
>>>>> somewhere?
>>>>
>>>> I doubt this is the problem, if you are getting a lock error.
>>>>
>>>> David A. Smith
>>>>
>>>
> Regards
>
> Karl
> 

[toc] | [prev] | [next] | [standalone]


Page 1 of 2  [1] 2  Next page →

Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web