[ic] ic database problem
Wojtek
mailinglists at lunetta.de
Mon Dec 13 10:19:07 EST 2004
Stefan Hornburg wrote:
> On Sun, 12 Dec 2004 22:05:06 -0500
> Wojtek <mailinglists at lunetta.de> wrote:
>
>
>>Hi List:
>>
>>I want to only use my MySQL database for data storage, no text files
>>or anything. I use the following configuration directives:
>>
>>ProductFiles products
>>
>>Variable SQLDSN dbi:mysql:demostore
>>
>>Require module DBI
>>Require module DBD::mysql
>>
>>Message -i -n Using MySQL, DSN=__SQLDSN__...
>>
>>DatabaseDefault USER root
>>DatabaseDefault PASS mypass
>>
>>Database products products.txt __SQLDSN__
>>
>>
>>I also have a products.sql file in my products directory. The problem
>>is that no data is showing. When I copy a products.txt file to the
>>products directory data shows up. But as I said I do not want to use
>>any additional text files. What is the problem here?
>
>
> After the data is in there, set:
>
> NoImport products
>
> resp.
>
> NoImportExternal yes
>
> in catalog.cfg.
I realized the every time I restart my ic server with that configuration
a products.autonumber file is created in the products directory. Does
this have something to do with my problem that the SQL database is not
accessed?
Thanks in advance,
Gregor
More information about the interchange-users
mailing list