Sage Line 100 ODBC Reg Fix

[DaveJohnson]

Hi

When extracting data from a sage dataset the spare text fields are not shown, I know there is a reg setting which allows all fileds to be avaliable to the ODBC.

Can anyone let new know of the reg seeting needed, I cannot find it anywhere.

Thanks

 

[ChrisHiggins]

Open Regedit and go to

HKEY_LOCAL_MACHINE - Software - ODBC - ODBC.ini

then in the required ODBC section create an entry named

"IgnoreSpareFields" and set this to "No" (these are case sensitive)

you will also need to refresh (or somtimes drop and reconnect) the odbc links in your program before you will see the fields.

Hope this helps

Chris