Limits of OLEDB and Access Passwords

People that know me know I hate useless error codes. During code reviews if I see someone attempting to return E_FAIL I will often launch into a blistering remark about how they are being lazy and making other developer’s lifes harder all at the same time.  The problem with E_FAIL is that it is completely…

1

Finding Database Connection Strings

For a simple tool I was working on I needed to talk to a Microsoft Access database from my program. Now, most of the database work I’ve done in the past has been against SQL Server, so I needed to dig up the magic voodoo which represents the “connection string” for Access 2007 files. The…

0

Writing Strings with OLE (CCommand)

This last weekend I was writing a COM object for submitting/editing entries into a SQL Server 2005 database we have for collecting project metrics. To do so, I was using the templated OLE DB functions: CCommand<CDynamicAccessor>, and things were progressing well until I needed to write a string value into a varchar field. The SetValue…

0