Re: Cannot execute a program on xp

[Jerry Wolper]

> This is not regarding vfp

For the record, that's what the [NF] tag in subject lines is for.

-Jerry

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/554a5eb1.24983.1bf...@jwolper.swanzoco.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Delay in USEing table on network causes errors, using VMs, Win7

[Fernando D. Bozzo]

If you are going to use network shares for the tables, just be care with
the combination of client OS and server OS, because any combination
starting with Win7->Win7 or higher, will cause corruption problems. That's
why everytime more people is staying away from DBFs and migrate to a
client-server database (MySql, MariaDB, Oracle, SqlServer, etc)


Regards.-


2015-05-06 20:21 GMT+02:00 Ted Roche :

> We CAN, and we'll give that a try (once the client's done working for
> the day, and the problem likely to re-appear), we just HADN'T up until
> now. On a couple dozen installs. Over a decade running.
>
>


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_june1fz8o1s93wmtyhc78dak0htwo96ddz1hrnhnheg...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Delay in USEing table on network causes errors, using VMs, Win7

[Kurt Wendt]

Jeff - your comment sounded a little like what I was thinking. Although, I 
failed to reply to this thread with my thoughts previously.

I figured, in VFP you could do the RUN command - and run a DOS Command. Let's 
say - the DOS Command simply generates a DIR listing - that gets piped to a 
Text file. The DIR command would list the files in a Folder on the Network 
drive that you are trying to access - but, places that piped Text file listing 
on the local drive. Then, the VFP program simply checks that the Text file is 
there - it can Delete it in prep for next time - but, now knows it can access 
the Network file without a problem.

Just a thought...

-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson
Sent: Wednesday, May 06, 2015 2:43 PM
To: profoxt...@leafe.com
Subject: Re: Delay in USEing table on network causes errors, using VMs, Win7

I've been plagued by this with many customers.  I put a short cut on the 
desktop that points to a file on the mapped drive.  The user clicks on the 
short cut and it connects to the mapped drive and opens up.
After that they are good to go.  If the click on the short drive and it can't 
connect for any other reason it will throw an error.

I am going to try the below solution.  Makes sense.  I have three registry 
entries I need to add to every new application as it is. They are regarding 
oplocks.



On 5/6/2015 11:21 AM, Ted Roche wrote:
> We CAN, and we'll give that a try (once the client's done working for 
> the day, and the problem likely to re-appear), we just HADN'T up until 
> now. On a couple dozen installs. Over a decade running.
>
> On Wed, May 6, 2015 at 11:48 AM, Alan Bourke  wrote:
>> Can you use a UNC path? I don't see why you'd need a drive letter at 
>> all unless it's (ulp!) hardcoded.
>>
>> What OS is the VM?
>>
>> If you have to use a drive letter, maybe this:
>> http://jacobthegeek.com/windows-7-mapped-drive-shows-red-x-until-sele
>> cted/
>>
>> --
>>Alan Bourke
>>alanpbourke (at) fastmail (dot) fm
>>
>>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f1b6...@drexch02.corp.globetax.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Delay in USEing table on network causes errors, using VMs, Win7

[Jeff Johnson]

I've been plagued by this with many customers.  I put a short cut on the 
desktop that points to a file on the mapped drive.  The user clicks on 
the short cut and it connects to the mapped drive and opens up.
After that they are good to go.  If the click on the short drive and it 
can't connect for any other reason it will throw an error.


I am going to try the below solution.  Makes sense.  I have three 
registry entries I need to add to every new application as it is. They 
are regarding oplocks.




On 5/6/2015 11:21 AM, Ted Roche wrote:

We CAN, and we'll give that a try (once the client's done working for
the day, and the problem likely to re-appear), we just HADN'T up until
now. On a couple dozen installs. Over a decade running.

On Wed, May 6, 2015 at 11:48 AM, Alan Bourke  wrote:

Can you use a UNC path? I don't see why you'd need a drive letter at all
unless it's (ulp!) hardcoded.

What OS is the VM?

If you have to use a drive letter, maybe this:
http://jacobthegeek.com/windows-7-mapped-drive-shows-red-x-until-selected/

