method ~ of object ~ failed

[ollivere]

Hi All,

I have a simple VB6 exe running on windows 2000 which
reads a text file then prints the contents and adds it to
an SQL database.

Seemingly completely at random the above error will
happen, it appears to be when the code moves to read the
next line of the file but it is never in the same place
and not all the time.

I am using the file system object to read the file and I
would appreciate any advice people have, as I am
completely stumped by this one!

Thanks

 

[vb5prgrmr]

Are you opening this file across your network? If so your network may be dropping your connection thus making your object invalid. To cure this problem copy the file locally and then process. This will also put less strain on your network.

Good Luck

 

[chiph]

This is a generic COM error that it uses when it doesn't know what else to give you.

If you search on this phrase in MSDN there's a couple of documents that have big lists of things to check... most of them are common-sense stuff like setting object variables to Nothing when you no longer need them, etc.

Chip H.

 

[mn12]

I had also this problem,and i have simply solved it by remove the VB6 and install it again.

GOOD LUCK!