Re: Alternatative DB Tables

["Phil Welch" <PhilmoreW@worldnet.att.net>]

Michael,

Seems like this approach worked for me:

SQL support via DBI
MiniVend now provides complete external SQL database support via the Perl
DBI and DBD modules. This allows transparent access to any database engine
that is supported by a DBD module. The current list includes mSQL, mySQL,
Solid, Postgres, Oracle, Sybase, Informix, Ingres, Qbase, DB2, Fulcrum, and
others. Any ODBC (with appropriate driver) should also be supported.

The configuration of the DBI database is done by setting attributes in
additional Database directives after the initial defining line as described
above. For example, the following defines the database arbitrary as a DBI
database, sets the data source (DSN) to an appropriate value for an mSQL
database named minivend on port 1114 of the local machine:


    Database arbitrary arbitrary.asc SQL
    Database arbitrary DSN           dbi:mSQL:minivend:localhost:1114

Regards,

Phil Welch

----- Original Message -----
From: Union Electronic Distributors <uedweb@unionel.com>
To: <minivend-users@minivend.com>
Sent: Tuesday, August 03, 1999 10:20 AM
Subject: Alternatative DB Tables


> ******    message to minivend-users from "Union Electronic Distributors"
<uedweb@unionel.com>     ******
>
> 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
>
>
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to
Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list