The following SQL Anywhere 11.0.1 Help topic refers to the "General
page" and "Server Options" page of some GUI or utility that is not
named... what is it referring to?

SQL Anywhere Server - Programming
» SQL Anywhere Data Access APIs
» SQL Anywhere OLE DB and ADO development
» Setting up a Microsoft Linked Server using OLE DB

Using Transact SQL via osql.exe in Microsoft SQL Server 2008 Express,
I've been able to get linked server queries to work without following
the aforementioned instructions, EXCEPT for step 2 "Choose the Allow
Inprocess provider option"; to do that, I used the Microsoft SQL
Server Management Studio:
[servername]
- Server Objects
- Linked Servers
- Providers
- SAOLEDB.11
- Provider Options - SQL Anywhere OLE DB Provider 11
- General page
- check "Enable - Allow inprocess"

I could not find the stuff described in steps 1 or 3, however, and I'm
thinking I'm missing something.

If it's somewhere buried in Visual Studio, then perhaps additional
instructions should be provided for a streamlined SQL-only setup
solution.

Breck


--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com

Breck,

methinks the description refers to the MS SQL Server Enterprise Manager
and its "Create a linked server..." dialog.

At least this goes for MS SQL 2000.

Yes, and it's possible to do the same with just SQL statements, i.e.
with MS SQL stored procedures, e.g.
* sp_addlinkedserver to add a linked server
* sp_addlinkedsrvlogin to add a remote login
* sp_serveroption to set the options below like
* sp_helpserver, sp_linkedservers, sp_helpremotelogin to list
servers/remote logins


A sample usage (utested):

-- 1. create server with ODBC DSN (DSN-less is possible, too)
exec sp_addlinkedserver 'MY_SVR_SA11', 'MyAppName', 'SAOLEDB.11',
'MyDSN', null, 'CON=MSLinkedSvr', null

-- 2. create reomte login
exec sp_addlinkedsrvlogin 'MY_SVR_SA11', 'false', null, 'MyUser', 'MyPwd'

-- 3. set some options
exec sp_serveroption 'MY_SVR_SA11', 'collation compatible', 'true'
exec sp_serveroption 'MY_SVR_SA11', 'data access', 'true'
exec sp_serveroption 'MY_SVR_SA11', 'rpc', 'true'
exec sp_serveroption 'MY_SVR_SA11', 'rpc out', 'true'


And I agree that this could be documented better

HTH
Volker


Breck Carter [TeamSybase] wrote:

Thanks for the sp pointers.

Yes, the documentation does seem to apply to the linked server
properties dialog in Microsoft SQL Server Management Studio in MSS
2008, for all the options except Allow inprocess, which is a property
of the provider itself.

FWIW, AllowInProcess property of SAOLEDB.11 is set as follows...

USE [master]
GO
EXEC master.dbo.sp_MSset_oledb_prop N'SAOLEDB.11', N'AllowInProcess',
1
GO

That wonderfully obscure fact is impossible to find in the MSS Help,
but the provider property dialog does have a very useful "Script" menu
option that generated the code above.

FWIW, I prefer scripts over GUIs for setting up objects like this,
because scripts are self-documenting whereas it's easy to forget what
you did in a GUI... it's not like creating a linked server is an
everyday task, but it sometimes must be repeated.

Plus, when creating how-to documents for clients (or articles for
general consumption), a five-line script is often easier to write and
read and understand, than five pages of screenshots.

Again, thanks!

Breck


On 14 Sep 2009 00:50:01 -0700, Volker Barth
<No_VBarth (AT) Spam_GLOBAL-FINANZ (DOT) de> wrote:

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com