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