Problem with connection to DB2

softwestteam · Post by **softwestteam** » Thu 07 Apr 2011 08:34

I installed DB2 Express-C on my Delphi station. I create a new database and I try to connect my application to that database but I get this error

[IBM][CLIDriver] CLI0124E Invalid argument value. SQLSTATE=HY009

Uniconnection Configuration:

ProviderName=DB2;
Database=newdatabase;
host=localhost;
port=50000;
username:db2admin;
password=1;

What I'm doing wrong?

AlexP · Post by **AlexP** » Fri 08 Apr 2011 08:52

Hello,

Probably, the problem is connected with the database settings.
Please try to connect to your database over standard IBM DB2 Control Center, if you get the same error please check your database settings, otherwise contact us again.

softwestteam · Post by **softwestteam** » Fri 08 Apr 2011 09:00

DB Control Center works.. I create databases, tables,users...but when I try to access a database with Unidac I get that error...

softwestteam · Post by **softwestteam** » Sat 09 Apr 2011 14:43

I'm running out of time .. Help please?
Thanks

AlexP · Post by **AlexP** » Mon 11 Apr 2011 08:59

Hello,

To solve the problem you should use your database alias instead of the server name like

UniConnection1.Server:= 'TOOLSDB';

softwestteam · Post by **softwestteam** » Mon 11 Apr 2011 09:38

It work
Thanks a lot!!!

AlexP · Post by **AlexP** » Mon 11 Apr 2011 09:51

Hello,

Glad to see that the problem was solved. If you have any other questions, feel free to contact us.

softwestteam · Post by **softwestteam** » Mon 11 Apr 2011 17:34

Hello
I have another problem
When I use a UniLoader I get this error.

[IBM][CLI Driver][DB2/NT] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.SQLSTATE=22001

The table that is loaded is very big (over 200.000 records)
With other database like Firebird, SQLite, PostgreSQL it work.

Thanks

AlexP · Post by **AlexP** » Tue 12 Apr 2011 11:36

Hello,

I could not reproduce the problem.
I have tested it on a table with more than 200 000 records, and all works fine.
Maybe the problem isn't connected with the number of records, maybe it's connected with some values or types of fields in the table.
So please provide the script to create the table.

softwestteam · Post by **softwestteam** » Tue 12 Apr 2011 12:38

I enlarged some string fields and everything it's working now.
It's interesting because I load a DBF table that have the exact structure as the DB2 table
Thanks a lot!!!

AlexP · Post by **AlexP** » Tue 12 Apr 2011 12:52

Hello,

Nice to hear that you solved the problem.

Devart Forums

Problem with connection to DB2

Problem with connection to DB2

DB2 Control Center works

It work!