Sybase linked server in sql 2005

/* addling sybase aes linked server to sql 2005*/------------------------------------------------------
EXEC master.dbo.sp_addlinkedserver @server = N'abc', ----linked server name here
@srvproduct=N'Sybase', ----what kinda drive you are using
@provider=N'Sybase.ASEOLEDBProvider', -----------exact driver name from provider under linked servers in managment studio
@catalog=N'ptl',---- database name here
@datasrc=N'ptl'-----this is dns you created in odbc using sybse driver

------------------------------------------------------
/*adding credentials to sybase aes linked server*/EXEC master.dbo.sp_addlinkedsrvlogin 

@rmtsrvname=N'abc',

@useself=N'False',

@locallogin=NULL,

@rmtuser=id,

@rmtpassword=password;
--------------------------------------------------------------
/* Aes provider configuration. right click and go to properties of aes provioder and check mark allow in process*/--------------------------------------------------------------------------------------------------------------------
/* to check run adhoc query. dont try to expand linked server in managment studio. it does not mean anything. even if you see tables 
the linked server might not be setup properly. always run query to check if linked server is working or not*/------------------------------------------------------------------------------