VFP ODBC Problem - Unable to create temporary work files
From: Phil Hollingworth (phil_at_wrltd.co.uk)
Date: 03/10/04
- Next message: Tian Min Huang: "Re: MS SQL Server 2000 ODBC driver crash"
- Previous message: GTi: "SQLConnect + threads"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 10 Mar 2004 16:20:01 -0000
Hi
I have a real problem with our website and I have run out of ideas on how to
fix it.
Several of our existing ASP pages (which have not been changed for 4+
months) stopped working recently.
Our ISP has assured as that nothing major has changed with the web server
and none of the other clients have reported problems (I don't know if anyone
else uses VFP on the server).
This is the message I am getting:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Visual FoxPro Driver]Unable to create temporary work files.
/test2004/resultpage.asp, line 114
The really annoying thing is that these pages work fine on our development
server.
The first thing that occured to me was that perhaps they have an old ODBC
driver (not that I can see what that would cause previously working pages to
stop). The latest version I can find on the MS site is 6.01.8629 which is
the version they have installed. Bizarely, our server claims to have
6.01.8630 and I can't find any reference to that version anywhere on Google.
The next thought to occur was that maybe our disk quota was full - this
apparantly is not the case.
After some searching on Google I found this link -
http://dbforums.com/t821735.html - which suggested that the IUSR account
might not have write access to c:\winnt\temp - however it would seem that
the account does have read/write access.
As far as I am aware, the ODBC driver ignores the vast majority of SET
commands so there is no easy way for me to ensure that c:\winnt\temp is
where it places it's temp files but I assume that that is where they go.
So I am at a bit of a loss really.
The other thing that does not work properly on the ISP's server but that
does work on our development server is creating anything other than a
forward-only record set. This is the error I get:
---------
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.
/test2004/resultpage.asp, line 86
----------
The code that creates this is:
----------
SQL = "sele * from table"
set newRS = server.createobject("adodb.recordset")
newRS.open SQL,conn,1
- Next message: Tian Min Huang: "Re: MS SQL Server 2000 ODBC driver crash"
- Previous message: GTi: "SQLConnect + threads"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
