What is the difference between oledb and sql connection

Author Recent Posts. Hadi Fadlallah. Hadi is an SQL Server professional with more than 10 years of experience. His main expertise is in data integration. He is a Neo4j and ArangoDB certified professional. On the academic level, Hadi holds two master's degrees in computer science and business computing. Currently, he is a Ph. Hadi really enjoys learning new things everyday and sharing his knowledge.

You can reach him on his personal website. View all posts by Hadi Fadlallah. Latest posts by Hadi Fadlallah see all.

Merge Transformation - September 28, XML task. SSIS Lookup transformation vs. Fuzzy Lookup transformation. SSIS Pivot transformations vs. Unpivot transformations. Merge Transformation. Table or View. Asked 10 years, 2 months ago. Active 10 years, 2 months ago.

Viewed 24k times. Abdul Rahman Abdul Rahman 2 2 gold badges 6 6 silver badges 20 20 bronze badges. Add a comment. Active Oldest Votes. Tip: use Universal Data Link File.

Simon D Simon D 3, 5 5 gold badges 36 36 silver badges 46 46 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Because it has it's own interface for the users to set the connection information, all you have to do is program your application to utilize the DSN you specify.

This is also handy if you are designing an application that is supposed to work with other database systems other than SQL Server. But it does seem to interface more simply to it. As I said in the previous post, ODBC is designed to simplify the connection process, thus it requires less parameters to utilize it. As for the Delphi component, I am not fully aware of it's implementation, but if it is a wrapper component for the ADO libraries, then it is a matter of making sure you specify the use of an OLE-DB connection in it's instantiation.

You must be logged in to reply to this topic. Login to reply. May 31, at am Please Clarify June 1, at am I hope this will be a simpler explaination June 2, at am Please clarify this.