Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

What's a better connection to an SQL database? ODBC or OLE DB

NEw user here, but what would be a preferred way of connecting to my SQL database? So far I have option of using ODBC (RDO) connection or OLE DB(ADO) connection. I'm not sure what the differences or when to use one or the other.

Thanks

replied

I like OLE DB for the simply because it's "portable". With OLE DB the connection info is stored in the report. With ODBC, the report is using a system dsn connection. It means that if you want to send it to another user / computer, you also have to make sure the other computer has the same ODBC connection.

In terms of performance... I've used both and have never seen a difference.

Jason

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question