Working with MSSQL 2005

Forum related to ADO

Moderators: gto, cipto_kh, EgonHugeist

sandeep_c24
Expert Boarder
Expert Boarder
Posts: 158
Joined: 06.11.2005, 01:43

Working with MSSQL 2005

Postby sandeep_c24 » 21.04.2008, 00:51

Has anyone had any luck working with Zeos and MSSQL 2005?

One of our clients has decided to use MSSQL 2005 and we have not been able to gt this thing to work.

Any suggestions?

Sandeep

sandeep_c24
Expert Boarder
Expert Boarder
Posts: 158
Joined: 06.11.2005, 01:43

Postby sandeep_c24 » 21.04.2008, 01:17

I am using Zeos(ADO) with Clientdataset and I get following error

Project ZeosADO.exe raised exception class EOutOfMemory with message 'Out of memory'.

I think it is something to do with ADO stuff not being able to work with certain field types.

Sandeep

sandeep_c24
Expert Boarder
Expert Boarder
Posts: 158
Joined: 06.11.2005, 01:43

Postby sandeep_c24 » 21.04.2008, 08:08

I did a bit more investigation and it turns out that the way I imported the data changed the field type from normal Memo field to UNICODE memo. And the culprit was MS ACCESS. I had imported Postgres database into MS ACCESS and it was there it was interpreted as Unicode. This is the default behavior of Access 2002(or something not sure but read somewhere on the web).

So to fix my problem I exported metadata and data from PGAdmin as sql commands and then inserted into MS SQL 2005 and it seems to be fine. I'll do more tests at work and see if everything is ok.

Sandeep


Return to “ADO”

Who is online

Users browsing this forum: No registered users and 1 guest