Friday, March 23, 2012

Retrieving Sybase data from sql server 2005

hi
i need to select a data from a sybase table into a sql server 2005 table.i dont know whts is the query to do it, let me show u my code.i get error when i do that query

select * from openrowset('MSDASQL','dsn=bodaily;uid=sa;pwd=welco me;Initial Catalog=phoenix;',
' select rim from rm_acct')

this rm_acct is a sybase table

can anyone guide me on this.
thanks

Could you elobrate on error, you are getting.

thanx and regards

Rahul Kumar

No comments:

Post a Comment