Page 1 of 1
ADO in Lazarus for windows
Posted: 10.02.2010, 13:39
by aliotti
In day 2010.02.09 in morning did the TZConnection use ADO with addition the library OLEDB.pp in package ZDBC and adjust of Libraries of ADO in ZEOS to Lazarus.
Posted: 12.02.2010, 00:09
by mdaems
aliotti,
Can you explain where you got hthe oledb.pas file from? Before I include it I need to be sure inclusion is legal.
Can you tell me if this is 64-bit compatible?
What about linux fpc users?
Please also send the other files that did change.
Mark
Posted: 25.03.2010, 15:15
by aliotti
Mark,
First this file is conversion of file of delphi 6.0 - you must have license: preference of Delphi 6 or above ;or
the windows - oledb is part of product.
I dont tested it in operational systems 64 bits; and
Use freetds(
www.freetds.org) with odbc to access database sql server in linux - I tested its with lazarus in ubuntu.
changes in package of lazarus of my version zeos 6.6.6
Posted: 25.03.2010, 15:49
by aliotti
The changes is attached in file lazarus.zip to packages of lazarus
The source changes in zeos 6.6.6
Posted: 25.03.2010, 15:53
by aliotti
Here have the file with sources changes recents in zeos.
I tested the connection and the command execute of connection and its are responding correctly.
Posted: 27.03.2010, 15:46
by mdaems
My main question is still : can we make a unit which replaces oledb.pas completely?
When it's just a file containing constants needed for the ADO implementation, we can just add the needed constants into a zdbcADOXXX file. I suppose the values of these constants is documented in the ADO standards, so defining them ourselves can't be called 'code theft'.
If we give the constants a name like Z_ADO_*** there isn't even a reference to the oledb unit. (We could even remove it from the library, then)
Or is that too simplistic?
Mark
Posted: 29.03.2010, 18:13
by aliotti
Yes, can replace oledb.pas with another unit to use in windows. Because the license of OLEDB is of Microsoft when you have the windows xp or next have too OLEDB installed to use.
The Microsoft Data Access Components (MDAC) are a standard database interface for Windows, have OLEDB in package. MDAC is already included as part of Windows 98, Windows 2000, Windows ME, and Windows XP. Some early Windows 98 OEM systems shipped without MDAC, however. MDAC is also already installed on your system if you have Internet Explorer 5.0 (or higher) or Microsoft Office. MDAC is FREE and is fully supported by Microsoft on all versions of Windows.
To install download:
http://www.microsoft.com/downloads/deta ... n#Overview, here you locate the MDAC SDK - it may be file OLEDB.H. header of OLEDB, and can translate to pascal.
Have a nice day.