Page 1 of 1

Memo Fields as text in MsSql-DB

Posted: Mon 09 Jun 2008 14:20
by ualms
Hello,

we worked with MySql and MyDAC still now. Today a customer wants that we use a MsSql-Server. We tried to migrate some projects to MsSql by using UniDac. We changed the components with the migration wizard tool. Now we have several problems, but the memo fields are our biggest.
When we save a record in the database, it works, but after a refresh, we only see the first 2 or 4 characters. - When we use ADO or ZEOS components everything works fine. What will we have to do, to solve this problem?

Greeting,

Uwe

Does nobody use memo-fields and uniDAC?

Posted: Tue 10 Jun 2008 05:43
by ualms
I wonder there is no answer? :cry: :evil:

Does nobody use memo-fields and uniDAC?

Help please

Posted: Tue 10 Jun 2008 05:58
by Challenger
We could not reproduce the problem. Please send to UniDAC support address complete sample that demonstrates this problem and include script to create server objects. You can also try to reproduce it using UniDAC Demo.

We have the same problems with your unidac example

Posted: Tue 10 Jun 2008 07:51
by ualms
Hello,

we have the same problems with your example "UniDacDemo" when we only execute the compiled exe-file. Perhaps the problem is the database? We use MSSql-Server 8.0 (2000) and UniDac with Delphi7. When we switch to MySql in the example it works, but when we go to MSSql it doesn´t.

Many thanks for an answer.

Uwe

Solved problem

Posted: Tue 10 Jun 2008 09:35
by ualms
it seems to be the sql-server 2000. We tested on SQL-Server 2005 and it works!!

Many thanks

Uwe :wink: :cry: :wink: