Comments on: ODBC DataConnector http://pocoproject.org/blog/?p=33 News and discussion for the POCO Community Thu, 09 May 2013 12:05:16 +0200 http://wordpress.org/?v=2.8.5 hourly 1 By: alex http://pocoproject.org/blog/?p=33&cpage=1#comment-94 alex Sun, 12 Nov 2006 19:28:26 +0000 http://appinf.com/poco/blog/?p=33#comment-94 unixODBC, like iODBC, is just another ODBC implementation for non-Windows operating systems. Even if it is not officially supported, it should work. unixODBC, like iODBC, is just another ODBC implementation for non-Windows operating systems. Even if it is not officially supported, it should work.

]]> By: Rajeev Kadam http://pocoproject.org/blog/?p=33&cpage=1#comment-93 Rajeev Kadam Sun, 12 Nov 2006 19:17:04 +0000 http://appinf.com/poco/blog/?p=33#comment-93 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 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

]]> By: guenter http://pocoproject.org/blog/?p=33&cpage=1#comment-92 guenter Sun, 12 Nov 2006 06:39:44 +0000 http://appinf.com/poco/blog/?p=33#comment-92 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? 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?

]]> By: Rajeev Kadam http://pocoproject.org/blog/?p=33&cpage=1#comment-91 Rajeev Kadam Sun, 12 Nov 2006 03:20:30 +0000 http://appinf.com/poco/blog/?p=33#comment-91 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 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

]]> By: alex http://pocoproject.org/blog/?p=33&cpage=1#comment-90 alex Wed, 08 Nov 2006 12:29:31 +0000 http://appinf.com/poco/blog/?p=33#comment-90 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. 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.

]]> By: alex http://pocoproject.org/blog/?p=33&cpage=1#comment-89 alex Sun, 22 Oct 2006 12:44:58 +0000 http://appinf.com/poco/blog/?p=33#comment-89 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. 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.

]]> By: guenter http://pocoproject.org/blog/?p=33&cpage=1#comment-88 guenter Sun, 22 Oct 2006 09:02:23 +0000 http://appinf.com/poco/blog/?p=33#comment-88 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. 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.

]]> By: Anthony http://pocoproject.org/blog/?p=33&cpage=1#comment-87 Anthony Sat, 21 Oct 2006 13:41:40 +0000 http://appinf.com/poco/blog/?p=33#comment-87 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. 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.

]]>