Linked Server Error 7311
Contents |
OLE DB provider "SQLNCLI10" for linked server ‘LinkedServerName’" ★★★★★★★★★★★★★★★ SnehadeepAugust 9, 20122 Share 0 0 When we create linked server for SQL server 2000 on SQL server 2005/SQL server 2008 /SQL server 2008 R2 sometimes we see errors cannot obtain the schema rowset dbschema_tables for ole db provider w.r.t schema. In this blog, I will discuss on why we get this type
Cannot Obtain The Schema Rowset Dbschema_tables_info For Ole Db Provider
of error and also the solution to fix the error message. There is a well know issue when you try to run
Sql Server Error 7311
distributed queries from a 64-bit SQL Server client to a linked 32-bit SQL Server, you might get the below error. " Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "
Msg 7311, Level 16, State 2, Line 1
The provider supports the interface, but returns a failure code when it is used." More Information http://support.microsoft.com/default.aspx?scid=kb;en-us;906954 I had a chance to work with one of the DBA's from prestigious company where they were getting same error while creating the linked server for SQL Server 2000 on SQL server 2008 R2. Error Message: Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI10" for linked server "LINKEDSERVERNAME". The provider supports the interface, sp_tables_info_rowset_64 but returns a failure code when it is used. Main Cause of this issue: · This problem occurs because the system stored procedures were not upgraded to SQL Server 2000 SP3 or SQL Server 2000 SP4. · May not have manually upgraded the system stored procedures after installing SQL Server 2000 SP3 or SQL Server 2000 SP4. · This step is not specific to SQL Server 2000 SP3 64-Bit, but applies to SQL Server 2000 SP3 32-Bit as well. · "You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005/SQL server 2008/SQL server 2008 R2 client to a linked 32-bit SQL Server 2000 server" · Whenever MDAC is upgraded to a newer version during SQL Server SP3 upgrade, one needs to run INSTCAT.SQL on all SQL Servers to which it connects to, including the Server that is being upgraded Resolution steps: · The system administrator should back up the master database before running Instcat.sql. · Log on to the computer (SQL server 2000 server) by using a Windows account, whichis a member of the SQL Server sysadmin fixed server role. · Click Run, type cmd.exe, and then click OK. · At the command prompt, type one of the following commands, and then press ENTER o osql -E -S
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » SQL Server 2005 General cannot obtain the schema rowset dbschema_tables for ole db provider msdasql Discussion » Problem setting up linked server 14 posts,Page 1 of 212»» Problem microsoft sql server error 7311 oracle setting up linked server Rate Topic Display Mode Topic Options Author Message Kenneth.FisherKenneth.Fisher Posted Monday, April 28, 2008 1:31 PM cannot obtain columns rowset from ole db provider Hall of Fame Group: General Forum Members Last Login: Today @ 11:25 AM Points: 3,483, Visits: 2,000 First I am working in a virtual environment with 2 virtual servers that were created with exactly https://blogs.msdn.microsoft.com/dataaccesstechnologies/2012/08/09/error-while-creating-linked-server-cannot-obtain-the-schema-rowset-dbschema_tables_info-for-ole-db-provider-sqlncli10-for-linked-server-linkedservernamequo/ the same specs.Server 1 I am able to create my Oracle Linked Servers and use them with no problems. I am using the Microsoft OLE DB Provider for Oracle.Server 2 I have the following issues:When using the Microsoft OLE DB Provider for Oracle I I get the following error when I try to test or create the Linked Server: "Cannot initialize the data source object of OLE http://www.sqlservercentral.com/Forums/Topic491682-149-1.aspx DB provider "MSDAORA" for linked server "TEST". OLE DB provider "MSDAORA" for linked server "TEST" returned message "Oracle error occured, but error message could not be retrieved from Oracle." Microsoft SQL Server, Error 7303)When I use the Oracle Provider for OLE DB I get a series of different errors depending on what I'm doing and where I'm calling the query from.If I try to do a query remotly (ie from my desktop) I get the following error if I use OpenQuery or try to use a 4 part name.Msg 7302, Level 16, State 1, Line 1Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "ORCL816n".Now if I RDP to the server I get the following errors:If I do a query using a 4 part name I getOLE DB provider "OraOLEDB.Oracle" for linked server "ORCL816n" returned message "Table does not exist.".Msg 7311, Level 16, State 2, Line 1Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider "OraOLEDB.Oracle" for linked server "ORCL816n". The provider supports the interface, but returns a failure code when it is used.If I use an openquery I get the first row of the table and the following error:Msg 7399, Level 16, State
sophisticated digital experiences Web content & Customer Journey Sitefinity CMS Build engaging websites with intuitive web content management Application Development, Testing & Deployment DevCraft Leverage a complete UI toolbox http://knowledgebase.progress.com/articles/Article/3479 for web, mobile and desktop development OpenEdge Build, protect and deploy apps across any platform and mobile device Kendo UI Build rich, smart HTML5 and JavaScript apps for any platform, browser or device Telerik Platform Build mobile apps for iOS, Android and Windows Phone Nativescript Use Angular, TypeScript or JavaScript to build truly native mobile apps Rollbase cannot obtain Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud Test Studio Automate UI, load and performance testing for web, desktop and mobile Modulus Host, deploy and scale Node.js, Java and .NET Core apps on premise or in the cloud Data Connectivity DataDirect Connectors Optimize data integration with high-performance connectivity Business Rules Management ole db provider Corticon Automate decision processes with a no-code business rules engine View All Products Solutions Digital Business Transformation Transform your businesses in order to survive in a completely digitized and connected world driven by software innovation. Web Scale Globally scale websites with innovative content management and infrastructure approaches Modernization UX and app modernization to powerfully navigate todays digital landscape Omni-Channel Engagement Content-focused web and mobile solution for empowering marketers aPaaS Fuel agility with ever-ready applications, built in the cloud Enterprise Mobility Faster, tailored mobile experiences for any device and data source New & Trending E-book The Digital Ultimatum: Why Businesses Must Digitally Transform to Survive â€" and Thrive Survey Report The State of Digital Business Support & Learning Support Support Services Knowledge Base Customer Order Management Download Center Services Training Consulting Services Managed Database Offering Learning Documentation Webinars How-To Videos Whitepapers Community Blogs Success Stories Partners Company Login Progress Support Rollbase DataDirect Cloud PartnerLink Telerik Your Account Telerik Platform Global Sites Brazil France Germany Netherlands United States Menu 1-800-477-6