Using microsoft access with db2

I would assume that installing the certificate on your machine should allow the connection to succeed, but I haven't tried that. In many cases, the wizard will prompt you to for things of that nature, or there will be an "advanced" option or something of that nature that can be used to configure things like this.

Was this reply helpful? Yes No. Sorry this didn't help. Thanks for your feedback. However the connection is only one way. We can gather but not update. Threats include any threat of suicide, violence, or harm to another.

Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect. Learn about the latest features including in the CData Connect Cloud data connectivity platform.

CData provides critical integration software to support process automation for local government. Follow the steps below to use Microsoft Query to import DB2 data into a spreadsheet and provide values to a parameterized query from cells in a spreadsheet.

This is the last step of the driver installation. To set a parameter in the query, you will need to modify the SQL statement directly. To use a parameter, use a "? Close Microsoft Query. The Import Data dialog is displayed. Enter a cell where results should be imported. Close the Import Data dialog. You will be prompted to enter a parameter value. Click the button next to the parameter box to select a cell.

Select the option to automatically refresh the spreadsheet when the value changes. If there is a workgroup system database , press "Lock" button to set it. Input the username default is "db2admin" and its password. Input the source DB2 database name in "Database" box.

Choose the DB2 schema name Press "Refresh" button to list all schemas. Click " Choose "Field Mapping" option, you can redefine the fields in the destination table, e. Click "Browse Log" to visit the full migration log. Click "Save as job" to save the migration settings to a job file, so you can "Load Job" to quickly reload the migration job in the future or run the migration job via command-prompt.