Devart Forums

Hi,
I have a problem with TUniSQL component.
I want to insert a string that is encrypted... in a MySQL table but the string is changed.

Text that I want to insert
—•yu¯ÐßÊE<[©su¦¯˜¶•h¡†¥™²­˜¢¶¨zv\¶xi¨ž–ª©h~J—”ž˜—§–hb3{b@o›ÏØțשÒÌà˜uk

Text in MySQL DB
—•yuŻĐßĘE<[©su¦Ż˜¶•hˇ†Ą™˛­˜˘¶¨zv\¶xi¨ž–Ş©h~J—”žť˜—§–hb3{b@o›ĎŘțשŇĚŕ˜uk

Some characters are changed ....yu¯ to yuŻ
If I write this string in DB manualy it works ...

I try also with Parameters but is the same result. I changed the connection to UniCode,I try with charset UTF8 but I didn't find a solution.
What I did wrong?

Unidac version is 4.1.3
Delphi 2006

Thanks !

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!!!

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

It work
Thanks a lot!!!

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

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

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?

It's something very simple.
This is the table structure from Firebird

CREATE TABLE TASSE (
CODFAST VARCHAR(100) CHARACTER SET NONE DEFAULT NULL COLLATE NONE,
QUANT FLOAT DEFAULT NULL,
IMPORTO FLOAT DEFAULT NULL,
ALIQUOTA FLOAT DEFAULT NULL,
DESCRI VARCHAR(100) CHARACTER SET NONE DEFAULT NULL COLLATE NONE,
TIPO VARCHAR(100) CHARACTER SET NONE DEFAULT NULL COLLATE NONE);

and the virtualtable have the same columns....

the code:
....
virtualtable_TabTasse.open;

{populate virtualtable_TabTasse}
.....

uniloader_tasse.LoadFromDataSet(virtualtable_TabTasse);
...

I change the all columns to VARCHAR and I made a small test.....I inserted in the VirtualTable a record and try to use Uniloader...but I get the same error ...

I try even with TUniTable instead TVirtualTable...but it's the same..

Hi,

I have a problem with Tuniloader. When I use another database like MySQL or SQLite it work's fine but when I use Firebird I get this error

Dynamic SQL error
SQL error code=-842
Pisitive value expected

I'm missing something..?

Thanks

When I open the uniconnection the following error appears:

Connection clientlibrary differs from already active connection

On the ClientLibary property is the path to the sqlite3.dll, downloaded from http://www.sqlite.org/download.html

What can I do?