><...clip>
>
>>
>>Don,
>>Viv's suggestion works. I still prefer parameters but it works:)
>>

>>< %
>>    cSQLSelect = "Select * from customer where country = m.mCountry"
>>
>>    set oConnection = Server.CreateObject( "adodb.connection" )
>>    with oConnection
>>    	.ConnectionString = "Provider=VFPOLEDB;" & _
>>        "Data source=C:\Program Files\Microsoft Visual FoxPro 9\Samples\Data\TestData.dbc"
>>       .Errors.Clear	
>>       .Open
>>    end with
>>
>>  set oCmd = Server.Createobject("Adodb.command")
>>  oConnection.Execute("EXEC 'public mCountry'+chr(13)+chr(10)+'mCountry=[USA]'")
>>  with oCmd
>>  .ActiveConnection = oConnection
>>  .CommandText = cSQLSelect
>>
>>' Stored procedure with parameters
>>'  .CommandText = "MyStoredProcedure"
>>'  .CommandType = 4
>>' stored procedure
>>
>>'  set p0 = .CreateParameter("employee", 129,1,,"MyEmployee")
>>'  set p1 = .CreateParameter("fdate", 7, 1,,#2004/11/22#)
>>'  set p2 = .CreateParameter("ldate", 7, 1,,#2004/11/23#)
>>
>>'  .Parameters.Append(p0)
>>'  .Parameters.Append(p1)
>>'  .Parameters.Append(p2)
>>
>>  set rs = .Execute()
>>  end with
>>
>>    ' Check results
>>    Response.Write("<TABLE border='1'><TR><TH>Cust ID</TH><TH>Company</TH><TH>Contact</TH><TH>Country</TH></TR>" )
>>    while not rs.eof
>>            Response.Write("<TR>")
>>            Response.Write("<TD>" & rs.Fields("cust_id").value & "</TD>")
>>            Response.Write("<TD>" & rs.Fields("company").value & "</TD>")
>>            Response.Write("<TD>" & rs.Fields("contact").value & "</TD>")
>>            Response.Write("<TD>" & rs.Fields("country").value & "</TD>")
>>            Response.Write("</TR>")
>>            rs.MoveNext
>>    wend
>>    Response.Write("</TABLE><BR/>")
>>	
>>    oConnection.Close
>>    set oConnection = nothing
>>% >
>>

Cetin
>
>Cetin - Can you help me with a connection string that works with VFPOLEDB in .NET? I have been trying to establish a connection using
>

><connectionStrings>
>        <remove name="VFPLibrary" />
>        <add name="VFPLibrary" connectionString="Provider=VFPOLEDB.1;Data Source=|DataDirectory|library.dbc" providerName="System.Data.OleDb"/>
>            </connectionStrings>
>

>which works for my Formview and Grid view pages but will not work in code. I'd sure appreciate some help with this one I've been struggling with it for 2 weeks.
>Thanks


"Provider=VFPOLEDB;Data Source=c:\myDataFolder\library.dbc"

If it is C# then use \\ in path string or prefix the string with @.
Cetin