[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