--
   Alan Bourke
   alanpbourke (at) fastmail (dot) fm



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/554a60b0.2020...@san-dc.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Delay in USEing table on network causes errors, using VMs, Win7

[Ted Roche]

We CAN, and we'll give that a try (once the client's done working for
the day, and the problem likely to re-appear), we just HADN'T up until
now. On a couple dozen installs. Over a decade running.

On Wed, May 6, 2015 at 11:48 AM, Alan Bourke  wrote:
> Can you use a UNC path? I don't see why you'd need a drive letter at all
> unless it's (ulp!) hardcoded.
>
> What OS is the VM?
>
> If you have to use a drive letter, maybe this:
> http://jacobthegeek.com/windows-7-mapped-drive-shows-red-x-until-selected/
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CACW6n4vB+=-9_4v_gk21oiyptz4wh4ongdrgm9qzzjq-c1z...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: New project on VFPx: Bin 2 Text extension

[Dave Crozier]

Very interesting Jean Good find!

Dave

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jean Laeremans
Sent: 06 May 2015 16:25
To: ProFox Email List
Subject: Re: New project on VFPx: Bin 2 Text extension

This might be interesting.

http://www.tek-tips.com/viewthread.cfm?qid=1749215

A+
jml


--- StripMime Report -- processed MIME parts --- multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/18725b8cd2d5d247873a2baf401d4ab246b31...@ex2010-a-fpl.fpl.LOCAL
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Delay in USEing table on network causes errors, using VMs, Win7

[Alan Bourke]

Can you use a UNC path? I don't see why you'd need a drive letter at all
unless it's (ulp!) hardcoded.

What OS is the VM?

If you have to use a drive letter, maybe this:
http://jacobthegeek.com/windows-7-mapped-drive-shows-red-x-until-selected/

-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1430927320.4151109.263518333.68f50...@webmail.messagingengine.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: New project on VFPx: Bin 2 Text extension

[Fernando D. Bozzo]

Yeah, I've read it on Universal Thread and Foxite.

Is really interesting :)


2015-05-06 17:24 GMT+02:00 Jean Laeremans :

> This might be interesting.
>
> http://www.tek-tips.com/viewthread.cfm?qid=1749215
>
> A+
> jml
>
>


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jun4razyybrnvoedtfccpn4khof9vjudksbj3kymg9x...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: New project on VFPx: Bin 2 Text extension

[Fernando D. Bozzo]

Hi Kurt:

The first time I've searching on VFPx, I didn't find it easy to "read", but
over time I've accostumed to the site format.

For a fast "what's here?", I suggest reading the sinopsys of the proyects
on main page, wich are ordered by release type (final, RC, beta, alpha,
etc), have a little description of each project and a link to de dowload
and documentation (some projects have docs, some not)

As RK says, there are various interesting projects, beginning with Thor,
that makes installing and testing various projects more easy, because have
a VFP form interface with all projects on Thor from which you can read
something about each app, install it and update.

Regards!



2015-05-06 16:20 GMT+02:00 Kurt Wendt :

