Link SQL 2000 to AS400

[pholtquist]

Hello

I am trying to link SQL2000 to AS400. I have created the link and can access the data on the Server, but when I try to access from a client I get the following error:

Error 7399: OLE DB Provider 'MSDASQL' Reported an error. Data Source Name not found and no default driver specified.

Has anyone run into this and if so does anyone have a solution to this problem?

Any help would be greatly appreceiated.

Thanks
Phil

[rmiao]

Did you connect to sql2k server from the client? What's the query did you use?

[pholtquist]

If I go to the server, I can connect to the AS400 and submit queries. If I go to a client running SQL 2000, I get the error.

The SQL statement that I try through the client is:

SELECT * FROM AS400_NEW.AS400.GENPRDDTA.F0006

Is there anything else that I should be doing?

Thanks for your help
Phil

[rmiao]

What do you mean 'client running SQL 2000'? Did you try connect to sql server from client with query analyzer and run the query? Did you try openquery instead?

[Peter]

Do you have the Client Access DSN installed on the client? It seems to be a DSN/driver matter.

[farny]

Linked servers use the DSN on the server side as far as I know. I know that DTS can use the client side or the server side DSN's but linked server is strictly server side.