mssql Archives - Firebird News

IBProvider News

May 22, 2020 Andrew Merkulov Leave a comment

Hello Everyone,

We released new updates of our components for work with Firebird and InterBase:

IBProvider v5.17
LCPI ADO.NET Provider for OLE DB v1.20
LCPI OLE DB Services v1.15

Also we created a new document – Integration Services. Using «LCPI ADO.NET Data Provider for OLE DB» as a data recipient.

Full news text – https://www.ibprovider.com/eng/news/n_200522.html

Kind Regards, IBProvider Team.

Release of IBProvider v5

February 14, 2019 Andrew Merkulov Leave a comment

We are proud to introduce the fifth version of our basic product for working with Firebird and InterBase.
IBProvider v5 inherits all the best from IBProvider v3 and dramatically improves the quality of implementation of the OLE DB components.
For the last few years, the main development line of IBProvider was fixing problems that prevented its stable operation. First of all, we had to fix problems not related to the provider itself — we rewrote the client for Firebird and the standard pool of OLE DB connections. It took a lot of time and resourses, but it was worth it.
Now the time has come to get to IBProvider itself.
Instead of local fixes, within the support of the third version we redesigned the inner infrastructure of the OLE DB components of IBProvider taking into account the entire experience gained over the last years. In part, the ideas were taken from our ADO.NET provider.
The main qualities of IBProvider v5 are reliability and fail safety…

Read full text of IBProvider v5 release.

With Best Regards, IBProvider Team.

IBProvider 3.18. Better support of MSSQL. Changeover to the new VS 2012 compiler

December 13, 2013 Andrew Merkulov Leave a comment

We are pleased to announce the new release of our OLEDB Provider: version 3.18.

Now in your projects for Firebird and Interbase you can more comfortable work with Linked Server of MSSQL 2012. Hurrah!

In new release:

Improved performance of the provider as a linked MSSQL server.
Provider compilation with Visual Studio 2012.

Plus:

Update of the article on configuration and usage of linked MSSQL server.
Update of the MSI installers.

You can download IBProvider here: Firebird and Interbase driver >>>

Dozens of new options for Firebird and .NET Framework

June 8, 2012 Andrew Merkulov

Hey!

If you have ever worked with Firebird or Interbase using the standard .NET provider for OLE DB (System.Data.OleDb), you will have likely encountered issues like this:

The necessity to add ALL parameters manually.
Even though the OLE DB provider supports parameter generation for commands, the .NET provider doesn’t use it, so you as the programmer must do that work on your own.
The lack of support for named parameters. Although they actually exist, using them in reality requires a whole set of complex manipulations (the steps needed to add a parameter to a collection, etc.).
The impossibility of using multiple DataReader objects at the same time (Multiple Active Result Sets).
No execution of SQL scripts which contain several SQL expressions per command.

This list of difficulties a .NET developer has to deal with is far from complete.

Now it’s all different in a fundamentally new ADO.NET Data Provider for OLE DB

IBProvider Team

#AnyDAC Winter 2012 v 5.0.5 – #Delphi Components for Firebird, Interbase and more

December 25, 2011 darefiev Leave a comment

DA-SOFT Technologies announces the availability of AnyDAC for Delphi Winter 2012 release v 5.0.5.2073 – high-speed, Universal Data Access Components for Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, MS Access, IBM DB2, Sybase SQL Anywhere, Informix, Advantage, dbExpress, ODBC, that simplifies the task of building Embarcadero Delphi, C++Builder and Free Pascal Compiler database applications.

AnyDAC for Delphi can be immediately downloaded from the download page.

What is new in v5.0.5 and what is AnyDAC ?

[See remaining text…]

AnyDAC v 5.0.5 Highlights

major TADTable and Live Data Window mode optimization;
Firebird v 3 support (packaged procedures, PSQL functions, identity columns, BOOLEAN data type);
Firebird COMPUTED BY support;
PostgreSQL v 9 support (named parameters, anonymous blocks, enums);
Interbase v 6, 7 support;
Advantage v 8, 9 support;
SQL Anywhere v 12 support;
SQLite v 3.7.9 support;
ElevateDB ODBC support;
ReportBuilder DADE;
Multiple enahncements to the help system.

And more.

AnyDAC for Delphi

AnyDAC is an unique set of Universal Data Access Components for developing applications on Delphi, C++Builder and Free Pascal. With its powerful common architecture AnyDAC enables native high-speed direct access to Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, IBM DB2, SQL Anywhere, MS Access, Informix, Advantage and more. For complete list of features and availability, please check:

AnyDAC home – http://www.da-soft.com/anydac/
AnyDAC shop – http://www.da-soft.com/anydac/order.html
AnyDAC trial – http://www.da-soft.com/anydac/download.html

AnyDAC Core Features

