|
Home > Archive > ASE Database forum > April 2005 > Connect from MS-SQL Server to Sybase
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Connect from MS-SQL Server to Sybase
|
|
| Elangovan Raman 2005-04-06, 8:03 pm |
| How would someone use the following Stored Proc in MS-SQL
Server :
Creating a linked server:
Exec sp_addlinkedserver
@server = 'alias name of the linked server',
@srvproduct = '',
/*this is the product name of the OLE DB
data source to add as a linked server.*/
@provider = 'provider_name',
@datasrc = 'data_source',
@location = 'location',
@provstr = 'provider_string',
@catalog = 'catalog'
to connect to Sybase ASE 12.5.0.3.
The usage would be to connect to the Sybase ASE Server with
the User-id and Password stored on a MS-SQL Server User
Table.
Your inputs are most welcome.
Thanks.
Elango.
| |
| Sherlock, Kevin 2005-04-06, 8:03 pm |
| I could be wrong, but as of SP3 you can no longer create DbLink servers to
Sybase because there isn't a "certified" OLE-DB driver for Sybase (as far as
MS is concerned). I could be wrong, maybe you can force the issue with the
command below. Maybe that's a limitation of Enterprise Manager however.
Where I am, we go the other way (ASE -> MSSQL) with Direct Connect - ODBC :)
<Elangovan Raman> wrote in message
news:425426a8.6fa5.1681692777@sybase.com...
> How would someone use the following Stored Proc in MS-SQL
> Server :
>
> Creating a linked server:
>
> Exec sp_addlinkedserver
>
> @server = 'alias name of the linked server',
>
> @srvproduct = '',
>
> /*this is the product name of the OLE DB
> data source to add as a linked server.*/
>
> @provider = 'provider_name',
>
> @datasrc = 'data_source',
>
> @location = 'location',
>
> @provstr = 'provider_string',
>
> @catalog = 'catalog'
>
> to connect to Sybase ASE 12.5.0.3.
>
> The usage would be to connect to the Sybase ASE Server with
> the User-id and Password stored on a MS-SQL Server User
> Table.
>
> Your inputs are most welcome.
>
> Thanks.
>
> Elango.
|
|
|
|
|