RE: ODBC vs OLE DB/400

["Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>]

John,

Using them from where? Some applications want to talk to OLEDB drivers,
some to ODBC drivers. If you're speaking of programming, in what? If
it's something .NET then you don't want to use either, you want to use
the .NET native provider from IBM.

If you're using older COM based connections (VB6, Delphi, PB, etc.) then
it almost doesn't matter. Code to ADO for data access and you can switch
between the two in the connection string.

I've seen some reports in the past that showed ODBC w/a slight advantage
on first-connect and inserts and OLEDB w/an advantage on larger
recordsets, but in general it's a wash. 

-Walden