E-FAIL Error

[rnathan]

Hi

I am trying to find a solution to the following problem. The error is 'Data Provider or other service returned an E-FAIL error. Number- 2147467259'. This happens when I add a new record to this table. Everything works fine when I have a small set of records. Currently I have about 24,000 records and the table size is 20M. I am using VFP 6.0 as the back end database and VB 6.0 (SP 5.0). I am using the following code:

Set rsInsert = New ADODB.Recordset
With rsInsert
.CursorType = adOpenDynamic
.LockType = adLockOptimistic
.Open "quotes", gDBConnection, , , adCmdTable
.AddNew 'This is where it throws me out

!QuoteDate = QuoteDate
!PropertyId = PropertyId
!CustomerId = InsuredData.nCustomerId


Thanks in advance.

 

[BBaggins]

Make sure you have the TEMP and TMP environment variables defined (My Computer -> Properties -> Advanced tab -> System Variables)

This is just one of probably many causes for this generic error.

 

[rnathan]

I checked the environment variables and they have been set. Any other suggestions?

 

[ITProgrammer]

are you the same person who gave L:..?

just check it..and notify me