Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Alternatives to ODBC

If ODBC seems to be slow, it may be because of the SQL server. But alternatives exist, such as the ado.net

Our Database people are discontinuing ODBC access because of performance reasons. What are the alternatives to ODBC?
In my experience odbc is not "slow by default." When investigating performance issues in distributed environment working with db2/400, I almost always found that the slow part was SQL proccessing on the database (i.e. because of a missing index) and not the ODC layer. So I would advise you not to discontinue ODBC use that easily.

That being said, an alternative can be the ado.net provider that works very well (and is supposed to be slightly faster then ODBC). It is offered by iSeries Access and more details can be found here.

Dig Deeper on DB2 UDB (universal databases)

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.