blob: 9340832e7c6cff8fbf55c9152d29156c93c28f2f (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
* ODBC Data Provider
<ul>
<li>Exists in namespace System.Data.Odbc and assembly System.Data
<li>Works on Windows and Linux
<li>Works on Windows via the native Windows odbc32.dll
<li>Works on Linux via <a href="http://www.unixodbc.org/">unixODBC</a>
<li>List of unixODBC <a href="http://www.unixodbc.org/drivers.html">drivers</a> and
an alternative list
<li>An alternative to unixODBC, but not tested with this
provider is <a href="http://www.iodbc.org">iODBC</a>
<li>Another alternative to unixODBC, but not tested this provider is
<a href="http://oplweb.openlinksw.com:8080/download/">OpenLink's</a>.
<li>List of <a href="http://ourworld.compuserve.com/homepages/Ken_North/odbcvend.htm">ODBC Vendors</a>
<li>ODBC Provider created by Brian Ritchie.
</ul>
* Current Status
<ul>
<li>Connect on Windows via native Windows odbc32.dll
<li>Connect on Linux via unixODBC's libodbc.so
<li>Various databases have been tested using their
ODBC drivers: MySQL, Oracle, IBM DB2, and Microsoft SQL Server
<li>Can execute non-query commands via ExecuteNonQuery of a OdbcCommand
<li>Can execute aggreates and retrieve a single row single column result via
ExecuteScalar of a OdbcCommand
<li>Can execute queries via ExecuteReader of a OdbcCommand and
retrieve results using an OdbcDataReader.
<li>Can get a DataTable containing schema info via GetSchemaTable() in a OdbcDataReader
</ul>
* Action Plan
<ul>
<li>Create a Data Adapter to Fill data into a DataTable in a DataSet
<li>TODO
</ul>
|