; Sage 100 ProvideX ODBC Configuration
; Minimal configuration for best compatibility with Sage 100 Advanced
[SERVER]
; Default connection to use if not specified
default_connection = sage100
; Maximum rows to return per query
max_rows = 1000
; Query timeout in seconds
timeout = 60
[sage100]
; IMPORTANT: For ProvideX compatibility, use minimal settings
; Replace with your ProvideX DSN (usually something like SOTAMAS90)
dsn = YOUR_PROVIDEX_DSN
; Replace with your actual username
username = YOUR_USERNAME
; Replace with your actual password
password = YOUR_PASSWORD
; Company code (required for Sage 100) - typically a 3-letter code
company = YOUR_COMPANY_CODE
; Always keep readonly mode for safety
readonly = true
; NOTE: For ProvideX compatibility:
; - Use minimal settings as shown above
; - Avoid adding extra parameters that may cause connection issues
; - The connection uses autocommit=True automatically for ProvideX drivers