Reading Access in VFP

2008-11-22 Thread Geoff Flight
Hi all, I have need to read some Access tables in a small VFP app. I originally used a DSN and all worked fine until I tried to install it at the client and they needed IT permission to set up a DSN on the workstation. Their service model is based on Dilbert's 'Mordac - Preventer of Information

Re: Reading Access in VFP

2008-11-22 Thread MB Software Solutions General Account
Geoff Flight wrote: good dilbert story snipped I would like to read the access tables using the SQLSTRINGCONNECT function, however getting a connection string to work has eluded me. Being a relative newbie to doing such things I wonder if some of you kind folk can point me in the direction of

Re: Reading Access in VFP

2008-11-22 Thread Ricardo Aráoz
Geoff Flight wrote: Hi all, I have need to read some Access tables in a small VFP app. I originally used a DSN and all worked fine until I tried to install it at the client and they needed IT permission to set up a DSN on the workstation. Their service model is based on Dilbert's 'Mordac -

RE: Reading Access in VFP

2008-11-22 Thread Geoff Flight
List Subject: Re: Reading Access in VFP Geoff Flight wrote: good dilbert story snipped I would like to read the access tables using the SQLSTRINGCONNECT function, however getting a connection string to work has eluded me. Being a relative newbie to doing such things I wonder if some of you kind

RE: Reading Access in VFP

2008-11-22 Thread John C. Gunvaldson
I wonder if some of you kind folk can point me in the direction of a solution that does not include a DSN and help me construct a elegant, working connection string. This is one that has been passed around on this newsgroup before - that I bookmarked... /*== LOCAL lcConnectString as

Re: Reading Access in VFP

2008-11-22 Thread Paul McNett
Geoff Flight wrote: I would like to read the access tables using the SQLSTRINGCONNECT function, however getting a connection string to work has eluded me. Being a relative newbie to doing such things I wonder if some of you kind folk can point me in the direction of a solution that does not

RE: Reading Access in VFP

2008-11-22 Thread Geoff Flight
November 2008 10:10 AM To: profox@leafe.com Subject: Re: Reading Access in VFP Geoff Flight wrote: I would like to read the access tables using the SQLSTRINGCONNECT function, however getting a connection string to work has eluded me. Being a relative newbie to doing such things I wonder if some of you