Zeoslib Portal

I have changed GetColumns to return numeric and decimal column Size and Decimal digits correctly. It didn't work with Postgres 8.xx. I am not sure whether this fix will work for older versions or not. function TZPostgreSQLDatabaseMetadata.GetColumns(const Catalog: string; const SchemaPattern: string...

Hi Mark I have been trying to find what is going on, I don't have enough knowledge about COM stuff but I think it could be to do something with COM stuff. Any suggestions what I should look at or try to do. We had to move one of our clients to MSSQL2005 and it can be accessed only using ADO so it is...

I will use following definition then Sandeep

Is it ok to add a function like this function GetSupportedCharactersets : TStringDynArray; I don't want to return TStringList as the list will be created in this function and the user could forget to free it or if they use this function with try..finally and someone later changes something in the fu...

No, I am not creating any new connections or queries. I have a test app with one connection and one query and I close and open the query about 10 times. I was using FastMM4 to check why the memory usage was increasing. It could be because of increase in handles or some objects not being freed. I was...

I have a small app using ADO and MSSQL 2005 and it seems the memory usage keeps increasing. I looked at the task manger and I could see Memory and number of handles increasing.

I added FastMM4 to my project but it did not report any leaks. Does anyone have any idea as to what is going on?

Sandeep

Does anyone know how to drop Firebird database?

I had a look at the source code and I can see isc_drop_database but there is no method using it.

Sandeep

Hi martinalex I am working on something on Zeos and have changed following files. If you want you can try them and see if they work. These are just for testing purpose please don't use them in your real applications. src/component/ZSqlMetadata.pas src/dbc/ZDbcAdoMetadata.pas src/dbc/ZDbcASAMetadata....

Hi martinalex

It works for me with the FBCLIENT from 2.1 as well.

Sandeep

Hi martinalex

I just installed FB2.1 and used it with my app and it worked fine.

I did not uninstall FB2.0 but shut it down and I was using FBCLIENT from FB2.1.

I used protocol firebird-2.0.

Sandeep

I haven't downloaded FB2.1 but could you please tell what's not working?

Sandeep

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 ...

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

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

I had a look at the pgAdmin source code and this is what they do long encNo=0; wxString encStr; do { encStr=connection->ExecuteScalar( wxT("SELECT pg_encoding_to_char(") + NumToStr(encNo) + wxT(")")); if (!encStr.IsEmpty()) cbEncoding->Append(encStr); encNo++; } while (!encStr.Is...