ADO in Lazarus for windows

Code patches written by our users to solve certain "problems" that were not solved, yet.

Moderators: gto, cipto_kh, EgonHugeist, mdaems

Post Reply
aliotti
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 13.12.2005, 14:29

ADO in Lazarus for windows

Post 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.
You do not have the required permissions to view the files attached to this post.
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post 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
Image
aliotti
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 13.12.2005, 14:29

Post 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.
aliotti
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 13.12.2005, 14:29

changes in package of lazarus of my version zeos 6.6.6

Post by aliotti »

The changes is attached in file lazarus.zip to packages of lazarus
You do not have the required permissions to view the files attached to this post.
aliotti
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 13.12.2005, 14:29

The source changes in zeos 6.6.6

Post 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.
You do not have the required permissions to view the files attached to this post.
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post 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
Image
aliotti
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 13.12.2005, 14:29

Post 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.
Post Reply