Re: Minivend + Sybase linux Connectivity

[August Detlefsen <augustd@idiom.com>]

I use Sybase and my DSN is:

ProductFiles        stock
Database            stock         stock.asc         SQL
Database            stock         DSN               dbi:Sybase:
Database            stock         USER              xxxxxxxx
Database            stock         PASS              xxxxxxxx
Database            stock         DELIMITER         TAB
Database            stock         ChopBlanks        1
Database            stock         COLUMN_DEF        code=char(16) PRIMARY KEY

You also have to make sure to set some environment variables:

SYBASE    /path/to/sybase
DSQUERY   NAME_OF_DATABASE

Within your [sql] tags, always define the table you want to search by adding base=tablename

Hope this helps,
-August
--
 mailto:augustd@idiom.com