Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
File not a table???
Message
 
 
To
11/10/2007 18:08:52
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
01260437
Message ID:
01260438
Views:
14
>I have just moved my web app from my development PC (where it works fine) to our public web server. It seems to work fine there with 1 exception. There are 2 table files in the app that it will not open. I get an error that says:
>
>Microsoft OLE DB Provider for Visual FoxPro error '80004005'
>Not a table.
>/tip/login/tippages/rtapage5.asp, line 189
>
>Line 189 is the line that opens the file:
>
>< %
>sql = "select * from rta_payments where tip_id = " & lcTIP_id & " order by pmtfrom desc"
>Set oRTA_Payments = oConn.Execute(sql)
>% >
>
>
>The files in question are contained in the database and both forward and backlinks seem to be OK. File permissions also seem to be OK. There are no unusual field types in either of the 2 files, just CILD. I have run validate database and it says everything is OK. The other tables seem to open and work OK.
>
>Any thoughts on what to look for next?

Hard to say, but did you try to select just one field from this table? Just for the test.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform