Error 7350
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about
Cannot Get The Column Information From Ole Db Provider For Linked Server
hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask mysql linked server query Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other.
Query Mysql Linked Server Without Openquery
Join them; it only takes a minute: Sign up SELECT * FROM Linked MySQL server up vote 1 down vote favorite I have a SQL Server 2012.(120.120.55.15) Today I linked MySQL server(120.120.55.30) to my SQLServer and gave it a link sql server to mysql name "MYSQL". In Object Explorer everything seems fine. I can see MySQL server's database "exampleDataBase" and tables in it. But when I try to run select query like this: SELECT * FROM openquery ( MYSQL, ' SELECT * FROM [exampleDataBase].[msProcMatrix] ' ) I get a mistake: Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "MSDASQL" for linked server "MYSQL" reported an error. The provider did not give any information about the error. Msg 7350, Level query sql server from mysql 16, State 2, Line 1 Cannot get the column information from OLE DB provider "MSDASQL" for linked server "MYSQL". What should be additionally done to use my linked MySQL server? sql sql-server mysqli linked-server ssms-2012 share|improve this question edited May 22 '13 at 9:37 whytheq 14.6k3383169 asked May 22 '13 at 9:17 Almazini 6001619 add a comment| 5 Answers 5 active oldest votes up vote 6 down vote accepted Found the decision: SELECT * FROM openquery(MYSQL, 'SELECT * FROM exampleDataBase.msProcMatrix') Without brackets! Strange for me but works... share|improve this answer edited Jan 13 at 7:48 veljasije 2,93132854 answered May 22 '13 at 10:42 Almazini 6001619 It's the proper way to escape column names in MySQL (NOT MSSQL!) See: stackoverflow.com/a/2889884/244067 –Filip Jun 12 '14 at 14:14 add a comment| up vote 2 down vote This worked great for me after fighting the same issue on MS SQL Server 2008 64bit using the MY SQL 3.51 64 bit ODBC driver SELECT * FROM OPENQUERY ( linked_server_name, 'SELECT * FROM linked_database_name.linked_table_name' ) share|improve this answer edited Oct 17 '13 at 18:50 Jon Lin 127k18128145 answered Oct 17 '13 at 18:31 user2891719 213 add a comment| up vote 1 down vote When I working with linked server, I never use Select * From. Try with Select Column1, Column2, ... ColumnN From. Always works fine for me. share|improve this answer edited Jan 28 '14 at 14:58
Jump to: navigation, search Web Services Contents 1 Overview 2 Video Tutorials 3 Required Permissions 4 Configuring SQL Server 4.1 SQL Server Connection String 4.2 Using sp_addlinkedserver 5 Troubleshooting Linked Server 5.1 Access Denied
Msg 7350
Errors 5.2 Number Precision Errors 1 Overview Use the ServiceNow ODBC driver in SQL cannot create an instance of ole db provider "msdasql" for linked server Server as a Linked Server. This allows SQL Server to query tables from a ServiceNow instance directly via the ODBC Driver. Use these
Invalid Use Of Schema Or Catalog For Ole Db Provider
procedures only with a supported version of SQL Server. Other versions of SQL Server may cause unexpected behavior. If you encounter unexpected behavior, refer to the troubleshooting linked server knowledge article. 2 Video Tutorials Configure Microsoft http://stackoverflow.com/questions/16687999/select-from-linked-mysql-server SQL Linked Server Troubleshooting Linked Server Permissions 3 Required Permissions Additional information on the required permissions for SQL Server Linked Servers can be found on the MSDN blog. Note: Review this information if you encounter permission errors with SQL Server. 4 Configuring SQL Server The following example configuration was performed on SQL Server 2008, installed on Windows Server 2008. Right-click the SQL Server Management Studio application and select as Run as Administrator. Log in https://wiki.servicenow.com/index.php?title=Using_ODBC_Driver_in_SQL_Server_2008 to the database to which you want to link. Right-click on Server Objects > Linked Servers. ClickNew Linked Server. Enter the following values in the dialog. Linked server: SERVICENOW. This is the name of the Linked Server. Provider: Microsoft OLE DB Provider for ODBC Drivers Product name: ServiceNow. This is an identifier. Enter any value that is appropriate. Data source: ServiceNow. This is the name of your DSN. Select Security from the Select a page list, and then enter the following security values: a. For a login connection, select Be made using this security context. b. Enter the user name and password for connecting to the ServiceNow instance. c. Click OK. Navigate to Server Objects > Linked Server > Providers and double-click Microsoft OLE DB Provider for ODBC Drivers. Select the following options. Nested Queries Level zero only Support 'Like' operator Tip: ServiceNow recommends running the third-party provider in the out-of-process mode setting (AllowInProcess=FALSE). If you run the provider in-process (within the same process as SQL Server), then any issues with the provider can affect the SQL Server process, which in turn could result in crashing SQL server. Test your connection by selecting the newly created linked server SERVICENOW and selecting Test connection. Execute the following query in a query builder window to retrieve some results. 4.1 SQL Server Connec
sophisticated digital experiences Web content & Customer Journey Sitefinity CMS Build engaging websites with intuitive web content management Application Development, Testing & Deployment DevCraft Leverage http://knowledgebase.progress.com/articles/Article/P191553 a complete UI toolbox 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 linked server or JavaScript to build truly native mobile apps Rollbase 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 ole db provider Data Connectivity DataDirect Connectors Optimize data integration with high-performance connectivity Business Rules Management 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 B