Browse by Tags

All Tags » ADO (RSS)

ADO error 3251– Object or provider is not capable of performing requested operation.

If you are getting the above error message check the length of the path of the Access database. A client had this problem where the path and Access database file name was “only” 181 characters. Testing shows that the length of the path and...
Posted by Tony | 2 comment(s)
Filed under: ,

ADO breaks when compiling in Windows 7 Service Pack 1

See the thread Breaking change in MDAC ADODB COM components in Windows 7 Service Pack 1 if you compile an app using early binding of ADO in Windows 7 SP1.   You may need to change your app to use late binding. I didn’t thoroughly read the thread...
Posted by Tony | with no comments
Filed under: , ,

Which Microsoft ActiveX Data Objects 2.x Library should I reference?

A question regarding what version of ADO was asked in a Visual Basic 6 newsgroup.  A reply by Ralph gave a very nice summary of the history of ADO and MDAC.  Which Microsoft ActiveX Data Objects 2.x Library should I reference? Also see I've...
Posted by Tony | with no comments
Filed under: , ,

I've never quite trusted ADO because …

I've never quite trusted ADO because I've never understood how their versioning system works. I just couldn’t see the various versions DLLs on my system and yet the Access references window showed five or six different versions..   Jet...
Posted by Tony | 7 comment(s)
Filed under: , , ,