Fw: Borland may have fixed the dbExpress driver for MySQL transactions

Heikki Tuuri

Hi!

Many people have complained over years that Borland's dbExpress driver does
not work with MySQL and transactions, because it disconnects from mysqld
after each SQL statement. The postings below suggests that this problem
might now be fixed by Borland.

Best regards,

Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a non-free hot backup tool for MySQL
............
From: Ramesh Theivendran (rt**********@b orland.com)
Subject: 20483: dbExpress MySQL 4.0.x Beta driver
View this article only
Newsgroups: borland.public. delphi.database .dbexpress
Date: 2003-08-15 17:52:29 PST

MySQL 4.0.x Beta available in Code central. Will be updated with the
remaining bug fixes soon.

T.Ramesh.

From: Ramesh Theivendran\(Bo rland\) (Ra************ ****@borland.co m)
Subject: Re: 20483: dbExpress MySQL 4.0.x Beta driver
View this article only
Newsgroups: borland.public. delphi.database .dbexpress
Date: 2003-08-21 17:46:26 PST

Nikola,
I will have to investigate the issue with LAST_INSERT_ID( )

since dbExpress MySQL driver disconnects from
server with every query :(.
No, dbExpress driver don't disconnect after every query. My guess is, it
could be either because of the issue with cloning connections in the
components or with MIDAS ApplyUpdate()co mmiting a transaction. Anyway, once
i investigate more i'll know.

T.Ramesh.

............... .............

"Nikola Savic" <ni****@mediani s.net> wrote in message
news:3F******** ******@medianis .net... Ramesh Theivendran wrote:
MySQL 4.0.x Beta available in Code central. Will be updated with the
remaining bug fixes soon.

Dear Mr. Ramesh,
does new dbExpress driver for MySQL 4.0.x support auto_increment
fields when used as primary keys ? We have a lot of problems working
with MySQL/dbExpress combination, since there is no way to automatically
get newly generated primary key. When MySQL function LAST_INSERT_ID( ) is
used, it returnes 0, since dbExpress MySQL driver disconnects from
server with every query :(.
We were ready to write our own dbExpress driver, but there was no
details online on how it should be done.

I hope you can help us with this big problem, which is, I'm sure,
stoping a lot of developers to use Delphi with MySQL in right and most
productive way !
LOGIK

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1

Subscribe Reply

3326

Similar topics

2447

odbc driver manager

by: avihay | last post by:

Hello, Using .NET 1.1 and MS visual studio 2003 we are failing to close an ODBC Connection to an ODBC driver using system.data.odbc. We are getting the following Error from the Microsoft odbc driver manager : "DIAG Invalid transaction state (0). We understood that this Error message has to do with

.NET Framework

1583

Fw: Borland may have fixed the dbExpress driver for MySQL transactions

by: Heikki Tuuri | last post by:

MySQL Database

648

Using MySQL 3.23 Driver with MySQL 4 (and Borland dbExpress Drivers)

by: Simon Hodgson | last post by:

I've been playing with the Borland dbExpress Drivers, and it would appear that Borland only have beta drivers for MySQL 4.x.x However it would also appear to be possible to access a MySQL v 4.x.x database using the 3.23 client libraries (i.e just get libmysql.dll from 3.23) can here see any problems in doing this? The only ones I can see is we'll loose some features such as the ability to use encrypted SSL connections.

MySQL Database

3118

How to fetch or store a BIGINT using dbExpress and Delphi 2005

by: Jon | last post by:

Since there is no native support for 64bit integers in dbExpress, it is not trivial to fetch a BIGINT from SQL 2k. If it is possible, how can a BIGINT be fetched using TParam or TField? Any help appriciated

Microsoft SQL Server

2140

MySQL is making me nuts!

by: smorrey | last post by:

Hello all, this might better be suited for the MySQL newsgroup, but I figured I'ld post here and see if anyone can help me. I'm trying to create a simple transaction handling system where users pay eachother via points of a sort. I have a table where each transaction is stored, in a single row. It looks like this transid,from_user,from_amount,to_user,to_amount

PHP

2089

DBexpress with DB2 questions

by: tonymeadors | last post by:

Hello, We are devoting thousands of man hours doing what many of you have had to do - covert tons of code from BDE to dbexpress(d7). After a month, we have all of our apps compiling and working pretty well with Interbase. Now the real work begins - getting them all to work with Oracle, MSSQL and DB2.

DB2 Database

3747

Wrong string length from unicode database in Borland's app

by: Alex Guryanow | last post by:

Hi, I have windows app written in Borland C++ Builder 5.0. Using ODBC driver windows app connects to database on linux server. Database is created with UNICODE encoding. When pg-server is version 7.1.3 windows app works fine, but when pg-server is version 7.4.6 or 8.0beta4 under certain conditions the app receives strings with wrong lengths. For example: the database contains table "issue" with the following structure:

PostgreSQL Database

7250

Export C++ class from a Borland DLL and use it in Microsoft VC

by: Fabry | last post by:

Hi All, I'm new of this group and I do not know if this is the correct group for my question. I have a DLL with its export library (.lib) wrote in Borland C++ 6. In borland everything is OK and I am able to include the lib and use the class that i have exported creating an instance with new etc... I would like to export this class in microsoft VC++ using the same .lib file. Obviously it doesn' t work.

.NET Framework

3966

Borland C++ and MySQL connection problem

by: arrow | last post by:

Hi everybody; I am trying to connect to MySQL server over MySQL ODBC 3.51 driver. Borland C++ 5.02 is the tool I use. I tried a simple connection code below: #include <stdio.h> #include <stdlib.h> #include "mysql.h"

C / C++

8991

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9541

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9370

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9321

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9247

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6796

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4602

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3312

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2215

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General