Drivers (descendants) for more database types
lazarus / 7-LCL

----------------------------------------------------------------------
Lacak2 · 2010-08-05 09:52

Hi,
There is in Future plans http://www.freepascal.org/future.var :
Improve the database support / Drivers (descendants) for more database
types.

I would like to ask which Drivers/Databases are expected to be added ?
I have experimental implemention of TSQLConnection descendant
(TMSSQLConnection), which connect to MS SQL Server 7,2000,2005 using
native SQL Server DB-Library (ntwdblib.dll)
Please let me know if "project" (or somebody) is interested about it
or if I should post feature request in bug tracker ?
Or if you are prefering other connection method to MS SQL Server?

Disadvantages:
- ntwdblib.dll is for Windows, for *nix word there is FreeTDS project,
which provides libsybdb.so (which implements db-lib API), but I have 
no experience with it, so it is up to somebody else add it.
- ntwdblib.dll seems not to be prefered access method according to
http://msdn.microsoft.com/en-us/sqlserver/connectivity.aspx
(ODBC is the primary native data access API for SQL Server)

Ideal solution will be use for all platforms FreeTDS (which will cover
also Sybase support), but ATM I am not able compile FreeTDS for
Windows to get libdb.dll  (only freetds.dll and libdb.lib)

----------------------------------------------------------------------
felipemdc · 2010-08-05 19:21

Quote from: Lacak2 on August 05, 2010, 11:52:46 amI have experimental
implemention of TSQLConnection descendant (TMSSQLConnection), which
connect to MS SQL Server 7,2000,2005 using native SQL Server DB-
Library (ntwdblib.dll)
Please let me know if "project" (or somebody) is interested about it
or if I should post feature request in bug tracker ?
Yes, it would be very good if you could contribute your component to
Free Pascal. In this case open a bug tracker item with your new unit
attached. In this case it would be a "patch", not a "feature request"

QuoteIdeal solution will be use for all platforms FreeTDS (which will
cover also Sybase support), but ATM I am not able compile FreeTDS for
Windows to get libdb.dll  (only freetds.dll and libdb.lib)
I think the ideal would actually be making it selectable if you want
to use FreeTDS or the MS version.

----------------------------------------------------------------------
Lacak2 · 2010-08-06 05:11

Ok, thanks for reply, I will make some improvements and then I post it
into bug tracker.

----------------------------------------------------------------------
Lacak2 · 2010-08-30 05:35

http://bugs.freepascal.org/view.php?id=17303