> Hey RK - yeah, I knew it was around for years. I heard about it at my
> prior fulltime VFP job - which was about 2 years ago. But, I was kinda lazy
> and didn't fully look into what it was really about. I agree - its sad that
> M$ hasn't released the VFP codebase to let it go open source. I wonder if
> ANY has ever tried pushing M$ to do so - especially since they recently
> open-sourced some .Net stuff.
>
> And - yes - my current job is doing VFP. Although - this co. is actively
> trying to migrate to VB/.Net as front end - and already has MS SQL as the
> back-end for most of the data - while there are a couple smaller files
> still running as VFP DBF files.
>
> But, yes, I may look around more on VFPx to see if there is something
> useful that we could use here!
>
> L8r,
> -K-
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Richard Kaye
> Sent: Wednesday, May 06, 2015 10:07 AM
> To: profoxt...@leafe.com
> Subject: RE: New project on VFPx: Bin 2 Text extension
>
> VFPx has been around for years, Kurt. Sadly, it has nothing to do with the
> core VFP engine being released open source. Happily, there are quite a few
> excellent tools, including Fernando's Foxbin2PRG, and I would highly
> recommend poking around there to look for items to add to your toolkit if
> you are still actively developing and supporting VFP applications.
>
> I use Thor, GoFish, VFP2C, ctl32 classes, etc.
>
> --
>
> rk
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt
> Wendt
> Sent: Wednesday, May 06, 2015 9:49 AM
> To: profoxt...@leafe.com
> Subject: RE: New project on VFPx: Bin 2 Text extension
>
> Fernando,
>
> Thanks for posting this. I had heard about VFPx before, but, wasn't sure
> what it was about. Since you posted that link, I followed it - and went to
> the Home page - to find that its about open-source add-ons to VFP9.
>
> I am curious. I know that M$ recently made certain things open-source,
> like some .Net! But - did they ever decide to release VFP open-source, so
> others could take over extending it? I suspect not - otherwise I probably
> would have already heard about that on HERE!
>
> Just wondering...
> -K-
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jukodpto4bphigdvp+kpnhjzwgx1iutncx6maw9_gym...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: New project on VFPx: Bin 2 Text extension

[Jean Laeremans]

This might be interesting.

http://www.tek-tips.com/viewthread.cfm?qid=1749215

A+
jml


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAPqLOByz8OAu=-tap+nzzeybny2charoapodvo0pxkmxvtd...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: New project on VFPx: Bin 2 Text extension

[Kurt Wendt]

Hey RK - yeah, I knew it was around for years. I heard about it at my prior 
fulltime VFP job - which was about 2 years ago. But, I was kinda lazy and 
didn't fully look into what it was really about. I agree - its sad that M$ 
hasn't released the VFP codebase to let it go open source. I wonder if ANY has 
ever tried pushing M$ to do so - especially since they recently open-sourced 
some .Net stuff. 

And - yes - my current job is doing VFP. Although - this co. is actively trying 
to migrate to VB/.Net as front end - and already has MS SQL as the back-end for 
most of the data - while there are a couple smaller files still running as VFP 
DBF files.

But, yes, I may look around more on VFPx to see if there is something useful 
that we could use here!

L8r,
-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Wednesday, May 06, 2015 10:07 AM
To: profoxt...@leafe.com
Subject: RE: New project on VFPx: Bin 2 Text extension

VFPx has been around for years, Kurt. Sadly, it has nothing to do with the core 
VFP engine being released open source. Happily, there are quite a few excellent 
tools, including Fernando's Foxbin2PRG, and I would highly recommend poking 
around there to look for items to add to your toolkit if you are still actively 
developing and supporting VFP applications.

I use Thor, GoFish, VFP2C, ctl32 classes, etc.

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt
Sent: Wednesday, May 06, 2015 9:49 AM
To: profoxt...@leafe.com
Subject: RE: New project on VFPx: Bin 2 Text extension

Fernando,

Thanks for posting this. I had heard about VFPx before, but, wasn't sure what 
it was about. Since you posted that link, I followed it - and went to the Home 
page - to find that its about open-source add-ons to VFP9.

I am curious. I know that M$ recently made certain things open-source, like 
some .Net! But - did they ever decide to release VFP open-source, so others 
could take over extending it? I suspect not - otherwise I probably would have 
already heard about that on HERE!

Just wondering...
-K-


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f1b6...@drexch02.corp.globetax.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: New project on VFPx: Bin 2 Text extension

[Richard Kaye]

VFPx has been around for years, Kurt. Sadly, it has nothing to do with the core 
VFP engine being released open source. Happily, there are quite a few excellent 
tools, including Fernando's Foxbin2PRG, and I would highly recommend poking 
around there to look for items to add to your toolkit if you are still actively 
developing and supporting VFP applications.

I use Thor, GoFish, VFP2C, ctl32 classes, etc.

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt
Sent: Wednesday, May 06, 2015 9:49 AM
To: profoxt...@leafe.com
Subject: RE: New project on VFPx: Bin 2 Text extension

Fernando,

Thanks for posting this. I had heard about VFPx before, but, wasn't sure what 
it was about. Since you posted that link, I followed it - and went to the Home 
page - to find that its about open-source add-ons to VFP9.

