re: Beginners guide to ODBC

George Hepworth — Sat, 20 Jun 2009 18:49:08 GMT

I like to give credit where credit is due. Although a lot of folks contributed to the final result, the primary author behind the article was "BananaRepublic". Good work by him and his collaborators.

re: Beginners guide to ODBC

Renaud Bompuis — Mon, 22 Jun 2009 04:21:40 GMT

A very useful resource, thanks for letting us know.

One thing I'd like to see here is a discussion about which driver should be chosen when talking to SQL Server from Access.

I've had strange issues when using the latest "SQL Server Native Client" for instance, and there is little help in addressing them.

For instance, inserting in "nvarchar(MAX)" fields from Access bombs if you're using the "SQL Server Native client" driver instead of the older "SQL Server" driver.