[Patch] Microsoft SQL Server and Sybase ASE connectors
Original Reporter info from Mantis: BigChimp
-
Reporter name: Reinier Olislagers
Original Reporter info from Mantis: BigChimp
- Reporter name: Reinier Olislagers
Description:
New Lazarus connector components for the MS SQL Server and Sybase ASE connectors written by Lacak2 that use FreeTDS/dblib (see bug 21571).
Steps to reproduce:
sql_lazarus.zip contains a diff; please apply.
Also tsybaseconnection.png and tmssqlconnection.png, to be placed in components\sqldb\design
As a convenience, zip MSSQLAndSybaseTestPrograms.zip attached with example program, readme and required dlls) for Sybase and MS SQL Server.
Additional information:
I've followed the FPC connector's supported operating systems:
packages\fcl-db\fpmake.pp
SqldbConnectionOSes = [beos,linux,freebsd,win32,win64,wince,darwin,iphonesim,netbsd,openbsd];
in
components/sqldb/registersqldb.pas
{$IF DEFINED(BEOS) OR DEFINED(HAIKU) OR DEFINED(LINUX) OR DEFINED(FREEBSD) OR DEFINED (NETBSD) OR DEFINED(OPENBSD) OR DEFINED(WIN32) }
// MS SQL Server and Sybase ASE connectors were introduced in the FPC 2.7 development branch.
// Operating systems should match FPC packages\fcl-db\fpmake.pp
{$DEFINE HASMSSQLCONNECTION}
{$DEFINE HASSYBASECONNECTION}
{$ENDIF}
... perhaps there is an easier way of doing this.
Compiled and tested on Lazarus x86 Windows. x64 windows correctly does not show the components with the patch applied.
Finally, my graphics skills are not too good; I'm sure improvements in the icons would be welcome; if so, replace the pngs in components\sqldb\design and rerun registersqldb.bat in the design directory (or run lazres manually).