I am curious. I know that M$ recently made certain things open-source, like 
some .Net! But - did they ever decide to release VFP open-source, so others 
could take over extending it? I suspect not - otherwise I probably would have 
already heard about that on HERE!

Just wondering...
-K-


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/blupr10mb045157a5a8c893888e9d5e59d2...@blupr10mb0451.namprd10.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: New project on VFPx: Bin 2 Text extension

[Kurt Wendt]

Fernando,

Thanks for posting this. I had heard about VFPx before, but, wasn't sure what 
it was about. Since you posted that link, I followed it - and went to the Home 
page - to find that its about open-source add-ons to VFP9.

I am curious. I know that M$ recently made certain things open-source, like 
some .Net! But - did they ever decide to release VFP open-source, so others 
could take over extending it? I suspect not - otherwise I probably would have 
already heard about that on HERE!

Just wondering...
-K-


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Fernando D. 
Bozzo
Sent: Tuesday, May 05, 2015 6:23 PM
To: profoxt...@leafe.com
Subject: New project on VFPx: Bin 2 Text extension

The news by Rick Schummer:

https://vfpx.codeplex.com/discussions/636774


Regards.-


--- StripMime Report -- processed MIME parts --- multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f1b6...@drexch02.corp.globetax.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Delay in USEing table on network causes errors, using VMs, Win7

[Richard Kaye]

Of course, Ted beat me to it. 

I'm wondering if the VFP2C library, which has LLIO functions in it, might be 
more reliable than the VFP FILE function?

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Wednesday, May 06, 2015 9:24 AM
To: profoxt...@leafe.com
Subject: RE: Delay in USEing table on network causes errors, using VMs, Win7

There are registry settings that allow you to set the idle time for network 
resources on both servers and workstations, iirc. 



--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier
Sent: Wednesday, May 06, 2015 9:07 AM
To: profoxt...@leafe.com
Subject: RE: Delay in USEing table on network causes errors, using VMs, Win7

Ted,
I have had similar problems with mapped drives. Have you tried using the full 
unmapped name:

 Example:  \\server1\folder1\file1.dbf

With regards to the red X, once again you will find that these will all be 
mapped drives. It is as though windows temporarily forgets the mappings and 
goes into sleep mode.

Since using fully qualified paths we have had no problems.

Dave


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche
Sent: 06 May 2015 13:44
To: profox@leafe.com
Subject: Delay in USEing table on network causes errors, using VMs, Win7

Folks:

We have a small VFP exe that launches as a scheduled tasks, ZAPs a temp table, 
checks to see if a table on the network has records, performs some text 
manipulation, updates records and exits. Been working fine for decades on a 
number of sites.

One new network config on one client is throwing errors.

The exe is running on a VM within a larger server. The main server has the 
files it accesses, mapped as a U: drive.

The exe attempts to open a DBF exclusive, ZAP it and then do some processing 
that might populate it with records. It's run as part of a batch process that's 
initiated by a user RDP'ing into the machine.
It's failing. When we run the .exe manually from the file explorer, we get an 
error that "U:\Directory\tablename.dbf" can't be found. If we select , 
it attempts the ZAP and brings up a file locator dialog. If we navigate 
manually to the file (it correctly opens in U:\Directory\), select the 
Exclusive and Open it, the process runs successfully to completion.

Running the exe again at that point, and it will work fine without throwing an 
error! It's only on the first initiation.

We're thinking this is a problem with the U: drive mapping timing out and 
*something* being needed to get the connection to work.

We've tried a:

IF NOT FILE("U:\Directory\Tablename.dbf")
  wait timeout 30
ENDIF

and the error still happened the same way, so querying with FILE() doesn't seem 
to be enough to trigger the reconnection.

Walking through the process again, we noted a red "X" on the U: drive in the 
explorer. Clicking on it clears the red "X" and the process will work fine from 
there.

Does anyone know a programmatic way to clear the red "X" and re-establish the 
network connection? I was sure I'd see something in the mailing list archives 
on this, but my searches didn't turn up anything.


