TOPIC: V4.1.2 - Cannot create new DB in different structure

Greetings,

I have the 32bit version installed and am having some issues... I am reading from a folder on my D: drive that contains a series of DBF files.
This works fine as I can access them with no issues. I wanted to write out a new SQLite file in a parallel folder to where the DBF files exist.
However it seems that I can only generate a file in the C:\Program Files (x86)\FlowHeater v4\Examples\EN folder structure. They initially were
appearing in the HelloWorld folder (found my O/P fie after searching a bit) and I created a folder parallel to the HelloWorld folder and the O/P
will create there BUT NOT to the the folder I desired on my D: drive. This is a local partition as I have a 1TB SSD partitioned into C; & D: drives
on my local machine. Any ideas? I used the WriteAdapterConfiguration/General tab... using the chooser option (...) to the right of the DataBase
field. Is there a problem with the SQLite Adapter for Write Operations?

Keith

Hi Keith,

In case you just entered a SQLite database name without a path the database will be created in the folder where the FlowHeater Definition are located.

If you specified a realtive path (e.g. “..\database\sqlite.db”) to your SQLite database the path are always relativ form the current Defintion location you´re running.

If this not working please try to use a absolute path (e.g. “D:\database\sqlite.db”) for the database name in the SQLite Adapter Configurator.

I´ve made a few basic tests and it always creating the database in the expected folder. If this not solve your issue please post your created FlowHeater Defintion for more analytics.

I was using the Folder Chooser Option (...) ....

Hi Keith,

Your screenshots from your other post here ( Example OF Issue Accessing File ) shows me that the problem is related to the OleDB Adapter and the using of dBase IV database tables and not to create a new SQLite database.

Ok, now I´ve made e few more test with using a dBase IV database table for exporting data. All my test has been completed successfully without an error message.

Attached you´ll find my simple test defintion including a small dBase IV database. Please extract this and make the three below descripted tests.

1. Execute the Definition as it is.
2. Move the 3 dBase IV table files to another location on dirve C:\ and modifiy the OleDB datasource on the read side to the new location and execute the Definition again.
3. The same as 2) but you should use drive D:\ for the dBase IV files.

What are the results on your side?

Note: Please answer on this thread to post your results, Thanks.