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

[Hans-Joachim Leidinger <jojo@buchonline.net>]

******    message to minivend-users from Hans-Joachim Leidinger <jojo@buchonline.net>     ******

Erich Oliphant wrote:
> 
> I am obviously misunderstanding something.  I assumed that something like
> this:
> ---
> Database            products     products      SQL
>                   ---      OR    ----
> Database            products     products.asc      SQL
> Database   products  DSN  dbi:ODBC:mv
> Database            products     INDEX             code
> ---
> in my catalog.cfg would result MV using the "products" table in the "mv"
> ODBC alias as the products table for the catalog.   In addition the
> "prodcuts.asc" file would not be used,referenced,etc.  However, [loop] tags
> and the like still seem to want the products.asc file.  They do not pull the
> products from my database, rather they use the products.asc file.  If I
> remove this file and retrieve pages that use these tags the MV daemon gives
> me a "couldn't open search file ".....\products.asc" : No such file..."
> message.
> 
> How is this supposed to work?  I thought I was setting MV up to use my
> database table instead of the flat file.  What am I missing here?
> 
> Thanks,
> EKO
> 
[BIG DEL]

I wish, i can help you. But i have no experience with any SQL (I am
starting to use a SQL-Database now). 
If i remembered right, the questions how to set the catalog.cfg to use a
SQL-Database is answered and is in minivend mailarchiv. Did you search
for this answers from the mailarchiv? 
It seems me, the setting is not right and it seems me, i am missing User
and Password to access the SQL Databases. But i am not sure about my
archiv in my head and sorry for my poor english.

Regards,

	Joachim

-- 
-------------Hans-Joachim Leidinger---------------------


-
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