This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:odbc:home [2011/01/12 20:59] els |
dev:odbc:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 4: | Line 4: | ||
| ====== Development: ODBC Interface ====== | ====== Development: ODBC Interface ====== | ||
| - | **[[dev:odbc:home|Overview]]** | [[dev:odbc:datasources|ODBC Datasources]] | [[dev:odbc:sample|Sample Program]] | + | **[[dev:odbc:home|Overview]]** | [[dev:odbc:datasources|ODBC Datasources]] | [[dev:odbc:sample_c|Sample C# .NET Console Program]] | [[dev:odbc:sample_net|Sample C# .NET Windows Program]] |
| ---- | ---- | ||
| Line 11: | Line 12: | ||
| ===== Overview ===== | ===== Overview ===== | ||
| - | The Omnidex ODBC Driver is a standard-compliant ODBC driver that provides ODBC access to Omnidex Environments. ODBC is most commonly found in a Microsoft Windows environment; however, it can also be found on UNIX platforms through available ODBC managers such as unixODBC. Omnidex's ODBC Driver is available on both Microsoft Windows and Linux operating systems. | + | The Omnidex ODBC Driver is a standard-compliant ODBC driver that provides ODBC access to Omnidex Environments. ODBC is most commonly found in a Microsoft Windows environment; however, it can also be found on UNIX platforms through available ODBC projects such as unixODBC. Omnidex's ODBC Driver is available on both Microsoft Windows and Linux operating systems. |
| The Omnidex ODBC Driver allows standardized access to Omnidex Environments from a multitude of third party tools and applications, such as Business Objects, Impromptu, MicroStrategy and Informatica. ODBC also provides access to common office tools, such as Microsoft Access, Excel and Word. Custom applications can also access Omnidex Environments using the standard ODBC API calls. | The Omnidex ODBC Driver allows standardized access to Omnidex Environments from a multitude of third party tools and applications, such as Business Objects, Impromptu, MicroStrategy and Informatica. ODBC also provides access to common office tools, such as Microsoft Access, Excel and Word. Custom applications can also access Omnidex Environments using the standard ODBC API calls. | ||
| - | The Omnidex ODBC Driver is based on the Version 2.0 of the ODBC standard. If you are using Version 3.5 of the ODBC standard, calls will automatically be downgraded to Version 2.0, allow the Omnidex ODBC Driver to work. | + | The Omnidex ODBC Driver is based on the Version 2.0 of the ODBC standard. If you are using Version 3.5 of the ODBC standard, calls will automatically be downgraded to Version 2.0. |
| Line 24: | Line 25: | ||
| Omnidex automatically optimizes SQL statements to provide the best performance. Nonetheless, there are times when the wording and structure of a SQL statement can affect performance. Each third-party application will use its own method of wording and structuring the SQL statement, and not all approaches generate the best performance. | Omnidex automatically optimizes SQL statements to provide the best performance. Nonetheless, there are times when the wording and structure of a SQL statement can affect performance. Each third-party application will use its own method of wording and structuring the SQL statement, and not all approaches generate the best performance. | ||
| - | Some tools allow configuration options that alter the wording or structure that they use. If you find that you are not obtaining satisfactory performance, you may be able to use these configuration options to improve the wording of the SQL statement, and therefore improve the performance. | + | Some tools allow configuration options that alter the wording or structure of the SQL that they use. If you find that you are not obtaining satisfactory performance, you may be able to use these configuration options to improve the wording of the SQL statement, and therefore improve the performance. |
| Omnidex is often used with third-party packages, but Omnidex is not regularly tested with each and every third-party package. If you have difficulty integrating Omnidex with a particular third-party package, please contact [[appendix:contactus|Technical Support]]. | Omnidex is often used with third-party packages, but Omnidex is not regularly tested with each and every third-party package. If you have difficulty integrating Omnidex with a particular third-party package, please contact [[appendix:contactus|Technical Support]]. | ||
| Line 30: | Line 31: | ||
| ===== ===== | ===== ===== | ||
| - | **[[dev:odbc:sample|Next]]** | + | **[[dev:odbc:datasources|Next]]** |
| ====== Additional Resources ====== | ====== Additional Resources ====== | ||