Error connecting to Sybase Linked Server

I am getting the following error when querying a linked server:
Msg 7403, Level 16, State 1, Line 3
The OLE DB provider "Sybase.ASEOLEDBProvider" has not been registered.
The query is as follows:
select * from syb_Link.Comp.dbo.Users
How did you create the linked server -
Locally on the sql box or remotely from your desktop?
Sounds to me like the server doesnt have a sybase client.
"Ziggy" wrote:

> I am getting the following error when querying a linked server:
> Msg 7403, Level 16, State 1, Line 3
> The OLE DB provider "Sybase.ASEOLEDBProvider" has not been registered.
> The query is as follows:
> select * from syb_Link.Comp.dbo.Users

Error connecting to Sybase Linked Server

I am getting the following error when querying a linked server:
Msg 7403, Level 16, State 1, Line 3
The OLE DB provider "Sybase.ASEOLEDBProvider" has not been registered.
The query is as follows:
select * from syb_Link.Comp.dbo.UsersHow did you create the linked server -
Locally on the sql box or remotely from your desktop?
Sounds to me like the server doesnt have a sybase client.
"Ziggy" wrote:

> I am getting the following error when querying a linked server:
> Msg 7403, Level 16, State 1, Line 3
> The OLE DB provider "Sybase.ASEOLEDBProvider" has not been registered.
> The query is as follows:
> select * from syb_Link.Comp.dbo.Users