>><...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
Got it! Thanks