Extended dynamic disabled error

The IBM® i Access ODBC driver displays the Extended dynamic support disabled message when a SQL package is unusable. To correct the problem :

  1. Delete the SQL package on the system so that when you run your application the package will be created with your default package settings
  2. Change the SQL default library connection string setting to match the setting that is saved with the SQL package
  3. Switch theReturn code for unusable package ODBC DSN setting to Ignore or Warning. Alternatively, you can get this same behavior by setting the PKG connection string setting.
  4. Disable the XDYNAMIC connection string setting.