* [[topbar |Table of Contents]] * [[intro:overview:what|Introduction]] * [[install:home|Installation]] * [[install:editions|Product Editions]] * [[install:requirements|System Requirements]] * [[install:platforms|Supported Platforms]] * [[install:guides:home|Installation Guides]] * [[install:licensing:home|Licensing]] * [[install:releases:home|Release Notes]] * [[admin:home|Administration]] * [[admin:admin:home|Administration Basics]] * [[admin:admin:architecture:home|Omnidex Architecture]] * [[admin:admin:applications:home|Building Applications]] * [[admin:basics:home|Omnidex Fundamentals]] * [[admin:basics:environments:home|Omnidex Environments]] * [[admin:basics:sqlengine:home|Omnidex SQL Engine]] * [[admin:basics:updates:home|Omnidex Updates]] * [[admin:basics:network:home|Network Services]] * [[admin:indexing:home|Omnidex Indexing]] * [[admin:indexing:concepts:home|Indexing Concepts]] * [[admin:indexing:indexes:home|Indexing Options]] * [[admin:indexing:creation:home|Index Creation]] * [[admin:indexing:strategies:home|Indexing Strategies]] * [[admin:indexing:activecounts:home|ActiveCounts]] * [[admin:indexing:powersearch:home|PowerSearch]] * [[admin:indexing:autocomplete:home|AutoComplete]] * [[admin:indexing:text:home|Omnidex Text]] * [[admin:features:home|Omnidex Features]] * [[admin:features:snapshots:home|Omnidex Snapshots]] * [[admin:features:grids:home|Omnidex Grids]] * [[admin:features:rollups:home|Rollup Tables]] * [[admin:features:geo:home|Geographic Searches]] * [[admin:features:expressioncols:home|Expression Columns]] * [[admin:features:segments:home|Omnidex Segments]] * [[admin:features:attach:home|Attaching Data]] * [[admin:features:export:home|Exporting Data]] * [[admin:optimization:home|Optimizing Queries]] * [[admin:optimization:plans:home|Query Plans]] * [[admin:optimization:caches:home|Dynamic Caches]] * [[admin:optimization:config:home|Configuring Omnidex]] * [[integration:home|Integration]] * [[integration:rdbms:home|Relational Databases]] * [[integration:rdbms:oracle:home|Oracle]] * [[integration:rdbms:sqlserver:home|SQL Server]] * [[integration:rdbms:mysql:home|MySQL]] * [[integration:rdbms:odbc:home|Generic ODBC]] * [[integration:rawdata:home|Raw Data Files]] * [[integration:rawdata:fixed:home|Fixed-length Files]] * [[integration:rawdata:delimited:home|Delimited Files]] * [[integration:rawdata:ost:home|Standalone Tables]] * [[dev:home|Development]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:overview|Overview]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[dev:connections:home|Connection Strings]] * [[dev:odbc:home|ODBC Interface]] * [[dev:jdbc:home|JDBC Interface]] * [[dev:debugging:home|Logging/Debugging]] * [[programs:home|Programs]] * [[programs:odxsql:home|OdxSQL]] * [[programs:odxnet:home|OdxNet]] * [[appendix:home|Appendix]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[http://www.omnidex.com/download/|Downloads]] * [[support:home|Support]]

{{page>:top_add&nofooter&noeditbtn}} ====== Development: ODBC Interface ====== [[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]] ---- ===== ODBC Datasources ===== The standard ODBC interface uses datasources to connect to an underlying database. Datasources provide the connection information to get to the underlying data, and each database vendor must provide their own interface to creating these datasources. Omnidex provides several options for datasources. The Omnidex ODBC Driver supports the standard methods of connecting to the databases - Machine Datasources (SYSTEM and USER Datasources) and File Datasources. The driver supports DSN-less connections as well. ==== Machine Datasources ==== The standard ODBC interface provides the ability to create two types of Machine Datasources: System Datasources and User Datasources. When creating one of these datasources, the ODBC Data Source Administrator provided by Microsoft will automatically launch an Omnidex wizard to prompt you through the creation process. Consult this [[dev:odbc:wizard|tutorial]] for instructions about creating datasources using this wizard. Once the Machine Datasource has been created, it can be referenced by name in third-party applications that use ODBC. Consult each third-party applications' documentation for instructions about referencing Machine Datasources in their application. Machine Datasources can also be referenced in an ODBC call to either SQLConnect or SQLDriverConnect. In the following example, the name of the Machine Datasource is //simple//. SQLConnect( hdbc, (SQLCHAR*) "simple", SQL_NTS, NULL, 0, NULL, 0); SQLDriverConnect( hdbc, NULL, (SQLCHAR*) "DSN=simple", SQL_NTS, NULL, 0, NULL, SQL_DRIVER_NOPROMPT); ==== File Datasources ==== The standard ODBC interface provides the ability to create File Datasources. Microsoft's ODBC Data Source Administrator will automatically launch an Omnidex wizard to prompt you through the creation process for File Datasources as well. Consult this [[dev:odbc:wizard|tutorial]] for instructions about creating datasources using this wizard. It is also possible to manually create File Datasources for Linux computers that run a Linux-based ODBC Manager, such as unixODBC. These can be created using a text editor. Consult the [[dev:odbc:filedsn|ODBC File DSN Syntax Specification]] for instruction on manually creating these files. Once the File Datasource has been created, it can be referenced in third-party applications using the filename. Consult each third-party applications' documentation for instructions about referencing File Datasources in their application. File Datasources can also be referenced in a call to SQLDriverConnect. SQLDriverConnect( hdbc, NULL, (SQLCHAR*) "FILEDSN=simple.dsn", SQL_NTS, NULL, 0, NULL, SQL_DRIVER_NOPROMPT); ==== DSN-Less Connection ==== Omnidex also allows ODBC applications to connect to an Environment File without the need for a Machine or File Datasource. All of the needed information is found in the connection string. This approach may not be supported by some third-party applications; however, it can always be used in custom applications that call SQLDriverConnect. SQLDriverConnect( hdbc, NULL, (SQLCHAR*) "DRIVER={OMNIDEX}; CONNECTIONSTRING=[dbserver:7555]D:\\class\\simple.xml", SQL_NTS, NULL, 0, NULL, SQL_DRIVER_NOPROMPT); ===== ===== **[[dev:odbc:home|Prev]]** | **[[dev:odbc:sample_c|Next]]** ====== Additional Resources ====== See also: * [[dev:odbc:filedsn|ODBC File DSN Syntax Specification]] {{page>:dev:see_also&nofooter&noeditbtn}} {{page>:bottom_add&nofooter&noeditbtn}}

 
Back to top
dev/odbc/datasources.txt ยท Last modified: 2016/06/28 22:38 (external edit)
 
 
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0