>I believe if you are going to use a SELECT statement with a recordset object you want to instead do:
>
>set rst1 = CreateObject("ADODB.Recordset")
>
>and then
>
>rst1.Open "SELECT DISTINCT cname FROM agencycodes", oConn
>
>If you ar usn an Execute method then you don't even need the recordset object. However, because you are using a SELECT query you will want to use a recordset.

Jason
I assume you mean to change the code as follows:
set rs1 = CreateObject("ADODB.Recordset")
Rs1.Open("select distinct cname from agencycodes",oConn)

Regardles, my problem is the connection.
Do I need to define the provider?
I have mdac2.5 installed and are using VFP 6.0, is that an issue?