Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OLE DB vs ODBC 1

Status
Not open for further replies.
zivrap

zivrap

Technical User
Aug 10, 2004
31
CA

Hi All,

I have a choice between using an OLE DB connection or a ODBC connection to my access database. I am not sure of which to use. Can anyone possibly tell me the advantages/disadvantages of the two? Which one should be used over the other in which situation? Thank you.
 
Sort by date Sort by votes
If you are using ADO objects in your code then OLE DB will be required. Some OLE DB providers also go through ODBC, but this is needless overhead so avoid them. I don't know of any advantages to using ODBC.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MattGreer
  • Locked
  • Question
VBA Query - Close and Reopen db Connection when SQL Changes? 2
Replies
4
Views
279
Andrzejek
Andrzejek
pastorandy
  • Locked
  • Question
Church DB Question regarding Hymn Check query 2
Replies
17
Views
206
pastorandy
pastorandy
faxpay
  • Locked
  • Question
Access 2010 db getting err using INSERT INTO stmnt 1
Replies
3
Views
74
MajP
MajP
billheath
  • Locked
  • Question
requetin a particular date vs all dates
Replies
4
Views
73
dhookom
dhookom
RobertIngles
  • Locked
  • Question
ODBC Connection Failure Access DB on Network Drive
Replies
6
Views
105
c29537
c29537

Part and Inventory Search

Sponsor

Back
Top