Linked Sybase from SQL Server

[former_SQLA_member1694872]

How do I create (step by step) one sybase linked server to SQL Server In ODBC not appear Ole Provider driver for creation of Alias I do not know where to start. :( I am using Sybase ASA 9 and SQL Server 2012

[former_SQLA_member1694872]

Accessed the SQLServer database using remote access / proxy tables. Actually a lot easier, but tried to make a cursor to generate the proxies tables and I'm not getting. I'm trying as follows: (generate via Sybase Central does not have to do all the tables at once and because the proxy table can not have the same table name of the table that exists in my ASA database?)

PS: What I want to do is insert ASA database data in SQLServer database.

Below code to generate the proxy tables, thank you!

begin
   declare qry long varchar;
   FOR I AS CURSOR_TABELA cursor for SELECT table_name from systable where substr(table_name,1,2) = 'TB' DO
      EXECUTE('CREATE EXISTING TABLE '||STRING(TABLE_NAME)||'_2'||' AT '||STRING('SQL;dbSQL;dbo;'||STRING(TABLE_NAME)));
   END FOR;
end;

[VolkerBarth]

The local proxy table (i.e. in ASA9) can certainly have the same name as in the remote database (MS SQL) but it can not have the same name as other tables in the same ASA9 database (at least not with the same owner).

That being said, what exact error or problem do you see? ("Not getting it" does not tell that much...)