--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/blupr10mb0451d3f8d6d76c5456caa82cd2...@blupr10mb0451.namprd10.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Delay in USEing table on network causes errors, using VMs, Win7

[Richard Kaye]

There are registry settings that allow you to set the idle time for network 
resources on both servers and workstations, iirc. 



--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier
Sent: Wednesday, May 06, 2015 9:07 AM
To: profoxt...@leafe.com
Subject: RE: Delay in USEing table on network causes errors, using VMs, Win7

Ted,
I have had similar problems with mapped drives. Have you tried using the full 
unmapped name:

 Example:  \\server1\folder1\file1.dbf

With regards to the red X, once again you will find that these will all be 
mapped drives. It is as though windows temporarily forgets the mappings and 
goes into sleep mode.

Since using fully qualified paths we have had no problems.

Dave


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche
Sent: 06 May 2015 13:44
To: profox@leafe.com
Subject: Delay in USEing table on network causes errors, using VMs, Win7

Folks:

We have a small VFP exe that launches as a scheduled tasks, ZAPs a temp table, 
checks to see if a table on the network has records, performs some text 
manipulation, updates records and exits. Been working fine for decades on a 
number of sites.

One new network config on one client is throwing errors.

The exe is running on a VM within a larger server. The main server has the 
files it accesses, mapped as a U: drive.

The exe attempts to open a DBF exclusive, ZAP it and then do some processing 
that might populate it with records. It's run as part of a batch process that's 
initiated by a user RDP'ing into the machine.
It's failing. When we run the .exe manually from the file explorer, we get an 
error that "U:\Directory\tablename.dbf" can't be found. If we select , 
it attempts the ZAP and brings up a file locator dialog. If we navigate 
manually to the file (it correctly opens in U:\Directory\), select the 
Exclusive and Open it, the process runs successfully to completion.

Running the exe again at that point, and it will work fine without throwing an 
error! It's only on the first initiation.

We're thinking this is a problem with the U: drive mapping timing out and 
*something* being needed to get the connection to work.

We've tried a:

IF NOT FILE("U:\Directory\Tablename.dbf")
  wait timeout 30
ENDIF

and the error still happened the same way, so querying with FILE() doesn't seem 
to be enough to trigger the reconnection.

Walking through the process again, we noted a red "X" on the U: drive in the 
explorer. Clicking on it clears the red "X" and the process will work fine from 
there.

Does anyone know a programmatic way to clear the red "X" and re-establish the 
network connection? I was sure I'd see something in the mailing list archives 
on this, but my searches didn't turn up anything.


--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/blupr10mb0451957e1661abfaf6eea15ad2...@blupr10mb0451.namprd10.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Delay in USEing table on network causes errors, using VMs, Win7

[Fernando D. Bozzo]

Hi:

The problem is that when File Explorer shows the red X is because the
network share is really disconnected, so when you click on this drive then
right there it is reconnected, and that's why it works after that.

The solution is to check the connection status (you can query from CMD with
NET USE and will see a "disconnected") and if disconnected, reconnect again.

For doing this reconnection you can use CreateObject("WScript.Network") and
then use MapNetworkDrive method to reconnect the drives.

EnumNetworkDrives.count returns the number of networks shares, on which
every impair value es the drive letter and every pair value is the
corresponding share (there can be empty letters)

I'm not sure where in the registry are the mappings caches, to query this
and remap them automatically if not already connected.


Regards!



2015-05-06 15:06 GMT+02:00 Peter Cushing :

> On 06/05/2015 13:44, Ted Roche wrote:
>
>> Folks:
>>
>> 
>>
>> Walking through the process again, we noted a red "X" on the U: drive
>> in the explorer. Clicking on it clears the red "X" and the process
>> will work fine from there.
>>
>> Does anyone know a programmatic way to clear the red "X" and
>> re-establish the network connection? I was sure I'd see something in
>> the mailing list archives on this, but my searches didn't turn up
>> anything.
>>
>>  I sometimes get this when I boot and my drive M will show a red X on it
> but if you double click it works.  It seems to only happen on my laptop
> after I have used it at home then return to the office.
> Just restarted now and link is still ok.
> How was the drive originally mapped?  If it was from a command prompt was
> /persistent:yes used?
> Just a WAG but has the machine got any power saving turned on and maybe it
> forgets the drive if it falls asleep.
> What happens if you try to use STRTOFILE to the U drive in this state?
>
> Peter
>
>


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jun45cbpozngmjfisetjnejkacwzqneqftgztfnok70...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Delay in USEing table on network causes errors, using VMs, Win7

