Home > IT Answers > AS/400 > Sql Server Linked Server to iSeries
Technet
30 pts.
 Sql Server Linked Server to iSeries
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

Software/Hardware used:
ASKED: November 19, 2004  6:03 AM
UPDATED: November 26, 2004  9:06 AM
RELATED QUESTIONS
Answer Wiki:
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/
Last Wiki Answer Submitted:  November 19, 2004  7:10 am  by  PeterMac   0 pts.
All Answer Wiki Contributors:  PeterMac   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

swede27410
 0 pts.
 

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.

BeerMaker
 0 pts.
 

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.

Technet
 30 pts.