|Date Added:||10 March 2007|
|File Size:||62.2 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Both answers are correct, but only have the links to were the answers are. A User data source is only visible to the currently logged on user and is only available on the instzll machine. A File data source can be shared by all users who have the same drivers installed.
I don’t want to use linked servers. General Tab Data Source Name: Create a new data source as described above. This launches Microsoft Query, if it is installed. Email Required, but never shown. In the Data Sources folder, expand the data source you just created, double-click Test, and then log in. In the meantime, content will appear in standard North American English. Communications Tab Network Connection: If you pass the Transfer test, but fail the DRDA test, check security for the database you are trying to attach to.
How To Set Up ODBC Connectivity To An AS/400
Continue the installation, accepting the default values. Data sources store information about how to connect to a insgall database. Socket Timeout Value sec: One last prompt asks which cell to put the data in, and then the data is inserted into your spreadsheet.
IBM Where are the ODBC drivers that access DB2/ on the iSeries? – United States
You will be prompted to configure a data source if you selected the “Configure a data source” check box as instructed above.
Cid 1, 1 14 Type a description for the data source. Click Next, and then click Finish.
Browse to or enter the name of the file data source you want to save the connection to. The translated version of this page is coming soon. You can download DB2 clients for your DB2 version from here: