Sql Server Linked Server to iSeries

30 pts.
Tags:
AS/400
Database Management Systems
Development
Microsoft Windows
Networking
SQL Server
Tech support
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
ASKED: November 19, 2004  6:03 AM
UPDATED: October 14, 2013  3:37 PM

Answer Wiki

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

Marco,
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.

http://blog.benjolo.com/archives/2003/08/27/mysql-mssql-linked-tables-or-just-kill-me-now/

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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:
    report
  • 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:
    report
  • 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:
    report

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following