[Ted Roche]

A bit more info: the client is several states remote and has a
separate outsourced IT group that manages the PCs, the network, all
that messy stuff. We just have to cope with what they do :)

Good ideas on the mapped drives as UNCs and/or trying the STRTOFILE() thing.

I think the timeout thing is a "feature" whereby a server can support
more "connected" clients by timing out idle ones:

https://support.microsoft.com/en-us/kb/297684

The issue for us isn't so much that the connection times out, as that
it is so slow to reconnect that VFP gives up on opening the DBF.

I'm wondering if there might be some RETRY, SET REPROCESS or SYS(3052)
style config in VFP that would affect this.



On Wed, May 6, 2015 at 8:44 AM, Ted Roche  wrote:
> Folks:
>
> We have a small VFP exe that launches as a scheduled tasks, ZAPs a
> temp table, checks to see if a table on the network has records,
> performs some text manipulation, updates records and exits. Been
> working fine for decades on a number of sites.
>
> One new network config on one client is throwing errors.
>
> The exe is running on a VM within a larger server. The main server has
> the files it accesses, mapped as a U: drive.
>
> The exe attempts to open a DBF exclusive, ZAP it and then do some
> processing that might populate it with records. It's run as part of a
> batch process that's initiated by a user RDP'ing into the machine.
> It's failing. When we run the .exe manually from the file explorer, we
> get an error that "U:\Directory\tablename.dbf" can't be found. If we
> select , it attempts the ZAP and brings up a file locator
> dialog. If we navigate manually to the file (it correctly opens in
> U:\Directory\), select the Exclusive and Open it, the process runs
> successfully to completion.
>
> Running the exe again at that point, and it will work fine without
> throwing an error! It's only on the first initiation.
>
> We're thinking this is a problem with the U: drive mapping timing out
> and *something* being needed to get the connection to work.
>
> We've tried a:
>
> IF NOT FILE("U:\Directory\Tablename.dbf")
>   wait timeout 30
> ENDIF
>
> and the error still happened the same way, so querying with FILE()
> doesn't seem to be enough to trigger the reconnection.
>
> Walking through the process again, we noted a red "X" on the U: drive
> in the explorer. Clicking on it clears the red "X" and the process
> will work fine from there.
>
> Does anyone know a programmatic way to clear the red "X" and
> re-establish the network connection? I was sure I'd see something in
> the mailing list archives on this, but my searches didn't turn up
> anything.
>
>
> --
> Ted Roche
> Ted Roche & Associates, LLC
> http://www.tedroche.com



-- 
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CACW6n4vPfg=uix7--rzo9blhaprebd4gaopa+ecqghzcboh...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Delay in USEing table on network causes errors, using VMs, Win7

[Dave Crozier]

Ted,
I have had similar problems with mapped drives. Have you tried using the full 
unmapped name:

 Example:  \\server1\folder1\file1.dbf

With regards to the red X, once again you will find that these will all be 
mapped drives. It is as though windows temporarily forgets the mappings and 
goes into sleep mode.

Since using fully qualified paths we have had no problems.

Dave


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche
Sent: 06 May 2015 13:44
To: profox@leafe.com
Subject: Delay in USEing table on network causes errors, using VMs, Win7

Folks:

We have a small VFP exe that launches as a scheduled tasks, ZAPs a temp table, 
checks to see if a table on the network has records, performs some text 
manipulation, updates records and exits. Been working fine for decades on a 
number of sites.

One new network config on one client is throwing errors.

The exe is running on a VM within a larger server. The main server has the 
files it accesses, mapped as a U: drive.

