AdsSQLServer Query with Parameters not working

wriedmann · Post by **wriedmann** » Thu Jul 07, 2022 9:07 am

Hi Kees,
https://www.riedmann.it/download/ads/dataprovider.exe
It is the latest .NET dataprovider for v12.
Wolfgang

Kees Bouw · Post by **Kees Bouw** » Thu Jul 07, 2022 9:30 am

wriedmann wrote:Hi Kees,
https://www.riedmann.it/download/ads/dataprovider.exe
It is the latest .NET dataprovider for v12.
Wolfgang

Hi Wolfgang,

Thank you very much for your help. I also discovered the file on my computer, it is in the ADS 12 zip package I downloaded 2 years ago:

Code: Select all

07-07-2022  11:24    <DIR>          .
07-07-2022  11:24    <DIR>          ..
17-11-2017  13:43        16.076.656 aceapi.exe
17-11-2017  13:48        16.727.696 aceapi_x86_64.exe
15-11-2017  16:22        46.315.136 adsdelphi.exe
17-11-2017  14:50        18.565.432 adsodbc.exe
17-11-2017  14:53        19.428.152 adsodbc_x86_64.exe
17-11-2017  14:38        17.649.408 adsoledb_x86_64.exe
08-11-2017  14:51        26.771.872 adsweb.exe
08-11-2017  15:31        23.074.760 adswin_x86_32.exe
08-11-2017  15:32        27.056.072 adswin_x86_64.exe
08-11-2017  17:00        22.217.104 arc32.exe
08-11-2017  17:00        16.807.804 crystal.exe
-> 16-11-2017  11:11        33.580.416 dataprovider.exe
17-11-2017  14:28        16.959.648 dbiwin.exe
17-11-2017  14:41        17.153.272 oledb.exe
17-11-2017  14:46        17.268.280 php_win.exe
08-11-2017  17:00        16.940.248 vo32.exe
08-11-2017  17:00        11.401.306 win_jdbc.exe
              17 File(s)    363.993.262 bytes

The dataprovider.exe is identical to the one in your link. I think installation was successful, there were two windows and one said it was successful and the other that it was interrupted and my system was not changed. I do have the "ado.net" folder so I think it's ok. Now I am going to study your sample code.

Kees.

Jamal · Post by **Jamal** » Thu Jul 07, 2022 8:07 pm

Hi Kees,

The links work fine from my location; not sure why they did not work for you; May be site was down at that moment.

Jamal

KeesIC2 wrote:
Jamal wrote:Hi Kees,

You can download Advantage.Data.Provider.dll version 11 from

https://devzone.advantagedatabase.com/d ... latform=11

Other versions: https://devzone.advantagedatabase.com/d ... spx?Key=20

Jamal
Hi Jamal,

Both links produce the error: "Our apologies, but an error has occurred. Please check the URL or try the operation again."

Kees.

Kees Bouw · Post by **Kees Bouw** » Fri Jul 08, 2022 9:31 am

Jamal wrote: The links work fine from my location; not sure why they did not work for you; May be site was down at that moment.

Hi Jamal,

Yes, they work for me now as well so it was a temporary problem. Thank you!

Kees.