Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #10042 > unrolled thread
| Started by | James Martin <james@northwoodlumber.com> |
|---|---|
| First post | 2016-12-13 15:01 -0500 |
| Last post | 2016-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
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 →
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2016-12-13 15:01 -0500 |
| Subject | DBF 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]
| From | JohnMartens <martens@tennishulp.info> |
|---|---|
| Date | 2016-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]
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2016-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]
| From | "Jamal" <noooospam@example.com> |
|---|---|
| Date | 2016-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]
| From | Frans Wauters <info@wautersit.com> |
|---|---|
| Date | 2016-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]
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Date | 2016-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]
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2016-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]
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Date | 2016-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]
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2016-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]
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2016-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]
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Date | 2016-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]
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Date | 2016-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]
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2016-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]
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2016-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]
| From | "Jim" <nospam@example.com> |
|---|---|
| Date | 2016-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]
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2016-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]
| From | Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> |
|---|---|
| Date | 2016-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]
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2016-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]
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2016-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]
| From | "Jamal" <noooospam@example.com> |
|---|---|
| Date | 2016-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