Overview
Features
Download
Documentation
Community
Add-Ons & Services
The POCO C++ Libraries Blog

ODBC DataConnector

Filed under: News by alex at 04:05

ODBC DataConnector is in the Subversion repository. The code is tested and runs correctly on Windows XP Pro with Oracle ODBC driver ver 10.02.00.01. It is an early snapshot with some wrinkles left to iron out so changes are likely to be seen in the near future.

Comments and/or contributions are more than welcome.

Alex

8 Comments »
  1. Is the plan to use ODBC for all data sources or you will be using native access in some cases? I can see how ODBC would be sufficient for accessing MS SQL server but Oracle?
    SOCI uses OCI directly I think so do most c++ wrappers actually.

    a.

    Comment by Anthony on October 21, 2006, 15:41

  2. We definitely plan to support certain databases (e.g., Oracle, MySQL, SQL Server) directly. The OCI connector will be the next we’re going to implement. And if anyone wants to do other wrappers, you’re certainly welcome ;-)
    After all, we see this as a community effort.

    Comment by guenter on October 22, 2006, 11:02

  3. It is exactly as Guenter said. Let me just ad this:

    ODBC is only a “failover” DB access back-end for all the databases lacking native connectors. The more native connectors we add, the better. So, whoever is interested, by all means, start writing a native connector.

    Comment by alex on October 22, 2006, 14:44

  4. An update:

    ODBC connector has been tested (on Windows XP) with following databases:

    - Oracle (9i Release 9.2.0.4.0, XE Release 10.2.0.1.0)
    - IBM DB2 (Express-C 9.1)
    - MS SQLServer (Express 9.0.2047)
    - MS Access (Jet 4.0)
    - PostgreSQL (7.4.6, 8.1.5)
    - MySQL (5.0.27-community-nt)
    - SQLite (3.*)

    Latest sources are in SVN.

    A short How-to addressing some connector specifics will be available soon.

    Comment by alex on November 8, 2006, 14:29

  5. Will these classes work on Unix and if so, when will the native connectors for MSSql be released in a poco release? Any ideas? Gosh, Poco gets better and better:D

    Comment by Rajeev Kadam on November 12, 2006, 05:20

  6. They will work on Unix, too. On Unix, the ODBC connector requires iODBC. A native SQLServer connector will be certainly done some day, but we have no idea yet by whom when… Volunteers?

    Comment by guenter on November 12, 2006, 08:39

  7. Interesting, I am using unixODBC since I am using rails requires that as well to connect to the sql server. Not sure about iODBC or how that works

    Comment by Rajeev Kadam on November 12, 2006, 21:17

  8. unixODBC, like iODBC, is just another ODBC implementation for non-Windows operating systems. Even if it is not officially supported, it should work.

    Comment by alex on November 12, 2006, 21:28

RSS RSS feed for comments on this post. TrackBack URI

Leave a comment