The exe attempts to open a DBF exclusive, ZAP it and then do some processing 
that might populate it with records. It's run as part of a batch process that's 
initiated by a user RDP'ing into the machine.
It's failing. When we run the .exe manually from the file explorer, we get an 
error that "U:\Directory\tablename.dbf" can't be found. If we select , 
it attempts the ZAP and brings up a file locator dialog. If we navigate 
manually to the file (it correctly opens in U:\Directory\), select the 
Exclusive and Open it, the process runs successfully to completion.

Running the exe again at that point, and it will work fine without throwing an 
error! It's only on the first initiation.

We're thinking this is a problem with the U: drive mapping timing out and 
*something* being needed to get the connection to work.

We've tried a:

IF NOT FILE("U:\Directory\Tablename.dbf")
  wait timeout 30
ENDIF

and the error still happened the same way, so querying with FILE() doesn't seem 
to be enough to trigger the reconnection.

Walking through the process again, we noted a red "X" on the U: drive in the 
explorer. Clicking on it clears the red "X" and the process will work fine from 
there.

Does anyone know a programmatic way to clear the red "X" and re-establish the 
network connection? I was sure I'd see something in the mailing list archives 
on this, but my searches didn't turn up anything.


--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/18725b8cd2d5d247873a2baf401d4ab246b31...@ex2010-a-fpl.fpl.LOCAL
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Delay in USEing table on network causes errors, using VMs, Win7

[Peter Cushing]

On 06/05/2015 13:44, Ted Roche wrote:

Folks:



Walking through the process again, we noted a red "X" on the U: drive
in the explorer. Clicking on it clears the red "X" and the process
will work fine from there.

Does anyone know a programmatic way to clear the red "X" and
re-establish the network connection? I was sure I'd see something in
the mailing list archives on this, but my searches didn't turn up
anything.

I sometimes get this when I boot and my drive M will show a red X on it 
but if you double click it works.  It seems to only happen on my laptop 
after I have used it at home then return to the office.

Just restarted now and link is still ok.
How was the drive originally mapped?  If it was from a command prompt 
was /persistent:yes used?
Just a WAG but has the machine got any power saving turned on and maybe 
it forgets the drive if it falls asleep.

What happens if you try to use STRTOFILE to the U drive in this state?

Peter







This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. 


www.whisperingsmith.com

Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. 
Tel:0161 831 3700 
Fax:0161 831 3715 


London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/554a11d5.2010...@whisperingsmith.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Delay in USEing table on network causes errors, using VMs, Win7

[Ted Roche]

Folks:

We have a small VFP exe that launches as a scheduled tasks, ZAPs a
temp table, checks to see if a table on the network has records,
performs some text manipulation, updates records and exits. Been
working fine for decades on a number of sites.

One new network config on one client is throwing errors.

The exe is running on a VM within a larger server. The main server has
the files it accesses, mapped as a U: drive.

The exe attempts to open a DBF exclusive, ZAP it and then do some
processing that might populate it with records. It's run as part of a
batch process that's initiated by a user RDP'ing into the machine.
It's failing. When we run the .exe manually from the file explorer, we
get an error that "U:\Directory\tablename.dbf" can't be found. If we
select , it attempts the ZAP and brings up a file locator
dialog. If we navigate manually to the file (it correctly opens in
U:\Directory\), select the Exclusive and Open it, the process runs
successfully to completion.

Running the exe again at that point, and it will work fine without
throwing an error! It's only on the first initiation.

We're thinking this is a problem with the U: drive mapping timing out
and *something* being needed to get the connection to work.

We've tried a:

IF NOT FILE("U:\Directory\Tablename.dbf")
  wait timeout 30
ENDIF

and the error still happened the same way, so querying with FILE()
doesn't seem to be enough to trigger the reconnection.

Walking through the process again, we noted a red "X" on the U: drive
in the explorer. Clicking on it clears the red "X" and the process
will work fine from there.

Does anyone know a programmatic way to clear the red "X" and
re-establish the network connection? I was sure I'd see something in
the mailing list archives on this, but my searches didn't turn up
anything.


-- 
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cacw6n4t+0fzxp3eo9eushtdobxqotuk0glfym__1mmsx0z2...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.