odbc 1.5 KB

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