Prev: UCase
Next: CreateObject Error 91 Object variable or With block variable not set
From: Amit Mohod on 22 Nov 2005 23:53
Hello Group,

I build a project which uses ADO for connecting to a FoxPro database through
system DSN.
These DSN uses Microsoft Visual Foxpro Driver (Version 6.01.8629.01;
vfpodbc.dll)
I installed it on some machines. few of them r running fine but on
I am getting
Runtime Error 3021, (Either BOF or EOF is true, or the current record has
been deleted. requested operation requires a current record with this code)

I thought it was the Driver problem. I checked drivers on both machines
(Both runing Win98-Se).
The drivers are identical.

Can I have any help?

--
Regards,
Amit Mohod
AB Softskills, Nashik.
Cell No: 09822939505
Office: +91-253-2382781(255)


From: jack on 22 Nov 2005 23:59
This might sound familer

This error olly arises when there is no record in the database (table )
eof - end of file
bof - begining of file

which means that both the condition are true and there is no record in
the table

this will help you

From: Amit Mohod on 23 Nov 2005 00:18
> which means that both the condition are true and there is no record in
> the table

There are 17 records in table. So at the start of the program, when
recordset is at first record no need of getting this error.

It works on few machines with no problem..but on some machine it gives
problem.
I installed same driver set on all machines.but still the error is thr.


--
Regards,
Amit Mohod
AB Softskills, Nashik.
Cell No: 09822939505
Office: +91-253-2382781(255)
"jack" <gautams.mail(a)gmail.com> wrote in message
news:1132721943.293103.48200(a)g49g2000cwa.googlegroups.com...
> This might sound familer
>
> This error olly arises when there is no record in the database (table )
> eof - end of file
> bof - begining of file
>
> which means that both the condition are true and there is no record in
> the table
>
> this will help you
>


From: jack on 23 Nov 2005 00:46
To rule out this error just read foxpro file which is a flat file in
binary mode
this way you could be able get records directly and there is no need
of drivers also
just gather information about table structures of foxpro
which has structure defination and data storage structure
i have done this and is working fine

From: Amit Mohod on 23 Nov 2005 01:06

> To rule out this error just read foxpro file which is a flat file in
> binary mode

Please can u tell how to open .dbf file in binary mode?
I you mean using filesystem object, how can i get records as i get them when
I use drivers?
Can u give some code?

> just gather information about table structures of foxpro
> which has structure defination and data storage structure
the structure of .dbf file is with me.


--
Regards,
Amit Mohod
AB Softskills, Nashik.
Cell No: 09822939505
Office: +91-253-2382781(255)
"jack" <gautams.mail(a)gmail.com> wrote in message
news:1132724776.917869.92540(a)f14g2000cwb.googlegroups.com...
> To rule out this error just read foxpro file which is a flat file in
> binary mode
> this way you could be able get records directly and there is no need
> of drivers also
> just gather information about table structures of foxpro
> which has structure defination and data storage structure
> i have done this and is working fine
>


 |  Next  |  Last
Pages: 1 2
Prev: UCase
Next: CreateObject Error 91 Object variable or With block variable not set