Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

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?

asked 10 Nov '15, 09:15

Jongee's gravatar image

accept rate: 0%

edited 10 Nov '15, 09:44

Volker%20Barth's gravatar image

Volker Barth

if any one has achieved this connection

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).

(10 Nov '15, 09:44) Volker Barth

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.

(10 Nov '15, 09:45) Mark Culp

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.

permanent link

answered 10 Nov '15, 09:42

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
accept rate: 32%

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

but it seems quite complex...

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
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 10 Nov '15, 09:15

question was seen: 3,023 times

last updated: 12 Nov '15, 02:54