Re: [mv] Using SQL's DB's

[ericho@vantixnet.com (Erich Oliphant)]

Absolutely!  I've restarted several times to no avail.  In an earlier post I
describe how I temporarily renamed my products table to confirm that MV was
connecting.  I get an error when it can find the products table.  I get no
messages when it's there, so I know that MV is "looking" in the SQL DB at
startup.  However, it seems to be ignoring it when it runs this query.


----- Original Message -----
From: Ramsey French <rammjet@mindspring.com>
To: <minivend-users@minivend.com>
Sent: Saturday, January 22, 2000 1:33 AM
Subject: Re: [mv] Using SQL's DB's


> ******    message to minivend-users from Ramsey French
<rammjet@mindspring.com>     ******
>
> Did you restart the MV server after you modified catalog.cfg ?
>
> On 1/22/00 1:11 AM, Erich Oliphant at ericho@vantixnet.com wrote:
>
> > OK, My last post was due to ignorance, perhaps this one is as well.  I
am
> > just trying to list products on a "test page" with the following code:
> >
> > ---
> > [loop search="ra=yes"]
> > [loop-field description] |  [loop-increment] |  [loop-code]<BR>
> >
> > [/loop]
> > ---
> >
> > I have the following in my catalog.cfg:
> >
> > ----
> > #Database            products     products.asc      TAB
> > Database   products  products   dbi:ODBC:mv
> > #Database            products     INDEX             category
> > Database            pricing      pricing.asc       TAB
> > Database            transactions transactions.txt  TAB
> > Database            userdb       userdb.asc        TAB
> > Database            country      country.asc       TAB
> > Database            locale       locale.asc        TAB
> > Database            Ground       Ground.csv        CSV
> > Database            2ndDayAir    2ndDayAir.csv     CSV
> > Database            NextDayAir   NextDayAir.csv    CSV
> > ----
> >
> >
> > For some reason the page lists the contents of the products.asc file.
This
> > is weird because I know MV is checking the Access DB for the presence of
the
> > "products" table.  I have commented out the ref. to products.acs.  I am
very
> > confused.
> >
> > Thanks In Advance,
> > Erich
> >
>
> -
> 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
>

smime.p7s