Advatage Database server

[liviomex]

Hello,

I used for many years advatage database server and Advatage RDBMS from old CA-Clipper times.
I heard that SAP dismissed ADS a couple of years ago.

I used ads componenents without any kind of problem under Lazarus mainly for teaching reasons ( to teach database programming without the use of SQL to make young people to understand that there is no one solution even for db issues ).

Now I cannot find ads.lpk component anywhere, someone can help me to understand if it is possible to get it somewhere or it is something that does not exists anymore?

Thanks for your help

Livio

[marcov]

Lazarus/FPC never supported ADS out of the box. So probably that older install had a 3rd party component set installed for that.

[Thaddy]

It was written in Pascal.
When you have the sources you can port it quite easily because almost all syntax is covered.

[LeP]

Hello,
I used ads componenents without any kind of problem under Lazarus mainly for teaching reasons ( to teach database programming without the use of SQL to make young people to understand that there is no one solution even for db issues ).
Now I cannot find ads.lpk component anywhere, someone can help me to understand if it is possible to get it somewhere or it is something that does not exists anymore?

It exists, but no one can distribute it, since it is the property of SAP and SAP has withdrawn it.

[Zvoni]

On a SideNote: acc. to SAP-Documentation, accessing it is possible via ODBC-Connection, so it would imply, as long as you have the ODBC-Driver, sqldb would be sufficient

[LeP]

On a SideNote: acc. to SAP-Documentation, accessing it is possible via ODBC-Connection, so it would imply, as long as you have the ODBC-Driver, sqldb would be sufficient

He spoke about NOT SQL access, may be he intends ISAM or something similar access, so SQL is not a solution.
I know that Lazarus and Delphi components (available via ADSDelphi.exe add on) allow direct access to db.

[liviomex]

Yes: I used for years advantage to access dbf files with full FoxPro cdx indexes support. Some years ago I used lazarus+advatage to teach young wannabe developers how to implement database sw with file server access to data.

Of course I can use other components, other database format such as access or paradox but since I have a deep knowledge of the combo delphi/advantage I would have liked to still use it.

It ' s a pitty SAP dismissed Advantage.

I' ll try to convert my delphi 7 dpk.

Thanks for your help

Livio

[Zvoni]

It ' s a pitty SAP dismissed Advantage.

How do you figure that?????
https://www.sap.com/germany/products/data-cloud/advantage-database-server.html

SAP still offers/supports ADS, though acc. to their own classification as "Business-Essential"
and definitely not as Freeware.

Since i saw mention of DBF....
i thought we all agreed, to keep quite about DBF, in the hope it will finally die out.... 

Frankly: DBF is dead, Paradox is dead, ISAM is dead, if we don't mention MS Access it will hopefully die, too.

My advise: Don't cling to dead/outdated technology

[LeP]

@Zvoni
SAP support on ADS ended on December 31, 2022 (SAP NOTE 3132015).

Only OEM parteners, who have a maintenance contract or who need additional license can download something about.
This is for what I know.

If someone of this community have access to this data can confirm or share other informations about.
But, for sure is that ADS is not anymore public available, so no one can share anything.

Lot of time ago (before 2023) ADS was available for local DB.

You are right about all dead things, but for teaching purpose these things are still valid.

Know the past improve the knowledge of present and may be help in the future.

[Zvoni]

@Zvoni
SAP support on ADS ended on December 31, 2022 (SAP NOTE 3132015).

OK. Didn't know that. Appreciated info!

Only OEM parteners, who have a maintenance contract or who need additional license can download something about.
This is for what I know.

If someone of this community have access to this data can confirm or share other informations about.
But, for sure is that ADS is not anymore public available, so no one can share anything.

Lot of time ago (before 2023) ADS was available for local DB.

You are right about all dead things, but for teaching purpose these things are still valid.

Know the past improve the knowledge of present and may be help in the future.

If it's really just about teachng ISAM-access to local Database-Files, then there is still the TDBF and whatever sisters and uncles

[serbod]

If you need to read or import data from legacy *.adt/*.adm files - https://github.com/serbod/DBReader/blob/main/DBReaderAdt.pas