You are not logged in.
- Topics: Active | Unanswered
#1 2020-04-05 10:51:49
- Flashcqxg
- Member
- Registered: 2018-01-11
- Posts: 31
TSQLDBFireDACConnectionProperties and SAP SQL Anywhere 17
I wanted to connect to SAP SQL Anywhere 17 by TSQLDBFireDACConnectionProperties:
var
FD: TSQLDBFireDACConnectionProperties;
FD := TSQLDBFireDACConnectionProperties.Create('ASA?ENG=test', 'TEST',
'dba', 'sql');
Error Message:
TSQLDBFireDACConnectionProperties.Create:unknown provider-available: OraMSSQLMSAccMySQLSQLiteIBPGDB2Infx.
How to connect to the SAP SQL Anywhere 17 by TSQLDBFireDACConnectionProperties?
Thanks.
Offline
#3 2020-04-05 14:15:34
- Flashcqxg
- Member
- Registered: 2018-01-11
- Posts: 31
Re: TSQLDBFireDACConnectionProperties and SAP SQL Anywhere 17
It is not supported yet.
What is the closest SQL dialect?
It's Transact-SQL ,like MS SQL.
Hope to support it as soon as possible.
Thanks a lot!
Offline
#4 2020-04-05 15:02:44
Re: TSQLDBFireDACConnectionProperties and SAP SQL Anywhere 17
Please try https://synopse.info/fossil/info/40ff535f0f
It will recognize 'ASA' as dMSSQL.
But I don't know if it is enough, or if we need to add another specific TSQLDBDefinition item, and some specific behavior in SynDB.
Offline
#5 2020-04-05 15:18:11
- Flashcqxg
- Member
- Registered: 2018-01-11
- Posts: 31
Re: TSQLDBFireDACConnectionProperties and SAP SQL Anywhere 17
It's work well.
Thank!
Offline