Libraries: AdoSuite v 1.0

New comment
 

AdoSuite v 1.0:

Classes for working with databases through ODBC and OLE DB interfaces.

When it comes to processing of large data amounts, it is not very rational to use files. For this purpose database management systems (DBMS) have been developed. There are already some solutions written in mql4 for interacting with different DBMS'es, and now I want to share my library written in mql5.

It allows you to:

  • Work with most of the popular databases using built-in ODBC and OLE DB providers
  • Write data providers for specific databases to extend the functionality or increase the perfomance
  • Catch exceptions and provide the error information into the calling code
The library is provided with documentation and some sample code. Hope, it will help you to make a startup.

Author: Alexander

 

Downloaded it and the download counter didn't increase.

 
Integer:

Downloaded it and the download counter didn't increase.

Don't worry, it will increase by +10 when you download 10 times (to put it exaggeratedly).

 

The following problem: everything works with nested adotest.mdb, but when I create my own file, it fails:

COleDbCommand::ExecuteNonQuery(set) method threw an exception of type InvalidOperationException:
An open and available connection is required for ExecuteNonQuery. The connection is closed.

 

The first trouble was Windows 7.

Tried it in WinXP -

Cannot open 'C:\Program Files\Meta Trader 5\MQL5\Libraries\AdoSuite.dll' (1114)

:(

 
jmp:

The following problem: everything works with nested adotest.mdb, but when I create my own file, it fails:

COleDbCommand::ExecuteNonQuery(set) method threw an exception of type InvalidOperationException:
An open and available connection is required for ExecuteNonQuery. The connection is closed.


Do not use the first letter of the file name control code like: r, n, t...

or put another slash:...\\\t....

conn.ConnectionString("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\1\\test.mdb;Persist Security Info=False");

 
I don't know why, but the following line: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MQL5\Files\book.xlsm;Extended Properties="Excel 8.0;\""

Glitches wildly, xlsm opens only if opened in excel, can't extend range, etc.

But here : "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=MQL5\Files\book.xlsm;Extended Properties=\"Excel 8.0;\""

Works great! :)

Thank you very much to the author!)))

 
Is there a 64 bit version?
 
For working with MySql, does anyone have a normal class?
 

Please correct:

 
Graff:

Please correct:

Who are you asking to correct?
You don't delete connection and command objects, but the COdbcParameterList object seems to be deleted with the command.
1234
New comment