Re: VFP and DSN questions



On 23 Mar, 20:58, Jim <a...@xxxxxxxxxxxxxxxxxxxx> wrote:
I'm new to PHP and I'm trying to convert some of my ASP pages to see how it
works. So far I can't find a clear answer to this:
What do I have to do to query FoxPro tables?
Do I have to use DSN? (I currently don't)
Should I use ODBC or OLEdb?
Do I use COM/ADO?
Which connection string?
The examples I've found so far aren't very helpful (and sometimes contradict)
and tend to use Access, MSSQL, or MySQL for examples not VFP.


You could do any of the above. But ODBC will be the simplest.

The DSN is a specific configuration of the ODBC layer (defines whatr
database it connects to) and once configured you can test the
connection using Access/Excel/Whatever.

C.
.



Relevant Pages

  • Re: Create DSN Programmatically
    ... Referring to the connection string as a Data ... > Source Name (DSN) is a naming convention used to refer to the connection ... Only in the case of ODBC API ...
    (microsoft.public.vsnet.general)
  • Re: Vista Migration
    ... Pretty sure I have the necessary rights, although with Vista you can't ... If specifically using a DSN (ODBC ... configuration first in order to test the intalled components and ODBC ...
    (microsoft.public.vb.database)
  • Re: How do I add option ZERO_DATE_TO_MIN in mysql connector?
    ... With a DSN-less connection string I could specify it with adding ... prompt a dialog to allow users to select a DSN at runtime. ... A way to specify above option somehow in the mysql ODBC dialog ...
    (microsoft.public.data.odbc)
  • Re: How do I add option ZERO_DATE_TO_MIN in mysql connector?
    ... > For 1, it seems that you can set the value in the "Option" textbox in> GUI, if you are using Windows platform. ... I guess this will override any options set by the checkboxes in the DSN construction dialog so it might be dangerous. ... May be you know a way to get the DSN-less connection string from a DSN? ... ODBC DM will then prompt a dialog to allow users to select a DSN at runtime. ...
    (microsoft.public.data.odbc)
  • Re: DSN-less connection for Informix database
    ... Pervasive ODBC client Interface ... ... on is having to SETUP an odbc connection profile .. ... what I did was created an ODBC System DSN ... ... in your connection string, replace the DNS=jaco ... ...
    (microsoft.public.dotnet.languages.vb)