Print Page - INI File and Data Dictionary

Title: INI File and Data Dictionary
Post by: Jeffrey Ferreira on October 16, 2024, 10:14:04 AM

I have a catalog.
If I just use The Data Dictionary - it works fine
If I just use the INI File - it works fine
If i use the Data Dictionary and INI File - it throws error on ini file files-> No Data Dictionary

can this be done?

Title: Re: INI File and Data Dictionary
Post by: Devon Austen on October 16, 2024, 11:45:10 AM

Yes this can be done.

What OS and what version are you using?

At what point do you get the error, during installation, setup, running the server, accessing data?

Title: Re: INI File and Data Dictionary
Post by: Jeffrey Ferreira on October 16, 2024, 02:06:57 PM

Hi Deven

Windows Server 2016
when i use excel to try and file that is when i get the error.
you know in msquery when you can slide fields from left to right.

jeff

Title: Re: INI File and Data Dictionary
Post by: Devon Austen on October 17, 2024, 07:58:03 AM

Hi Jeff

Does the data dictionary define a table that the INI file also defines?

I am unsure if that is supported or not.

I would remove any tables from the INI that are defined in the data dictionary for a test to see if it then works. You can make a copy of the INI file to modify for the test to make sure you don't lose it.

Title: Re: INI File and Data Dictionary
Post by: Stéphane Devouard on October 17, 2024, 10:36:14 AM

Hi

For what's it's worth

I have successfully used the ODBC driver in the past with old legacy files (non-normalized schemas and BIN/DEC encoded numerics) defined in an INI, and newer tables defined in provide.ddf/dde

So it used to work, as long as each file was declared either in the INI or in the ProvideX DD, but not in both

Regards

PxPlus User Forum

Main Board => Discussions => ODBC => Topic started by: Jeffrey Ferreira on October 16, 2024, 10:14:04 AM