[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Alternatative DB Tables
Hello all,
I've been beating myself about the head and shoulders trying to get Minivend
to interface with our Informix database, but to no avail. Our db is pretty
huge and primarily configured for our in-house accounting and inventory
software, so renaming or duplicating any tables would be a nightmare.
I have the DBI and DBD drivers all configured and operating with no
problems, but still can't seem to connect properly with Minivend. What I
have set in the calolog.cfg file is as follows:
NoImport stuctlgd
ProductFiles stuctlgd
#Database products products.asc TAB
#Database stuctlgd INDEX item_code
Database stuctlgd stuctlgd.sql
dbi:Informix:standard:ued_tcp:5530
Database stuctlgd USER webuser
Database stuctlgd PASS xxxxxxxx
Database stuctlgd KEY item_code
PriceField stuctlgd list_price
Database stuctlgd COLUMN_DEF item_code=char(128)
Database stuctlgd COLUMN_DEF primary_vendor=char(128)
Database stuctlgd COLUMN_DEF list_price=char(20)
Database stuctlgd COLUMN_DEF dealer_price=char(20)
Database stuctlgd NUMERIC list_price, dealer_price
Am I missing something relatively simple?
Any help would be greatly appreciated.
...Michael Soucie