I've set up a linked server between my SQL 2005 server and my AS400 DB2 server. I can query data successfully.
How do i call a DB2 stored procedure?
Sorry, I don't have the answer to your question, but, you may be able to help me to create a linked server to DB2/400 from 64 bit sql 2005. I am using IBM client access to create a system DSN and trying to use that System DSN as a data source for the linked server. Problem is "Oledb provider for Odbc" is not listed as a provider in sql2005. How did you solve that problem? Just FYI.. I tried to use the same method as I did in sql2000 environment, which have been working great for last 3 years.sql
No comments:
Post a Comment