- Posts: 16
V4.1.2 - Cannot create new DB in different structure
- Keith Weatherhead
- Topic Author
- Offline
- User
Less
More
6 years 3 months ago #3439
by Keith Weatherhead
V4.1.2 - Cannot create new DB in different structure was created by Keith Weatherhead
Greetings,
I have the 32bit version installed and am having some issues... I am reading from a folder on my 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 drive. This is a local partition as I have a 1TB SSD partitioned into C; & 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
I have the 32bit version installed and am having some issues... I am reading from a folder on my 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 drive. This is a local partition as I have a 1TB SSD partitioned into C; & 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
Please Log in or Create an account to join the conversation.
- FlowHeater-Team
- Offline
- Admin
6 years 3 months ago #3448
by FlowHeater-Team
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Replied by FlowHeater-Team on topic V4.1.2 - Cannot create new DB in different structure
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 Definition location you´re running.
If this not working please try to use a absolute path (e.g. “\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 Definition for more analytics.
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 Definition location you´re running.
If this not working please try to use a absolute path (e.g. “\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 Definition for more analytics.
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Please Log in or Create an account to join the conversation.
- Keith Weatherhead
- Topic Author
- Offline
- User
Less
More
- Posts: 16
6 years 3 months ago #3449
by Keith Weatherhead
Replied by Keith Weatherhead on topic V4.1.2 - Cannot create new DB in different structure
I was using the Folder Chooser Option (...) ....
Please Log in or Create an account to join the conversation.
- FlowHeater-Team
- Offline
- Admin
6 years 3 months ago - 11 months 3 weeks ago #3454
by FlowHeater-Team
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Replied by FlowHeater-Team on topic V4.1.2 - Cannot create new DB in different structure
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.
What are the results on your side?
Note: Please answer on this thread to post your results, Thanks.
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.
- Execute the Definition as it is.
- 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.
- The same as 2) but you should use drive \ for the dBase IV files.
What are the results on your side?
Note: Please answer on this thread to post your results, Thanks.
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Last edit: 11 months 3 weeks ago by FlowHeater-Team.
Please Log in or Create an account to join the conversation.
Time to create page: 0.272 seconds