This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:tutorials:simple_envrionment_flat [2010/05/21 14:14] tdo |
dev:tutorials:simple_envrionment_flat [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 79: | Line 79: | ||
| update indexes | update indexes | ||
| </code> | </code> | ||
| - | |||
| ==== Step 5 - Develop an Application with ODBC, JDBC or Stored Procedures ==== | ==== Step 5 - Develop an Application with ODBC, JDBC or Stored Procedures ==== | ||
| - | After creating an Omnidex Environment and adding Omnidex indexes via DBINSTAL, applications can be developed using the DISC provided ODBC and JDBC drivers. | + | After creating an Omnidex Environment and adding Omnidex indexes via UPDATE INDEXES, applications can be developed using the DISC provided ODBC and JDBC drivers. |
| - | Create an ODBC or JDBC datasource using the Windows Client DataSource Editor (DSEDIT). | + | Network aware Omnidex applications can either use an ODBC style datasource file or an internal connection string. |
| - | + | ||
| - | Name the file as "tiny.dsn". | + | |
| - | + | ||
| - | Or modify the following text file and save as tiny.dsn. | + | |
| - | Change the following lines to the correct path and filenames. | + | |
| - | + | ||
| - | Change these three lines with: | + | |
| - | * Host= Change this value to the name of computer being used for this test. | + | |
| - | * ODBCDSNFILE= Change this value to the path and file name of the dsn file. | + | |
| - | * FileSpec= Change this value to the path and filename of the Omnidex Environment file. | + | |
| - | + | ||
| - | Cut and paste this text as "tiny.dsn" with the modifications and save in the same directory as the "tiny.env" Omnidex Environment file. | + | |
| - | + | ||
| - | <code> | + | |
| - | Host=tdo830 | + | |
| - | ODBCDSNFILE=C:\dev\odx\tiny\tiny.dsn | + | |
| - | FileSpec=c:\dev\odx\tiny\tiny.env | + | |
| - | </code> | + | |
| - | + | ||
| - | <code> | + | |
| - | ODBC] | + | |
| - | DRIVER=DISC OMNIDEX OdxNet Driver | + | |
| - | ODBCDSNFILE=C:\dev\odx\tiny\tiny.dsn | + | |
| - | ODBCDSNNAME=tinydsn | + | |
| - | [DataSources] | + | |
| - | tinydsn=DataSource Edit Wizard Generated | + | |
| - | [DataSource tinydsn] | + | |
| - | Dictionary=tinydsn | + | |
| - | DisplayWindow=NONE | + | |
| - | [Dictionaries] | + | |
| - | tinydsn=DataSource Edit Wizard Generated | + | |
| - | [Dictionary tinydsn] | + | |
| - | Server=Server1 | + | |
| - | NetworkServices=OdxNet | + | |
| - | Type=OmniAccess | + | |
| - | FileSpec=c:\dev\odx\tiny\tiny.env | + | |
| - | HostOAConnectOptions= | + | |
| - | Password=!~ | + | |
| - | AccessOptions=Write | + | |
| - | [Servers] | + | |
| - | Server1=DataSource Edit Wizard Generated | + | |
| - | [Server Server1] | + | |
| - | Host=tdo830 | + | |
| - | Port=7555 | + | |
| - | </code> | + | |
| ==== Step 6 - Simulate a client server environment using OdxNet with ODBC or JDBC ==== | ==== Step 6 - Simulate a client server environment using OdxNet with ODBC or JDBC ==== | ||
| Line 138: | Line 92: | ||
| Go back to the original command window and do the following: | Go back to the original command window and do the following: | ||
| - | os> odxsql tiny.dsn -odbc | + | os> odxsql tiny -odbc |
| or run an ODXNET listener from within OdexSQL using the -odxnet command line option. | or run an ODXNET listener from within OdexSQL using the -odxnet command line option. | ||
| os> odxsql -odxnet | os> odxsql -odxnet | ||
| - | > connect tiny.dsn using odbc | + | odxsql> connect tiny using odbc |
| | | ||
| <code> | <code> | ||
| - | > select * from table1 where mytext = 'bears' | + | odxsql> select * from table1 where mytext = 'bears' |
| MYSEQ MYTEXT | MYSEQ MYTEXT | ||
| Line 154: | Line 108: | ||
| </code> | </code> | ||
| - | ### Note that Omnidex will do a quick text (Keyword) retreival automatically ## | + | ### Note that Omnidex will do a quick text (Keyword) retreival automatically ### |
| ==== Step 7 - Insert a new row to see that it is indexed ==== | ==== Step 7 - Insert a new row to see that it is indexed ==== | ||