Zeoslib Portal

The following worked:

1. connect to server without database name
2. connection->ExecuteDirect("USE [abc!def!ghi]")

Hi, I'm trying to connect to a MSSQL database with special characters ! in the name, say abc!def!ghi. Now I get error "cannot find database abc". It seems the ! is interpreted as string separator. When I try [abc!def!ghi] then I get the error "unclosed quotation mark after 'abc!def!' ...

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Pharos_BRN.accdb;Persist Security Info=False

does the job, thanks for your hint

.mdb is OK, but how to connect .accdb (Access 2010)?

Hi Michael I only know roughly what is a deadlock. AFAIK it works as follows. When you update a row in a table, the dbms does the following: 1. put a lock on that row (to prevent simultaneous updates by different processes) 2. update the row 3. removes the lock. When step 3 fails and another user/pr...

Hi, I'm using ZEOS7 in CBuilder XE with MySQL. When executing a number of consecutive transactions I frequently get a deadlock message: '...raised exception class EZSQLException with message 'SQL Error: Deadlock found when trying to get lock; try restarting transaction'. I've tried: try { bool suc =...

Hi,
Is it possible to connect MS-Access with ZEOS lib?

Henk

Thanks for all work. I will stay using rev 1171 and reporting bugs.

Regards,
Henk

It works!

Now I used zeoslib/branches/testing (indeed rev 1171)
Is that equally safe as /trunk? Can I use it anyway?

I'm not very skillfull with SVN. When I call Updat SVN in my ZEOS rootmap, I get message "completed at revision 1176", but I don't see anyting transferred or changed...

Egon, I don't know anything about the code. The functionality is there, for it does work for e.g. integer, float, datetime parameters. Only when I use text there is an error. The assignment succeeds: ZSQLProcessor1->ParamByName("message")->AsString = rvMsg; for when I check it: UnicodeStri...

Thanks, that works.

In CBuilder6 / ZEOS6 parameters in ZSQLProcessor did work!

Hi, I've a problem with inserting text data (MySQL; ZEOS7; CBuilder XE). I create a table: CREATE table test(id int not null, txt TEXT null) Engine=InnoDB; Next I want to insert data: ZSQLProcessor1->Script->Text = "insert into test (id, txt) values(:id,:txt)"; ZSQLProcessor1->ParamByName(...

The stored proc aProc in MySQL 5.1 returns a resultset (last line such as "select * from sometable"). In the SQL property of a TZReadOnlyQuery I have "call aProc(pars)". And when I call Query->Open() then the error appears. I think it's the same problem that lelekx reports in htt...

Hi, I've just started with ZEOS7 in CBuilder XE. In my app in CBuilder6 with ZEOS6 I used a TZReadOnlyQuery wich calls a stored procedure (MySQL): in the SQL property I have "call proc()". In the new situation I get the error "PROCEDURE can't return a resultset in the given context&qu...