>>< % >> 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
><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.