Native access to Firebird, MySQL, SQL Server, Oracle, PostgreSQL, SQLite, DB2, InterBase, SQL Anywhere, Informix, Advantage Database and more. Including latest DBMS versions.
Generic access to any database supported through dbExpress or ODBC data sources.
Optimized for best possible performance. 2 times faster than dbGo, 25% faster than dbExpress.
Reach API with 50 Delphi VCL components, including TADConnection, TADTransaction, TADQuery, TADStoredProc, TADTable, TADMemTable.
Unified API for cross-database access, including unified data type mapping, SQL dialect abstraction, connection aliases.
First-class support for many database-specific features, including backup, restore, validation, SQL scripting.
Advanced Data Access Options, including Array DML, Live Data Window mode, full Unicode support.
Delphi 5 to Delphi XE2, C++ Builder 5 to C++ Builder XE2, Lazarus / Free Pascal on Win32, Win64, Linux32, Linux64, Mac OS X.
Perfect integration as back-end driver for TMS AdvGrid, RemObjects Data Abstract, Fast Report, C4D kbmMW and more.

AnyDAC Natively Supported Databases

Enterprise – Oracle, SQL Server, IBM DB2, Informix.
Workgroup – Firebird, Interbase, MySQL, PostgreSQL, SQL Anywhere, Advantage DB.
Database in clouds – Microsoft SQL Azure.
Desktop – SQLite, MS Access, BlackFish SQL, MS SQL CE, Advantage DB.
Embedded – SQLite, Firebird Embedded, MySQL Embedded, Berkeley DB.
Bridges – dbExpress, ODBC.

—
With best regards,
DA-SOFT Technologies Team

« Hide it

#AnyDAC Summer 2011 v 5.0.1 – #Delphi Components for Firebird, Interbase and more

July 5, 2011 darefiev Leave a comment

DA-SOFT Technologies announces the availability of AnyDAC for Delphi Summer 2011 release v 5.0.1.1845 – high-speed, Universal Data Access Components for Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, MS Access, IBM DB2, Sybase SQL Anywhere, Informix, Advantage, DbExpress, ODBC, that simplifies the task of building Embarcadero Delphi, C++Builder and Free Pascal Compiler database applications.

AnyDAC for Delphi can be immediately downloaded from the download page.

What is new in v5.0.1 and what is AnyDAC ?

[See remaining text…]

AnyDAC v 5.0.1 Highlights

New Advantage Database native ACE API driver (More).
New TADTable with live data window mode (More).
Major refactoring of the drivers infrastructure.
Major refactoring of the monitoring and tracing infrastructure.
New FormatOptions.FmtDisplayXxx, FmtEditXxx options.
New ADConnection Before/After StartTransaction, Commit, Rollback events.
Multiple enhancements to the help system.
Multiple enahncements to the help system.

And more.

AnyDAC for Delphi

AnyDAC home – http://www.da-soft.com/anydac/
AnyDAC shop – http://www.da-soft.com/anydac/order.html
AnyDAC trial – http://www.da-soft.com/anydac/download.html

AnyDAC Core Features

Native access to Firebird, InterBase, MySQL, MS SQL Server, Oracle, PostgreSQL, SQLite, DB2 and more. Including latest DBMS versions.
Optimized for best possible performance (2 times faster than dbGo, 25% faster than dbExpress).
Generic access to any database supported through dbExpress and ODBC data sources.
Reach API, including 50 Delphi VCL components.
Unified API for access to cross-database features.
First-class support for many database-specific features, including DBMS services like backup, validate.
Unique ADO.NET-like data engine for Win32.
Advanced Data Access Options.
Full support for international applications, including full Unicode support in Delphi 2009 and later.
Cross-platform support though Free Pascal (FPC).
Perfect integration as back-end driver for TMS AdvGrid, RemObjects Data Abstract, Fast Report, C4D kbmMW and more.

AnyDAC Natively Supported Databases

Enterprise – Oracle, MS SQL Server, IBM DB2, Informix.
Workgroup – Firebird, Interbase, MySQL, PostgreSQL, SQL Anywhere, Advantage DB.
Database in clouds – Microsoft SQL Azure.
Desktop – SQLite, MS Access, BlackFish SQL, MS SQL CE, Advantage DB.
Embedded – SQLite, Firebird Embedded, MySQL Embedded, Berkeley DB.
Bridges – DbExpress, ODBC.

—
With best regards,
DA-SOFT Technologies Team

« Hide it

Firebird – an 64 bit replacement for Access / Jet / DAO

May 21, 2008 mariuz Leave a comment

I have a 32 bit application that uses DAO to connect to an Access database. I need to upgrade the application to be true 64 bit (not WOW64). Microsoft does not offer a 64 bit version of DAO.

Thread continues here

http://discuss.joelonsoftware.com/default.asp?design.4.631361

1 2 »