Page 1 of 1
Working with MSSQL 2005
Posted: 21.04.2008, 00:51
by sandeep_c24
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
Posted: 21.04.2008, 01:17
by sandeep_c24
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
Posted: 21.04.2008, 08:08
by sandeep_c24
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