Working with MSSQL 2005

sandeep_c24 · Post by **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 · Post by **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 · Post by **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