since new year 2015 i added a new Driver "OleDB"-Alfa-Version. This will be the topic thread for first testers to share first experiences.

To be clear: The new driver simply is a native access driver for all Ole-Drivers. In addition Microsoft declared the OleDB as deprecated(year 2014) but OleDB was first choise until MS-SQL Server 2012. This driver bypasses the known "ADO" bridge!

Current performance tests are amazing! This new driver is imbelievable faster then ADO or the TDS protocol.To get connected: use it like ADO. For the TZConnection users: click the button on the Database property editor and the "known" OleDB connection-string builder dialog will open.

known issues until 31.12.2014:-a IZCallableStatement is missing -> TZStoredProcedure is not supported yet! So let's fix it.-weired issues with more than one Connection and different TransactionIsolationLevels.. Did i overlook something? Feel free to help!Edit: The MSOLEDB-Provider is cloning the Connections silently in background. Something i miss here. but i can find it yet.

Second Edit: fast lob reading is introduced. It depends on chunked reads. Increase 'Chunk_size=x' in bytes(defult 4KB/chunk) for faster reading!

inbetween the issue should have been resolved. As i wrote Ole doesn't return the lob-attribute for the column, just a imbelievable huge col-size.However i can use the VARxxxx(MAX) fields now. Same on ODBC