Miva Database Location 1

[kavukattu]

Where is the Miva Database located...in what folder?
Thanks,
Toby

 

[foxdev]

It could be different on each server, but usually when Merchant is installed on Apache it is in a folder off the root called htsdata. But this is really up to the individual hosting company. The data files are not in with the rest of the .MV files.

 

[kavukattu]

Thanks foxdev...but I have another question, hope i"m not being a pain:

I am trying to connect to a certain database,via ASP the issue is one of the tables is made up of the following:
products.dbf and products.dbt
I'm not exactly sure what the dbt is for, but maybe indexing?
Either way How do I specifiy to the connection object that the dbt file exists also?
Cause when I just connect to to the products.dbf file, the ASP server is trying to find, products.DBT, with the extension in all capitals, when it shoud be lowercase...how can I force it in?

I can connect just fine to tables without the DBT...
Thanks,
Toby

 

[foxdev]

The DBT file is the "memo" file; it is used to store variable length data. There is a bit that is set in the DBF file so that any ODBC program connecting to the DBF will automatically know that the DBT should exist.

As to the file extension upper/lowercase issue, I'm afraid I can't be of much help. You could try renaming them, but that might break Merchant. I take it you are not on Windows?