ADS Question

[byron.hopp]

All, I am currently using ADS 12.0 at a customer site. I have attempted to install the server on my local for testing. When I install OLEDB for 32, and 64 I see in the driver in the Uniform Data Link dialog (take an empty file with a UDL extension and from command 'start myfile.udl'), but if I attempt to use the " oDataLink := CreatObject('DATALINK')", and then oDataLink:PromptNew() method the Advantage driver does not show up in the list, additionally if I attempt to use the connection string created in the Uniform Data Link app it does not work either. I am thinking it may be the problem between 32, and 64 bit. I believe my Fivewin for Harbour creates 32 bit apps and it does not see the driver. How do I install the driver to where it is seen by my app.

[byron.hopp]

Update, I attempted to run the adsoledb_x86_64.exe on a Hyper-V VM running 32 bit version of Windows. The installer errors out and says it does not support the processor type. I have an Intel i9. Doesn't seem to be any support for ADS anymore. I tried calling, splinters in your finger nails would be more amusing.

[byron.hopp]

I believe I found a solution (even a blind squirrel finds a nut). Seems if you install the OLEDB.Exe from version 8.1 the driver shows in the 32 bit version. And you will see it on the Uniform Datalink app.

[TimStone]

I'm not sure about your question because I believe you are using it for SQL.

I use Version 12 for both 32 bit and 64 bit applications. The drivers are different for each, and I'm using with .dbf files. I have absolutely no problems with it.

Of course my builds are with FWH, Harbour, MSVC, all the most current versions.

As for ADS, it was last updated in 2015. The company was great until it was taken over. The current owners sold licenses, and upgrades, for a number of years, but provided absolutely no support. Now it is "lost in the wind" and current reps don't even know about the product. Of course they are too selfish to release it even though they do not have another product to replace it. So, many of my clients who bought licenses need to add more workstations, but that's not possible. Others would like to buy a license, but again, it's not possible.

The company keeps reaching out to me because I was a reseller of ADS, and they want me to rep other products. When I explain to the "new" account holder, I never hear anything until the account is passed to someone else.

[byron.hopp]

Thanks Tim,

My problem was that even in the Uniform Datalink Utility the driver would not show to be selected under the Provider - OLE DB Provider(s) tab of the utility. This is a Microsoft utility so I am not even in Fivewin or Harbour as of yet. The OLEDB installer provided by SAP is named adsoledb_X86_64.exe after installing this I can find the provider using a 64 bit requestor, but no 32 (or X86). But again I found if I install the providers via OLEDB.exe from ADS version 8.1 all is good. I also tried to install using the SAP installer on a 32 bit x86 VM (Hyper-V) and the utility failed with an error saying the processor was not supported. I also have the same experience their support is pathetic now, was very good. I remember talking to them on New Years Day of Y2K for a few hours, they were very helpful, and open.

[TimStone]

There are two different installers, one for 32 bit, and one for 64 bit.

[Otto]

Hello friends,

Let's forget all this overhead.

Switch to RDP, use low-level functions for CRUD operations on DBF. Index files are practically of little use today, and if we ever needed them, we could simply create a new format: DBF FW lite index format - DFX.

Investing so much brainpower in something that has no future seems unwise to me.

Best regards,
Otto

[Giovany Vecchi]

To purchase ads licenses look here.

https://www.sap.com/brazil/products/technology-platform/advantage-database-server.html#plans

[byron.hopp]

My guess is that RDP does not stand for what I think it does, I did find CRUD on Google. Do you have an example of this method? My current app is a hybrid of SQL using OLEDB, and DBF/CDX with the ADS RDD (both using ADS). If my client had a say in this decision I would switch to SQL Server because they have many of the servers installed around the world and 1 (one) ADS Server. I am still curious about what you are talking about. Thanks,

[Otto]

Hello Byron,
I checked out your website, and it appears that you have many connections/interfaces with existing systems.
This means you don't have much freedom to implement your own database design, as it is dictated by the partners.
What kind of software do you create exactly?
Best regards,
Otto

[TimStone]

The pricing on that website is extremely high, especially for a product that hasn't been updated in 9 years, and has no support. $311+ per user, and the normal configuration is at least a 5 user system.

If you look at the Terms and Conditions, it is all about a cloud based solution, which that is not.

I'm puzzled that someone is actually selling it.