How to install ibm db2 odbc driver on windows 7

The URL is a string text with a specific format, containing information about the host where the database is running, the port, username, database name, etc. The format is specific to each driver. Any wrong character in the URL may make the database connectivity fail, therefore we recommend installing DbSchema and try to get connected. Use the sample provided by IBM in the cfg directory to create the configuration. Also make sure to copy db2cli. DB2 also provides a utility to validate the configuration file: db2cli with the validate option.

Great article. I used A couple of hints: 1. At the command prompt, it seems the command to install has changed. Type: db2cli uninstall -setup Note: To access help, type db2cli -help 2. If run from a regular Command Prompt, installation will appear to complete correctly, but the required registry entries will not be added, and the driver will not appear in odbcad Hey Bob.. You saved my day…above command works in Windows 10 with 64 bit installation.

Thanks to this document I was able to finish my installation, so I want to give it an additional input in gratitude. As per DB2 Which are db2cli. Hello Dear, Very clear explanation which helped me a lot.

Thanks for the post. I dont wana use GUI. Password: nsfnda Port Number: Hostname: dfg-qwer-app. Many thanks for taking the time to share these details, it worked for connecting to an old DB2 v8. I followed all the instructions but I am facing below error. I get the following error after following these instructions. I get SQLN The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation.

Please advise on what can be done to resolve this issue. Thanks in advance. Your email address will not be published. Save my name, email, and website in this browser for the next time I comment. Skip to content. You need to create an IBM-account to download the file. The final settings should be the ones listed below. Hi Abhijeet, If I understand your problem correcly. Thanks a lot for your help. Clear set of instructions — been looking over lots of IBM pages for something like this.

Dr John. Hello, Same here. This only appies if you installed a 32 bit driver on a 64 system. Hi Victory Sorry for the late response. Hello Sir, Thanks for putting such a nice article. It was been of great help. Excelente tutorial, ya solo falta que lo ponga en practica.

Luego les cuento como me fue. Any suggestions are greatly appreciated. Active 4 years, 10 months ago. Viewed 62k times. Chow Chow 1 1 gold badge 2 2 silver badges 6 6 bronze badges. No free solution?? I need to access the database in the DB2 server. If it is not free to get odbc drivers, can you suggest any other way to connect to DB2 other than linked server? Add a comment. Active Oldest Votes. Both answers are correct, but only have the links to were the answers are.

To open odbc data sources in windows versions 7 upwards press the windows key type odbc click on the version you need 32 bit or 64 bit. For some reason, the hyphen that I copied from the above commands did not work. The above commands were simply showing me the usage instructions.

So I had to manually type "-i" and "-setup" after the commands.