MiniVend Akopia Services

[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




Search for: Match: Format: Sort by: