I'm not sure about pointing it to an FTP site, but you definately don't want to use a DSN. A DSN is used by ODBC connections. If you specify a DSN in your ADO connection string, the data will go through ODBC, then through ADO/OLEDB, and finally to your application.


>Hi everyone!
>
>Ok, it's been awhile since I've done this and I was wondering if anyone could give me a shove in the right direction.
>
>I'm trying to use ADO to access a VFP database on a webserver (FTP site). I've done this in the past but not with XP and it's been a few years.
>
>I've downloaded the VFP8OLEDB and installed it as per instructions. I tested it with the following code:
>
>

>** Create ADO object
>oCon = createobject("adodb.Connection")
>oCon.ConnectionString = [Provider=VFPOLEDB.1;Data Source=c:\test;] + ;
>   [Mode=ReadWrite|Share Deny None;Password="";Collating Sequence=MACHINE]
>oCon.open
>oRs = createobject("adodb.recordset")
>oRs.ActiveConnection = oCon
>oRs.open("Select * FROM request")
>

>
>This works fine and I can see the data in the recordset. Ok, now how do I point the connection to an FTP site I have set up? I thought I had to set up a DSN but I don't see the new driver in my data sources. I've done this before using SQL tables (where I set up a DSN using the SQL driver) for the backend but not VFP tables.
>
>I've also read John's jumpstart article (again) but was wondering if it's still applicable to vfp8 driver stuff since he wrote it in 1999. Is ADO even still the way to go to access backend stuff on a webserver?
>
>I know this is all ADO 101 but I sure would appreciate any input.
>
>Thanks!