Poor Linked Sybase Server performance

Hi
I have a problem with performance when I execute proc against linked Sybase
Server.
Here is a strings I used to add a server:
sp_addlinkedserver N'hetco_sybase', ' ', N'MSDASQL', N'hetco_sybase'
sp_addlinkedsrvlogin N'hetco_sybase', false, null, N'sa', 'sa_password'
Execute of proc is taking a second when it run directly on Sybase, is taking
about 20 sec.
I've never noticed any network problems in our environment before.
Any ideas?
Does anybody know a better alternative to connect to Sybase?Try the instructions on the sybase website for creating a linked server.
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:C26C4E8F-D554-47E8-B207-04AF2A6954A9@.microsoft.com...
> Hi
> I have a problem with performance when I execute proc against linked
Sybase
> Server.
> Here is a strings I used to add a server:
> sp_addlinkedserver N'hetco_sybase', ' ', N'MSDASQL', N'hetco_sybase'
> sp_addlinkedsrvlogin N'hetco_sybase', false, null, N'sa', 'sa_password'
> Execute of proc is taking a second when it run directly on Sybase, is
taking
> about 20 sec.
> I've never noticed any network problems in our environment before.
> Any ideas?
> Does anybody know a better alternative to connect to Sybase?sql