Member Avatar for wegdan

what is a database driver (such as microsoft provider)
and a database provider(such as jdbc driver , odbc driver , dbole driver)
and what the importance of each of them?

  • 3 Contributors
  • 3 Replies
  • 106 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by emiola

Dani AI

Generated

Short answer: a "driver" is the low‑level library that implements a database access API and translates calls into the database server's protocol. A "provider" is the same idea framed for a specific platform or framework (for example OLE DB providers for COM, ADO.NET providers for .NET). In everyday use the words are often interchangeable, but which term is used depends on your ecosystem.

Why it matters: the driver/provider determines compatibility, supported SQL/features, performance, and connection semantics (pooling, transactions, prepared statements). Choose the implementation that matches your language/runtime and OS: JDBC drivers for Java, ODBC drivers for native C apps or cross‑language systems, OLE DB/ADO.NET providers for Windows/.NET. Vendor-supplied, native drivers usually expose more features and give better performance than generic bridges.

Practical checklist (use before troubleshooting or picking a driver):

  • Identify runtime and OS (Java/.NET/PHP, Windows/Linux, 32‑bit vs 64‑bit).
  • Match driver/provider to the runtime (JDBC jar on the classpath; ADO.NET provider or ODBC driver installed and registered).
  • Prefer the vendor native driver (Oracle, Microsoft, MySQL connectors) for full feature support.
  • Verify bitness: a 32‑bit process needs 32‑bit drivers/ODBC DSNs; 64‑bit needs 64‑bit.
  • Ensure required client libraries are present (Oracle Instant Client, SQL Server client libraries).
  • Test with a vendor tool (sqlplus, sqlcmd, isql) to isolate network/auth issues.
  • Keep drivers up to date for fixes/security, but check server compatibility notes.

Notes tied to earlier replies: was right to ask about OS and DB version — those determine which driver/provider to install. If you meant "dbole" in the original post, that term is likely a typo; "OLE DB" is the Microsoft COM provider model. For Java avoid relying on old JDBC‑ODBC bridges in modern JDKs; use a native JDBC driver instead.

Recommended Answers

All 3 Replies

Member Avatar for debasisdas

Applications connects to the database through the drivers.
ODBC, it is a differnt layer .ODBC is neither part of the frontend nor the backend.

Member Avatar for emiola

If I may ask,
1. what operating sysytem are you using?
2. What HTML editor are you using?
3. Do you know how to add a database like MySQL on your web server?

Kindly send your replies and from there, the forum will know the next steps necessary.

Member Avatar for emiola

Also, do you have any oracle database version (10g Express Edition, 11g) installed on your local system?
to learn something about oracle 10g Express edition

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.