Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | Peter99Constraint Violating Yak Guru
 
 
                                        498 Posts | 
                                            
                                            |  Posted - 2013-04-16 : 15:42:02 
 |  
                                            | Hi,I have linked server to AS400. When I run select * ...... on linked server there is errror: "The OLE DB Provider "IBMDASQL" for linked server "......" reported an error. The provider ran out of memory. Cannot obtain the schema rowset "......" for OLE DB provider. Any help?Thanks |  |  
                                    | russellPyro-ma-ni-yak
 
 
                                    5072 Posts | 
                                        
                                          |  Posted - 2013-04-16 : 21:32:59 
 |  
                                          | Can you access anything on the 400?What is the actual query? |  
                                          |  |  |  
                                |  |  |  |