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 ==== |