Memo Fields as text in MsSql-DB

ualms · Post by **ualms** » Mon 09 Jun 2008 14:20

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

ualms · Post by **ualms** » Tue 10 Jun 2008 05:43

I wonder there is no answer?

Does nobody use memo-fields and uniDAC?

Help please

Challenger · Post by **Challenger** » Tue 10 Jun 2008 05:58

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.

ualms · Post by **ualms** » Tue 10 Jun 2008 07:51

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

ualms · Post by **ualms** » Tue 10 Jun 2008 09:35

it seems to be the sql-server 2000. We tested on SQL-Server 2005 and it works!!

Many thanks

Uwe

Devart Forums

Memo Fields as text in MsSql-DB

Memo Fields as text in MsSql-DB

Does nobody use memo-fields and uniDAC?

We have the same problems with your unidac example

Solved problem