>I'm having all kinds of trouble figuring out how to install and find a basic ASP script to talk to VFP data from ASP.
>
>here is my ASP code I'm trying to use:
>
>lcSelectClause = "SELECT Dname from dealer"
>CrownDBC_ConnectionString = "Provider=VFPOLEDB.1;Data Source=i:\crown01\crownweb.dbc"
> CrownDBC_ConnectionTimeout = 15
> CrownDBC_CommandTimeout = 30
> CrownDBC_CursorLocation = 3
> CrownDBC_RuntimeUserName = ""
> CrownDBC_RuntimePassword = ""
> Set MyConn = Server.CreateObject("ADODB.Connection")
> MyConn.ConnectionTimeout = CrownDBC_ConnectionTimeout
> MyConn.CommandTimeout = CrownDBC_CommandTimeout
> MyConn.Open CrownDBC_ConnectionString, CrownDBC_RuntimeUserName, CrownDBC_RuntimePassword
>
> Set cmdTemp = Server.CreateObject("ADODB.Command")
> Set dataset = Server.CreateObject("ADODB.Recordset")
> cmdTemp.CommandText = lcSelectClause
> cmdTemp.CommandType = 1
> Set cmdTemp.ActiveConnection = MyConn
> dataset.Open cmdTemp, , 1, 3
>
>I'm getting an error on the "Set CmTemp.ActiveConnection = MyConn". I assume this means that the vfpoledb provider is available or it would have errored on the MyConn.Open command.
>
>
>I've used this ADO structure with ODBC for about five years now without any problems so it's kind of rough now going back in and trying to do it a new way.
>
>Any help is MUCH appreciated!
Remove set.
cmdTemp.ActiveConnection = MyConn
Cetin