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 6 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 2 of 2 — ← Prev page 1 [2]


#10074

FromJames Martin <james@northwoodlumber.com>
Date2016-12-15 15:11 -0500
Message-ID<o2utab$kou$1@dont-email.me>
In reply to#10073
That's right. The surprising thing is that it worked before, and the 
error messages did not give any help. The log file would have though, 
but I found it by isolating the code.

Thanks.

James

On 16-12-15 02:58 PM, Jamal wrote:
> 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]


#10075

FromD.J.W. van Kooten <vankooten@removethis.ic2.com>
Date2016-12-16 10:56 +0100
Message-ID<45e75c5grcs1v9kctvb28uq4iips1k5el1@4ax.com>
In reply to#10074
Replying on message of Thu, 15 Dec 2016 15:11:14 -0500 from James
Martin:


 Hello James,

>That's right. The surprising thing is that it worked before, and the 
>error messages did not give any help. The log file would have though, 
>but I found it by isolating the code.

Good it works now. Why it worked with the same space before remains a
mystery. One thinks "Windows updates". I disable all Windowsupdates
until I have some time, once every few months, to solve problems which
usually start afte rsuch an update. But this week I suddenly found my
audio output slowed down and distorted. After some trial & error I
deleted both audio drivers from Configuration/Devices which were
reinstalled on a Windows restart. No idea what could have happened in
between. Only deinstalled one Visual Studio component.

For the record: error 21 can also occur when you have ADS open and the
file is also opened with DBFCDX access. Further it can happen with a
damaged file. Usually a memofield, but it can also happen if you
create a file using older Excel versions with an unallowed or double
fieldname in it (apparently Excel doesn 't check for that). The file
seems created but doesn't open, and sometimes with error 21.

Dick

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


#10076

FromKuno Egger <kuno@retailsoftware.com>
Date2016-12-16 16:15 -0800
Message-ID<a7377eea-87aa-4eeb-9eef-4c4f0b3cb2ba@googlegroups.com>
In reply to#10042
I get error 21 on a network if I try to access data using a file path containing a network alias name instead of a mapped drive:

Wrong: \\Host_PC_network_name\\C\\Folder_name\Filename

Right: Z:\Folder_name\Filename

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


#10077

From"Jamal" <nospam@example.com>
Date2016-12-16 23:59 -0500
Message-ID<o32gni$11r3$1@gioia.aioe.org>
In reply to#10076
Incorrect!! You mean UNC and it works fine in all versions of Windows.

Usually you would have:  \\Host_PC_network_name\Folder_name\Filename
I do not know how got the wrong path. Did you type it in manually?


The easiest method to the UNC path is via StandardFolderDialog{} class. Here 
is a quick example:

LOCAL oStandardFolderDialog := StandardFolderDialog{SELF, "Choose Folder"} 
AS StandardFolderDialog

    oStandardFolderDialog:Show()

    IF !Empty(oStandardFolderDialog:FolderName)
        infoBox{,"", oStandardFolderDialog:FolderName}:Show()
    ENDIF

Jamal


"Kuno Egger"  wrote in message 
news:a7377eea-87aa-4eeb-9eef-4c4f0b3cb2ba@googlegroups.com...

I get error 21 on a network if I try to access data using a file path 
containing a network alias name instead of a mapped drive:

Wrong: \\Host_PC_network_name\\C\\Folder_name\Filename

Right: Z:\Folder_name\Filename 

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


#10081

FromD.J.W. van Kooten <vankooten@removethis.ic2.com>
Date2016-12-18 18:03 +0100
Message-ID<8agd5c13vrkoo9tck5h0122ukug46habv9@4ax.com>
In reply to#10076
Replying on message of Fri, 16 Dec 2016 16:15:10 -0800 (PST) from Kuno
Egger:


 Hello Kuno,

This is what Phil replied to me on a similair question on July 17th:


>I open DBSERVER to UNC paths fine..
>
>SetDefault('\\2012-pdc\zz_DATA\')   
>
>oDB := DBSERVER{"mydata"}
>

Dick

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


#10083

Fromdlzc <dlzc1@cox.net>
Date2016-12-18 10:26 -0800
Message-ID<38f5d6a6-c753-43f0-87a5-7ffbeae08458@googlegroups.com>
In reply to#10076
Dear Kuno Egger:

On Friday, December 16, 2016 at 5:15:11 PM UTC-7, Kuno Egger wrote:
> I get error 21 on a network if I try to access
> data using a file path containing a network
> alias name instead of a mapped drive:
> 
> Wrong: \\Host_PC_network_name\\C\\Folder_name\Filename
> 
> Right: Z:\Folder_name\Filename

There is an error in the UNC path name above
\\Host_PC_network_name\C\Folder_name\Filename
... assuming the "shared name" of the drive is "C"

I have encountered an error accessing peer-to-peer shared network resources, if the problem machine had a valid Micro$haft account connection (almost required when installing Windoze 10 the first time, but less so that previous versions... opt out is more obvious).

I wonder if access of "drive letter mapped" connections is still faster than UNC mapped connections, for directory and file creations?

David A. Smith

[toc] | [prev] | [standalone]


Page 2 of 2 — ← Prev page 1 [2]

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


csiph-web