### Author:  [@mijndesign](https://talk.remobjects.com/u/mijndesign)
#### Post date: [December 20, 2022, 2:50am UTC](https://talk.remobjects.com/t/relativity-server-connection-string-for-asa10/27653/8 "2022-12-20T02:50:45Z")
Thanks, where do I put that DLL?
---
### Author:  [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [December 20, 2022, 5:55am UTC](https://talk.remobjects.com/t/relativity-server-connection-string-for-asa10/27653/9 "2022-12-20T05:55:15Z")
Hi,
preferable to [Global Assembly Cache - Wikipedia](https://en.wikipedia.org/wiki/Global_Assembly_Cache).
but you can try to put also into folders near to `DataAbstract.daConfig`
---
### Author:  [@mijndesign](https://talk.remobjects.com/u/mijndesign)
#### Post date: [December 20, 2022, 7:47am UTC](https://talk.remobjects.com/t/relativity-server-connection-string-for-asa10/27653/10 "2022-12-20T07:47:10Z")
```auto
Managed to install the DLL with gacutil, here check result after installing
---------------------------------------------------------------------------------------------------------------------------------------------------------
PS C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.8 Tools> .\gacutil.exe -l iAnywhere.Data.SQLAnywhere.v4.0
Microsoft (R) .NET Global Assembly Cache Utility. Version 4.0.30319.0
Copyright (c) Microsoft Corporation. Alle Rechte vorbehalten.
Der globale Assemblycache enthält die folgenden Assemblys:
iAnywhere.Data.SQLAnywhere.v4.0, Version=16.0.0.20434, Culture=neutral, PublicKeyToken=f222fc4333e0d400, processorArchitecture=MSIL
Anzahl der Elemente = 1
The entry in DataAbstract.daConfig looks like this
"
iAnywhere.Data.SQLAnywhere
But when I try schema modeler still says " The requested .NET Data provider cannot be found"
```
```auto
```
---
### Author:  [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [December 20, 2022, 12:30pm UTC](https://talk.remobjects.com/t/relativity-server-connection-string-for-asa10/27653/11 "2022-12-20T12:30:33Z")
Hi,
> [@mijndesign](#):
>
> Database is for a legacy Delphi app which will be migrated to 3-tier with Postgres as Backend.
Why you need Relativity Server and why you can’t use usual DAD server with FireDAC connection to ASA10? it should be enough for migration to PostgreSQL
---
### Author:  [@mijndesign](https://talk.remobjects.com/u/mijndesign)
#### Post date: [December 20, 2022, 1:25pm UTC](https://talk.remobjects.com/t/relativity-server-connection-string-for-asa10/27653/12 "2022-12-20T13:25:47Z")
To be honest I never thought about that alternative. As everything worked fine via ODBC in Delphi I never thought about any problems.
Just have the need to build up KnowHow with Relativity Server (quite fast) for my current customer and the huge legacy project to prove RO DA is a practical solution with lots of additonal helpfull features . I know there are a lots of hurdles ahead but hope to take one after the other.
I’ll check DAD server and see where get with it.
Many thanks for your help and your input!
Kind regards
Michael
---
### Author:  [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [December 20, 2022, 1:31pm UTC](https://talk.remobjects.com/t/relativity-server-connection-string-for-asa10/27653/13 "2022-12-20T13:31:52Z")
Hi,
this article can be useful: [New Project Wizard](https://docs.dataabstract.com/Delphi/GettingStarted/NewProjectWizard/)
---
### Author:  [@mijndesign](https://talk.remobjects.com/u/mijndesign)
#### Post date: [December 22, 2022, 2:02pm UTC](https://talk.remobjects.com/t/relativity-server-connection-string-for-asa10/27653/14 "2022-12-22T14:02:54Z")
I do not giveup easily on something not working but should work.
Searching around found a SQLAnywhere 12 trial (with offical .NET support) downloaded, installed in a VM and [SQLAnywhere.NET](http://SQLAnywhere.NET) connection worked, at least with local databases.
Checked what changes where made to Windows System/.NET and realized just registering a .NET data provider with gacutil.exe is not enough for common access it’s just for development. There is quite a bit more involved.
But to make a long story short, after a lot of fiddeling around in GAC etc etc found a SQLAnywhere 12 Client download on SAP today. Installed it, got few errrors but after checking and reading about correct parameters finally remote access to my ASA10 dbserver works in Schema Modeler.
One last problem is left: Opening schema modeler from inside Relativity Admin the connection fails again. Hopefully this is just some network access problem and can be solved asap and then go back to working with Relativity Server.
I have to admit with DA Server development I’m missing too much know how even basics (but knew that before and some some day will learn everything).
Everyone stay healthy, merry Xmas and a happy new year!
Michael
---
### Author:  [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [December 22, 2022, 2:12pm UTC](https://talk.remobjects.com/t/relativity-server-connection-string-for-asa10/27653/15 "2022-12-22T14:12:01Z")
Hi,
> [@mijndesign](#):
>
> One last problem is left: Opening schema modeler from inside Relativity Admin the connection fails again. Hopefully this is just some network access problem and can be solved asap and then go back to working with Relativity Server.
You should use the same `DataAbstract.daConfig`. if you put some dll to Schema Modeller folder, you should put them also to Relativity folder.
---
### Author:  [@mijndesign](https://talk.remobjects.com/u/mijndesign)
#### Post date: [December 22, 2022, 6:16pm UTC](https://talk.remobjects.com/t/relativity-server-connection-string-for-asa10/27653/16 "2022-12-22T18:16:28Z")
No dll’s added/moved/copied anywhere, no additional entries in any config, just plain SQLAnywhere 12 client installation in a clean Windows 10 vm.
---
### Author:  [@mijndesign](https://talk.remobjects.com/u/mijndesign)
#### Post date: [December 24, 2022, 4:01pm UTC](https://talk.remobjects.com/t/relativity-server-connection-string-for-asa10/27653/17 "2022-12-24T16:01:31Z")
FYI: Looks like I’m step further: In another VM (Intel) installed ASA12 client and was then able to call Schema Modeler from within Relativity Admin and the [SQLAnywhere.NET](http://SQLAnywhere.NET) connection works.
---
### Author:  [@mijndesign](https://talk.remobjects.com/u/mijndesign)
#### Post date: [December 28, 2022, 7:44am UTC](https://talk.remobjects.com/t/relativity-server-connection-string-for-asa10/27653/18 "2022-12-28T07:44:26Z")
One last final problem cannot be resolved:
Everything seemed ok, but working trough a schema 2 tables threw erros on validate (with AutoSQL too). ASA12 and up seem to have trouble to resolve / migrate fields from ASA10.
Maybe if I have some spare time will have a look which field(defintion)s are the cause.
---
### Author:  [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [December 28, 2022, 12:40pm UTC](https://talk.remobjects.com/t/relativity-server-connection-string-for-asa10/27653/19 "2022-12-28T12:40:02Z")
Hi,
try to use usual SQL like
```sql
SELECT
fld1, fld2 ...
FROM
table
WHERE
{WHERE}
```
it will allow to use [Dynamic Where](https://docs.dataabstract.com/Technologies/DynamicWhere/) feature
---
### Author:  [@mijndesign](https://talk.remobjects.com/u/mijndesign)
#### Post date: [December 30, 2022, 9:32am UTC](https://talk.remobjects.com/t/relativity-server-connection-string-for-asa10/27653/20 "2022-12-30T09:32:57Z")
I did use only such simple SQLs even without , tried it with AutoSQL too. Changed the connection to FireDAC and everything was ok, back to [SQLAnywhere.NET](http://SQLAnywhere.NET) and I got errors. As I said before will look into this when there is some spare time
Have a working DA Server now to work with and try to get my head around DA for Javascript etc