>>< % >>Set oConn = Server.CreateObject("ADODB.Connection") >>ConnStr = "Driver=Microsoft Visual Foxpro Driver; UID=userID;SourceType=DBC;SourceDB=c:\inetpub\wwwroot\tip\login\data\tipdatabase.dbc" >>oConn.Open ConnStr >> >>sql = "select * from rta_basedata where tip_id = " & lcTIP_id >>Set oRTA_Basedata = oConn.Execute(sql) >>% > >>>>The following code produces an error
>>< % >>sql = "select * from rta_payments where tip_id = " & lcTIP_id >>Set oRTA_Payments = oConn.Execute(sql) >>% > >> >>Error Type: >>Microsoft OLE DB Provider for ODBC Drivers (0x80040E37) >>[Microsoft][ODBC Visual FoxPro Driver]Not a table. >>/tip/rtapage5.asp, line 41 >>>>