Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I need to connect an application to my DB2 database. Both application and db are running on the same machine.

I've tried this:


Server=localhost:50000;Database=myDataBase;UID=myUsername;PWD=myPassword;

I'm getting the following error:

CLI0124E Invalid argument value. SQLSTATE=HY009

Am I using the wrong connection string?

Edit I've also tried the following format:


Provider=IBMDADB2;Database=urDataBase;Hostname=urServerAddress;Protocol=TCPIP;Port=50000;
Uid=urUsername;Pwd=urPassword;

Same result.

share|improve this question
    
are you connecting with JDBC? ODBC? –  Chris Aldrich Sep 9 '13 at 15:14

2 Answers 2

Not sure where you got those connection strings. According to the documentation, the provider you use needs three keywords: DSN, UID, and PWD. DSN refers to the Windows data source, which you define as usual after installing the DB2 Data Server Client software.

share|improve this answer
up vote 0 down vote accepted

The application was asking for a connection string, when all it really wanted was the Database name. I'm not sure why the field is named Connection String...

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.