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

I've always used DSNs for Foxpro. The connection string is then just the DNS name.....

Conn="DSN=dsn_name"

Tim

Able Consulting - ADO Connection String Samples
http://www.able-consulting.com/ADO_Conn.htm