SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Now you ODBC me now you don't


Now you ODBC me now you don't

Author
Message
Phil Factor
Phil Factor
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2742 Visits: 2984
Comments posted to this topic are about the item Now you ODBC me now you don't


Best wishes,

Phil Factor
Simple Talk
Charles Kincaid
Charles Kincaid
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2133 Visits: 2384
So OLE DB is going away. Yet you have said nothing about ODBC going away. If I were to set up an ODBC connection to one of my SQL servers OLE DB is just one of the options. If you are not on a flavor of Windows then I hear the OLE DB is the best choice.

As long as ODBC it self is still supported and there is a good driver to use I think that most folks can deal. I have used ODBC drivers for Quick Books, Access (ugh), Clent Access to get at AS?400 data. Fox Pro, SQL, and others.

As long as we have the freedom to get to the data (in a controlled and secure way of course) that is what is needed (IMHSHO). They close one door, we find a window.

Technology changes. Sometimes old ways have run their life course. Celebrate the good times and the life accomplishments with a large glass. Sing some songs and move along. You will be raising one over me soon enough.

ATBCharles Kincaid
mike.schmid
mike.schmid
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 87
I understand what you're saying about Microsoft's reasons for moving away from OLE DB and back to OBDC. Proprietary to Microsoft or not (of no consequence in a homogenous Microsoft shop), I would really enjoy a secure, encrypted connection protocol that doesn't require other methods.
Arun Jebakumar
Arun Jebakumar
Old Hand
Old Hand (317 reputation)Old Hand (317 reputation)Old Hand (317 reputation)Old Hand (317 reputation)Old Hand (317 reputation)Old Hand (317 reputation)Old Hand (317 reputation)Old Hand (317 reputation)

Group: General Forum Members
Points: 317 Visits: 264
I hope the SQLNCLI contains inside itself both the SQLOLEDB and SQLODBC providers, and it seems Microsoft is going to throw away SQLOLEDB soon, and SQLNCLI will be exclusively based on SQLODBC only.

When you see the list of providers (maybe while creating an SSIS connection or while creating a linked server), you can see two entities named "Microsoft OLE DB provider for SQL server" and "SQL Native client". This used to be a bit confusing for beginners, and so it is better that they take away the first one and retain the second one only.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search