Objects for OLE2 - Can't create temp file?

From: Bryan Dollery <Bryan_at_Bryan.prestel.co.uk>
Date: 1997/04/05
Message-ID: <33466960.1D79_at_Bryan.prestel.co.uk>#1/1


Hi,

I'm using he Oracle Data Control under VB4 to query a table containing only 2k of data (SELECT * FROM products - no where clause. 10 columns, all VARCHAR2(20), 10 records), and display the results in an Apex TrueDB Grid.

I'm getting the message "Can't create temp file" from

	Oracle Objects for OLE 2
	Visual Basic 4 - 16 Bit.
	Windows 3.1
	Novell Netware 4.1
	38MB free HD space.
	All of the oracle stuff came of the 7.3.2 CD and was
	installed onto a clean pc.

I've checked for dead temp files, and have deleted them. I have enough disk space for the tempory files (which are used to store the query data for backwards scrolling purposes). I have set FILES=200 under DOS.
I have only one application, other than the program manager, open, and that is VB4.
I have only one form in my VB app. The one that gives me this error. I have only around 2KB of data to retrieve from the table.

I don't get the same error when processing the query programatically, using Oracle's session, database and dynaset objects. I have checked that the coded version of this form uses a back-scrollable dataset.

If anyone has any ideas please let me know?

Thanx in advance.

Bryan

-- 
Bryan Dollery BSc(Hons)
ByteSmart Systems Ltd.
Received on Sat Apr 05 1997 - 00:00:00 CEST

Original text of this message