We are putting together an ASP front-end using ADO and would like to access our VFP DBC for inquery and eventually updates using a DSNless connection.
The same functions are being performed on our SQL Server applications using:
myDSN="PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER="&Application("SQLServerName")&";DATABASE="&Application("DBName")&";UID="&Application("DBUsername")&";PWD="&Application("DBPassword")&";"
Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.Open myDSN
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open strQuery,DataConn,1,3
%>
I have looked thru this site and some others and can't seem to find the syntax to modify the myDSN and rs.Open lines and any war stories to say DO or Don't do it......
Thanks in advance for the help!
Dave
************************************
Dave Kern
VP Software Development
Droege Computing Services, Inc.
Durham, NC 27705
dkern@droegecomputing.com************************************