Hi Bhavbhuti.

>Thanks for the explanation, but I can't seem to see OLE DB Provider for ODBC in the ODBC Data Source Administrator > Drivers tab.

That's because it's not an ODBC driver; it's an OLE DB provider that connects to ODBC drivers. To see a list of OLE DB providers, create an empty text file but give it a UDL extension (for example, TEST.UDL), then right-click it and choose Properties. One of the pages in the Properties dialog shows the OLE DB providers on your system.

>Is this OLE DB Provider for ODBC something I might have installed inadvertently before?

No, it's part of MDAC, which comes with Windows.

For more background on ADO and OLE DB providers, I suggest reading http://msdn2.microsoft.com/en-us/library/ms917355.aspx.

Doug