Oledb Provider With Transaction Support?
i downloaded oledb provider from mysql.com, i use Delphi's ADO. but i found that this oledb provider does not support transaction.
is there any oledb provider that does support transaction?
View Complete Forum Thread with Replies
Related Forum Messages:
OLEDB Provider For MySQL
I'm looking for an OLEDB provider for MySQL. The MySQL website just have some old reference about it. There's some part where it is mentioned but then it points you to the .Net provider which is not the same. Then I found a direct link to download some named MyOLEDB 3.0 which date is 2001! So, I want an OLEDB provider to use MySQL with the Ado components in Borland's Delphi. Is it the only path to use the "OLEDB provider for ODBC" and then the MySQL ODBC Driver the only way to work with MySQL on Delphi?
View Replies !
Querying For Transaction Totals And Last Transaction Date
I have a list of currency transactions made by users. I need to generate a list of users along with their transaction total (sum for each user) AND the date of their last transaction. Sound doable? MySQL 4.1 Data looks like this: user, amount, date ============== 1, 50, 2003-11-23 2, 34, 2004-10-04 3, 45, 2005-08-30 3, 98, 2006-04-02 3, 76, 2000-02-03 2, 91, 2000-12-04 1, 11, 2003-11-05 3, 22, 2003-03-06 4, 34, 2006-03-07 5, 45, 2006-06-24 I figure I can group by userID but how do I get the date of the most current transaction? Using the data above, the query would return: 1 (user) 61 (subtotal) 2003-11-23 (last transaction) 2 (user) 125 (subtotal) 2004-10-04 (last transaction)
View Replies !
Oledb Connector
Is there an oledb connector for MySQL 4.x and where can i find it? On the MySQL website i can only see a connector for MySQL 3.x
View Replies !
MySql Via OLEDB
Well I'm new to MySql (coming from MS SQL Server) but I like what I see. i'm running 4.1.0. Problem is it seems that MySql is developing along real well but the MyOLEDB driver is stuck and going no where. Any one know if there is a better (up to date) OLEDB driver. It does not have to be free but I would like to try it before paying.
View Replies !
MySQL OLEDB
Anyone know of a free OLEDB Driver for MySQL?One of my co-workers looked for one and could only find one that you had to pay for.
View Replies !
MYSQL OleDb Connection String
I have this connection string "Provider=MySQLProv; Location=localhost; Data Source=test_db;User ID=testuser;Password=testpass"; It works fine on the local host. However I need to connect to a data source on a different computer so I put in the host name for location and Im supposed to be able to use PORT=my_port_num for the port but whenver i use this string "Provider=MySQLProv; Location=localhost; Data Source=test_db;User ID=testuser;Password=testpass; Port = 9999"; it comes up with a dsn box to fill in the port.
View Replies !
Least Cost Provider
The rows look like 1 TX CompanyA 2.25 2 TX CompanyB 2.00 3 NY CompanyB 3.00 4 TN CompanyA 1.25 5 TN CompanyB 1.50 to get the cheapest rate and provider for each location. Results: TX CompanyB 2.00 NY CompanyB 3.00 TN CompanyA 1.25
View Replies !
NySQL Hosting Provider
would be interested in any advice since this is new territory for me -- my experience has only been with Access so far, and for situations where only I could modify the database. But now I have a web application where lots of users need to have password access and be able to modify their own data etc, and where I need to be able to administer the whole thing.
View Replies !
Recommendation For A MySQL Ole DB Provider
I am developping with Visual Studio 2003 + C# + MySQL 4.1 and the OleDb components and am wondering which MySQL OLE DB provider to use. Right now I am using an Ole DB provider for MySQL which I found on www.MySQL.com, but it was written in Feb/2001 and I am wondering if it could be the source of my many problems. I mean, it's great that current Microsoft tools are backward compatible, but I am sure more performant OLE DB drivers have been written for MySQL since. Any OLE DB MySQL developer out there who can help make a recommendation?
View Replies !
Cannot Open File Provider=MSDASQL.1;
I'm using Navicat to import some tables into my MySQL Database but I get a weird error and was wondering if anyone around here knew how to resolve it. I feel like it's because I'm trying to make a SQL Server Database and MySQL Database, maybe I need some drivers. The error is: Cannot open file Provider=MSDASQL.1; Persist Security Info=False;....
View Replies !
ADO Error - Data Provider Or Other Service Returned An E_FAIL Status.
I am passing this simple query to MySQL through ADO: SELECT * FROM Images WHERE MasterKey=4313; MySQL returns this result from the command line: mysql> SELECT * FROM Images WHERE MasterKey=4943 ORDER BY OrderNo; +---------+-------------+-----------+----------+-------------+----------------+----------+---------+------------+ | ImageID | Path | MasterKey | Comments | RotateAngle | TimeStamp | CDLetter | OrderNo | EmailByRef | +---------+-------------+-----------+----------+-------------+----------------+----------+---------+------------+ | 28438 | C:img1.JPG | 4943 | | 0 | 20030605080500 | | 1 | 0 | | 28439 | C:img2.JPG | 4943 | | 0 | 20030605080500 | | 2 | 0 | | 28440 | C:img3.JPG | 4943 | | 0 | 00000000000000 | | 3 | 0 | | 28441 | C:img4.JPG | 4943 | | 0 | 00000000000000 | | 5 | 0 | | 28442 | C:img5.JPG | 4943 | | 0 | 00000000000000 | | 6 | 0 | | 28443 | C:img6.JPG | 4943 | | 0 | 20030605080500 | | 7 | 0 | | 28444 | C:img7.JPG | 4943 | | 0 | 00000000000000 | | 8 | 0 | | 28445 | C:img8.JPG | 4943 | | 0 | 00000000000000 | | 9 | 0 | | 28446 | C:img9.JPG | 4943 | | 0 | 00000000000000 | | 10 | 0 | | 28447 | C:imgA.JPG | 4943 | | 0 | 00000000000000 | | 11 | 0 | +---------+-------------+-----------+----------+-------------+----------------+----------+---------+------------+ 10 rows in set (0.03 sec) (I did change the field `Path` to make the grid a bit smaller) When sitting on the second record, I attempt rs.MoveNext() to advance to the third row in the recordset (note that field `TimeStamp` is zeroed out). I then get an error produced by the ADO Cursor Engine with description Data provider or other service returned an E_FAIL status. I've done other testing and it only seems to fail when a field is NULL in the next record. Setting the `TimeStamp` on the third record (`ImageID` = 28440) to a valid date allows me to use rs.MoveNext() to access that row. Also, Field `TimeStamp` is defined in the table description as allowing NULL's. This is becoming quite frustrating. The control center and the command line return the correct records, but ADO is getting stuck.
View Replies !
START TRANSACTION
After START TRANSACTION but before COMMIT, are intervening SQL transactions visible to other threads or processes? I understand that failing to perform a COMMIT, or explicitly performing a ROLLBACK, results in the transactions occurring after START TRANSACTION being undone. But until and if the transactions are undone, would queries to the database reveal those transactions?
View Replies !
Transaction Viewer
I'm writing an application that displays a list of transactions from a mysql database. The problem I am having is I need the user to be able to view the last x transactions but there needs to be an initial row with the "balance forward" from the previous transactions. Is there any mysql statement for this or class for this type of feature or can point me in the right direction?
View Replies !
Transaction Logging
I am reading up on transaction logging, and am wondering whether MySQL's binary log is its "UNDO/REDO log"? I'm a beginner to all this, and not sure whether that's the correct interpretation of the MySQL binary log. How does MySQL's transaction logging, or any transaction logging mechanism, work? I was reading up on general transaction logging principles but it was getting far too specific to SQL Server and other DBMSs, so I figured that I could come here and someone here might point me to some MySQL-specific resources on this, or perhaps help to explain how this all works. e.g. Does the transaction log get rid of all transactions once committed, what's the difference in how UNDO and REDO logs work, are these logs stored in a more complex manner than just logging the plain text statement (I'd imagine so, because otherwise how would an undo operation work)? In fact, I find it funny that I'm asking all the questions above because I'm still not quite clear on what the purpose of transaction logs is in the first place! While it would be great if somebody could help clear up the confusion I'm having, it would also be good if you could point me to some MySQL-specific resources on this topic. I browsed through the MySQL documentation and did a web search, but either did not find any resources period, or did not find resources that "dumbed it down" enough for me.
View Replies !
Row Locking In A Transaction
I've read that any selct statement issued in a Transaction will lock the resulting rows in the record set until the transaction is either COMMIT or ROLLBACK is issued. well what happens in the following situation.... A user workin in a content management system begins a transaction and within that transaction a SELECT statement is used on a table to populate a drop down menu with options. The drop down options are also used as menu options elsewhere on the site. If that statement selects all the rows in that table, does that mean that every row in that table will be unavailable to any other request until this user is done the transaction? If this is the case, is there a way to NOT lock rows with certain statements in the middle of a transaction without ending the transaction?
View Replies !
Transaction Performace
Im going to develope a massive website that going to handle morethan 10,000 transactions perminute(my Assumption). Is it possbile with MySQL Database to Handle 10,000 concurrent Users? Will MySQL take this much of load?
View Replies !
Transaction Control
I am a recent user in mysql and I'd like to know if I need control the transactions in java when I am using mysql. I am asking it because I have read the mysql already control the transactions automatically, that is, it automatically control the commit and roolback commands.
View Replies !
Transaction Processing
When doing an update in mysql in a multi-user session eg webpage/php/mysql , how do i have transaction locking on tables. As required data is being updated i don't want other users accessing it?
View Replies !
Function Transaction
I'm working on a little framework based on SQL, i'm fighting with session becouse i'm need to check if the user is login or not and then if can see the resource or not, it's can be change for each resource. Code:
View Replies !
Count Of The Last Transaction
When you perform any type of query, and the very next thing that you want is to find out how many rows were effected, what is that called? In SQL Server you can set the @@RowCount to a variable for later use. I am trying to determine what that same thing is called in MySQL
View Replies !
Transaction And Two Tables
a little confused about transactionts on Mysql. I have such situation: Two different tables, I need to add many rows to the first table and after those rows are added I need to add one row to the second table... My question is how do I use transaction on two tables at the same time (no problems when dealing with just one table), because it's needed to success on all queries to both tables, if one fails, then rollback to starting point.
View Replies !
LAST_INSERT_ID() In START TRANSACTION
I have a transaction that runs a 3 insert statements. The first inserts an record into the "patientsmain" table, generating a patient ID key (PATNR). The second inserts into "patientdetail" table, this has a foreign key (also called PATNR), which I populate using LAST_INSERT_ID(). The 3rd insert goes into "patientpanel" table, it is similar to the 2nd INSERT. This table also has a PATNR foreign key but using LAST_INSERT_ID() here fails as it takes the ID generated by 2nd INSERT rather than the 1st INSERT. How can I have the 3rd insert (or subsequent inserts) use the ID generated by my first insert? Code:
View Replies !
How To Cleanup Transaction After Crash
After a file-system full on my mysql server, the server stop and can't restart. I suppress file on that file-system to free more place, and I try to start MySQL server, but it don't want. In hostname.err, I have these messages : 090116 10:21:16 mysqld started 090116 10:21:16 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 090116 10:21:16 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 5 789480598. InnoDB: Doing recovery: scanned up to log sequence number 5 789480633 InnoDB: 1 transaction(s) which must be rolled back or cleaned up InnoDB: in total 23 row operations to undo InnoDB: Trx id counter is 0 19873536 InnoDB: Starting rollback of uncommitted transactions InnoDB: Rolling back trx with id 0 19873094, 23 rows to undoInnoDB: Error: trying to access page number 310308225 in space 0, InnoDB: space name /opt/mysql/mysql/data/ibdata1, InnoDB: which is outside the tablespace bounds. InnoDB: Byte offset 0, len 16384, i/o type 10 090116 10:21:16InnoDB: Assertion failure in thread 1 in file fil0fil.c line 3922 mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. key_buffer_size=0 read_buffer_size=131072 max_used_connections=0 max_connections=100 threads_connected=0
View Replies !
Transaction Timing Query
I have a query about Transactions. I have created a script that will delete a set of entries from a table, and then add updated ones, however only a small percentage will change. In order to prevent any accidental deletion of the whole table, I have wrapped the script up as a transaction. But What I am wondering is how long does MySQL wait before automatically issuing a rollback statement? e.g. an extract from the script looks something like this: START TRANSACTION DELETE FROM tab1 WHERE id = '100'; INSERT INTO tab1 SELECT * FROM tab2 WHERE id = '200'; COMMIT; so if there was a problem and the script stopped after the "DELETE FROM tab1 WHERE id = '100';" command, how long until MySQL would realise nothing else was forthcoming (or worse yet, what if only the "Delete from tab1" was actioned before something prevented the rest of the script from being seen!).
View Replies !
Timeout Transaction InnoDB
I have a application with invoice and invoice_items, but i need used transaction to save records. If only user save data this fine. But if two users save data same time, one users save correctly and another user go to rollback directly, if second user save data again this ok. InnodBd Documentation have a timeOut transaction = 50 Secs. But, the application save all records in about 2 secs. The sintax is the next: Code:
View Replies !
Transaction Secure Code
When executing a specific query, I need to lock the db to ensure that no data is altered while the query executes. My question is: Do I need to take a ROLLBACK on the db to release the lock, or is it enought just to set autocommit=1 again? Simplified example of how I do it now: SET AUTOCOMMIT=0 BEGIN SELECT .......bla bla bla <execute some php code based on the result> ROLLBACK SET AUTOCOMMIT=1 Example of how I want it to be: SET AUTOCOMMIT=0 BEGIN SELECT .......bla bla bla <execute some php code based on the result> SET AUTOCOMMIT=1 Are there any downsides by not using ROLLBACK in the second example? The database has not been altered in any way.
View Replies !
How To Determine If Transaction Has Been Started?
I am wondering if there is a way to determine if a transaction has been started? For example: BEGIN [way to determine if transaction has been started returns 1] COMMIT [way to determine if transaction has been started returns 0] As you can see, this functionality that I am looking for will determine whether the BEGIN call has been called since session start or since the last COMMIT or ROLLBACK. Anyone know if this available?
View Replies !
Creating Transaction In Stored Procedures
I am working on a project at University using php, mysql and apache. The web application should should interract with the database system using stored procedures and transactions. I know how to create stored procedures in mySQL but I am not sure how to implement the transactions into it. The following php code needs to be stored procedure in mySQL: <? php $query = "SELECT * FROM item ORDER BY name"; @mysql_query("BEGIN"); $result=mysql_query($query, $this->db_connection); if(!$result) { @mysql_query("ROLLBACK"); return $result; } else { @mysql_query("COMMIT"); return $result; } ?>
View Replies !
Automatic Rollback Transaction In Mysql
I have mysql automatically abort an entire transaction if one of the statements produces an error ? I can use procedure for checking error_count at the last line of my transaction. But if I want to automatically rollback instantly when the error occurs in my transaction instead of going to the last line of transaction. Can i do this in MySQL?
View Replies !
Transaction Inside A Stored Procedure
I am trying to make a transaction inside stored procedure. But if there is an error or exception during execution of the stored procedure, the changes are still commited! Here is the simple example: ....
View Replies !
What Type Of Transaction [isolation Level] Do I Need?
Part of my web application needs to perform the following action: User A UPDATES field "hits" in table X, increaseing the value of X +1. User A then SELECTS the new value of field "hits" that they just increased. If I have multiple concurrent users the following scenarios can occur: User A: UPDATE field "hits" + 1 (ex, 49 to 50) User B: UPDATE field "hits" + 1 (ex, now 50 to 51) User A: SELECT val from field "hits"(should be 50, not 51!) User B: SELECT val from field "hits" (should be 51) What type of transaction or transaction isolation level do I need so that when 1 user updates the field "hits", they can then get the value of "hits" that THEY CHANGED IT TO?? I'm using an InnoDB table & mySQL.
View Replies !
Using Transaction In C# Lock Time Out Problem
I am using Innodb.I have grid and a list of item. Then I run a loop and based on it i will run an update statement which is all in block of transaction. A snippet of the code is as below . MySqlConnection connectionCentral; MySqlTransaction transactionCentral = null; connectionCentral = new MySqlConnection("Address='localhost'Database='trial1'User Name='root'Password=?'"); connectionCentral.Open(); transactionCentral = connectionCentral .BeginTransaction(); for (int j = 0; j < gridReceiveTransfer.RowCount; j++) { String myUpdateQuery8 = "Update tblProduct " + "Set tblProduct.branch1 = tblProduct.branch1 +" + Convert.ToInt32(this.gridReceiveTransfer[8, j].Value.ToString()) + " Where tblProduct.productID=" + Convert.ToInt32(this.gridReceiveTransfer[0, j].Value.ToString()); MySqlCommand myCommandCentral1 = new MySqlCommand(myUpdateQuery8); myCommandCentral1.Connection = connectionCentral; myCommandCentral1.Transaction = transactionCentral; myCommandCentral1.ExecuteNonQuery(); } This how i have actually code my code in C#. The error I get is "Lock wait timeout exceeded; try restarting transaction". I know why I get the error is sometime when the update is for the same productID within the same loop. So how can I overcome this problem where I want to keep all the updates within the loop so incase there is one error I want to rollback the whole thing.
View Replies !
Max Sequence Number In Claim Transaction Table
have a table that contains a transactional history showing how a claim amount has changed over time. Each time the claim amount is updated, a new claim sequence number is used. The fields I have are Claim Number(CLMKYT), Claim Sequence(CLMSQT), Claim Amount(£)(OUTSTT) and Date the claim was entered/updated (EFFDTT) I want to pull out the latest (most recent) claim amount for each claim as at any particular date. I have the below query which I think almost gets me there, but not quite! Code: .....
View Replies !
|
TRACKER
