err.source in a VB ADO project is machine specific
Posted on 2006-06-30
In one machine, I wrote a VB project that uses ADO. The code executes a query, which returns zero rows. After that there is some code that works on the returned recordset. As expected I get error. When I print, err.Source, I get ADODB.Recordset. Similarly, at some other places I get error source as ADODB.Connection, ADODB.Field etc.
I do exactly the same in another machine. In that machine err.Source is the name of the VB project.
The problem is not that I get runtime error. The error is expected. But I do not understand why err.Source is different on different machines.
I have checked versions of MDAC files on the two machines. They are identical.
So, what could be the reason that err.Source is different on different machines?