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

Former Member
Former Member 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