Type mismatch when referencing an ADO recordset

[Sashanan]

In VB6, one of my forms has an ADODC control that accesses a table in my SQL Server database and fills a couple of fields with it. Nothing special, I've got dozens of these throughout my application.

For some reason, on *one* client computer (it does not occur on my system or for any of the other 5 clients using this part of the program), any attempt to reference the recordset results in a Type Mismatch error. No matter if I do:

adodc1.recordset.movenext

Or

label1.caption = adodc1.recordset.recordcount

Or

If adodc1.recordset.eof then

Or anything of the sort, I immediately get a Type Mismatch and that's that. Once again, it only happens for him.

Reinstalling the application, even reinstalling the ADO drivers had no effect, and I'm at a loss what's causing this. If I revert to an earlier version of the executable on his computer, it works again, but the newer version doesn't; and I've changed nothing about the code in this part of the program, either.

What else can I do to figure out what's causing this problem?


"Much that I bound, I could not free. Much that I freed returned to me."
(Lee Wilson Dodd)

 

[Spellman]

Just a quick point. Are you returning dates in the recordset?? If so you might want to try checking his international date setttings in his windows settings to make sure it's compatible with the format that your using.

Mark

The key to immortality is to make a big impression in this life!!

 

[MichaelRed]

Also check the 'references'




MichaelRed
m.red@att.net

Searching for employment in all the wrong places