Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    1

    Unanswered: connecting fox pro 2.6 with asp

    From an asp file i'd like to know the connexion string to access a fox pro data base. Here is the way i begin the code:

    <%@ LANGUAGE='JScript'%>
    <%
    var filePath;
    filePath = Server.MapPath("nom du fichier.dbf");
    var connexion = Server.createobject("ADODB.Connection");
    var connectString ="CONNEXION STRING FOR FOX PRO ???
    +filePath;
    connexion.open(connectString);

    var resultatSQL = Server.CreateObject("ADODB.RecordSet");

    var requete = "requête sql";

    resultatSQL.Open(requete, connexion);

    Is it better to use a DSN,ODBC or an OLE DB connexion ??

    Thanks

  2. #2
    Join Date
    Mar 2003
    Location
    Atlanta, GA
    Posts
    191
    I've always used DSNs for Foxpro. The connection string is then just the DNS name.....

    Conn="DSN=dsn_name"

    Tim
    Tim

  3. #3
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Able Consulting - ADO Connection String Samples
    http://www.able-consulting.com/ADO_Conn.htm
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •