Sql Server Linked Server to iSeries

30 pts.
Database Management Systems
Microsoft Windows
SQL Server
Hi everybody, I get the following exception [Non-interface error: CoCreate of DSO for MSDASQL returned 0x80040154] on an iSeries configured as Linked Server in MS-Sql Server everytime I attempt to execute a query (Read Only !) from any PC in a windows Workgroup exception for the PC on which SQL Server is installed. I repeat (sorry for my poor english): The query works fine on the application from the 'server' PC but the same query brokes in the mentioned error from any other PC. Anyone can help ? Thanks in advance Marco

Answer Wiki

Thanks. We'll let you know when a new response is added.

Havn’t done anything with linked servers myself, but came across the info below when looking for something else recently. Even if it doesn’t help you directly I think would be worth posting your problem to.


Discuss This Question: 3  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • swede27410
    how are you attempting to access the data... the sql code should look something like this: select column names from linked_servername.catalogname.ownername.filename.tablename
    0 pointsBadges:
  • BeerMaker
    When you say its the same query on a different PC. Are you using the same software (i.e. Query anlayzer)? Is it the same login account? Be sure permissions are setup correctly on the linked server.
    0 pointsBadges:
  • Technet
    Excuse me for my late response. Thanks a lot swede and beermaker ! swede: I'm quite sure the way I request the data is ok. It runs fine on the only PC with MSDE (2000 SP3) installed. something like: ... from AS400.S1234567.LIBRARY.TABLE beermaker: The query is the same from every PC cause it's run from my application (the same installed on every PC). About the permissions: The linked server is configured without specifying explicitly any SQL Server login but as 'running under following protection context:' (the 4th radio button in the linked svr properties protection tab) followed by a correct USER/PASSWORD with secofr permissions on the iSeries. i.e. with T-SQL: sp_addlinkedsrvlogin , 'false' , NULL , '' , '' The SQL Server authentication mode is 'Windows'. Any other query run on tables NOT LINKED but local inside the SQL Server (default instance) database are succesfully reading/writing from any PC. Do you think I have to check/setup something else ? (I use SQL Server Dev.Ed.) You both have been very kind ! I hope you can tell me something more...this is my first experience with MSDE/SQL Server... Thanks again.
    30 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: