Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jaugwar
Starting Member
6 Posts |
 Posted - 2011-08-28 : 13:28:34
|
| Can any one help me with this:1. Why do I need to connect my server database using ODBC connection?2. Why is it preferred to use ODBC over OLEDB to connect server in SQL server 2005 and over?jackson |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-28 : 13:42:20
|
| 1. You don't2. It isn't. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-08-28 : 15:08:33
|
| OLE DB is newer technology and supports some features that ODBC doesn't, but if you're just doing basic querying then either one is sufficient. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-08-30 : 09:32:36
|
| Of course Microsoft posts this the next day:http://blogs.msdn.com/b/sqlnativeclient/archive/2011/08/29/microsoft-is-aligning-with-odbc-for-native-relational-data-access.aspx |
|
|
|
gwilson67
Starting Member
42 Posts |
|
|
|
|
|
OLEDB vs ODBC