Any gotchas migrating ODBC connections to OLE DB?

general discussion
1

Hello,

Are there any gotchas to be observed when migrating all SQL Server-based connections from ODBC to OLE DB? We will be doing this for organizational and performance reasons. I have checked the data access PDFs, but have found no relevant information.

FYI, Most data sources accessed by these connections make frequent use of outer joins.

Thanks,

Dan Lelovic.

dl_toronto :canada: (BOB member since 2002-08-28)

2

Check out this thread. OLEDB vs ODBC It summarizes everything I think is important to know about OLE DB. Other than what is there, everything should work fine.

Lee Drake :us: (BOB member since 2002-08-15)

3

Thanks. I’ll read up on that thread. I guess that didn’t turn up in my initial forum search since I used [ODBC “OLE DB”] instead of [ODBC OLEDB].

Dan.

dl_toronto :canada: (BOB member since 2002-08-28)