|
I am trying to link a Microsoft SQL Server to ASA 9.0. Whatever details I put in I seem to get a very unhelpful error, and was wondering if any one has achieved this connection, and what settings they used? |
|
There was an OLE/DB driver included in version 9.0. You may be able to use that since that seems to be the main requirement to access external databases as Linked Servers; MS technology. The other option is to use the SQL Anywhere remote access features and the Microsoft SQL Server ODBC driver. But it needs to be noted that ASA 9.0.x has been past support for a number of years now (as have versions 10.0.x and 11.0.x, as will version 12.0.1 should be soon be). I am pretty certain some people have done this but none of this will be recent memory. ASA 9.0.x was shipped with it's documentation installed. DocCommentExchange was not implemented until version 10 so if you need online documentation you will need to go to the Sybooks Online archive that used to be hosted on the Sybase sites. Thanks for the response. The database runs our CRM system, so they have not yet moved away from ASA 9.0, and I don't have much control over this. Also this has limited the documentation I have got access to. I have been looking at the Remote Servers in ASA 9, but it seems quite complex to join tables and query the data.
(10 Nov '15, 09:45)
Jongee
Replies hidden
Remote access may not be easy but is certainly doable given you have the required permissions:) Please show us what you have tried so far.
(10 Nov '15, 09:49)
Volker Barth
|
Yes, certainly (well, not with v9 but with v5.5, v8, v10 and above...) - both with SQL Anywhere as the local server (i.e. by using proxy tables) and as the remote server (i.e. via MS SQL Server's "Linked Server" facility).
Could you show what steps/statements you have used so far (with anonymized credentials and the like...)?
FWIW, I'll re-tag your question with different tags, "SQL Remote" is something different namely the builtin replication tool which has nothing to do with "Remote data access" (aka proxy tables).
What exactly are you trying to do? You've tag your question with sql-remote ... so if this is referring to the sql remote synchronization tool then AFAIK it is not going to work (but I'm not a sync expert). Perhaps you are trying to connect from MS SQL Server to ASA 9 ... or perhaps you are trying to connect from ASA 9 to SQL Server? I can't help you with the former but if is the latter then you need to use proxy tables.
Show us what you have tried and then perhaps someone can help you.