Microsoft Sql Error 7399 Oracle
Contents |
up Recent PostsRecent Posts Popular TopicsPopular Topics Home cannot initialize the data source object of ole db provider oraoledb.oracle for linked server 7303 Search Members Calendar Who's On Home » SQL Server 7,2000 »
Sql Server Oracle Linked Server Query Syntax
Working with Oracle » Getting Error 7399 - OLE DB provider... Getting Error 7399 - OLE sql server 2012 linked server oracle DB provider 'ORAOLEDB.ORACLE' reported an error. The provider did not give any information about the error. Rate Topic Display Mode Topic Options Author Message Marios PhilippopoulosMarios Philippopoulos microsoft sql server error 7303 linked server oracle Posted Thursday, April 17, 2008 4:04 PM SSCommitted Group: General Forum Members Last Login: Friday, October 14, 2016 4:47 AM Points: 1,869, Visits: 3,726 I'm getting the following error while using OPENROWSET:OLE DB provider 'ORAOLEDB.ORACLE' reported an error. The provider did not give any information about the error. [SQLSTATE 42000] (Error 7399) OLE DB
Cannot Get The Column Information From Ole Db Provider "oraoledb.oracle" For Linked Server
error trace [OLE/DB Provider 'ORAOLEDB.ORACLE' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.]. [SQLSTATE 01000] (Error 7300). The step failed.The OPENROWSET call is done like this:SET @SQL = 'INSERT INTO #tbl (col1, col2, col3) SELECT [col1], [col2], [col3] FROM OPENROWSET(''ORAOLEDB.ORACLE'','''+@Server+'''; '''+@Login+'''; '''+@Password + ''','''+ @querysql + ''')EXEC (@sql)Anyone have any ideas what could be wrong and how to fix it?Thanks! __________________________________________________________________________________Persisting SQL Server Index-Usage Statistics with MERGETurbocharge Your Database Maintenance With Service Broker: Part 2Turbocharge Your Database Maintenance With Service Broker: Part 1Preparing for the Unthinkable - a Disaster/Recovery Implementation Post #486832 lucky-80472lucky-80472 Posted Thursday, April 17, 2008 4:18 PM Ten Centuries Group: General Forum Members Last Login: Thursday, January 28, 2016 12:54 PM Points: 1,295, Visits: 842 Marios Philippopoulos (4/17/2008)I'm getting the following error while using OPENROWSET:OLE DB provider 'ORAOLEDB.ORACLE' reported an error. The provider did not give any information about the error. [SQLSTATE 42000] (Error 7399) OLE DB error trace [OLE/DB Provider 'OR
360 games PC games ole db provider oraoledb.oracle for linked server returned message ora-12154 Windows games Windows phone games Entertainment All Entertainment error 7399 linked server sql server Movies & TV Music Business & Education Business Students & educators
Allow Inprocess
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://www.sqlservercentral.com/Forums/Topic486832-1043-1.aspx Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/280106 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
Server 2016 SQL Server 2014 SQL Server 2012 SQL Server 2008 AdministrationBackup and Recovery Cloud High Availability Performance Tuning PowerShell Security Storage Virtualization DevelopmentASP.NET Entity Framework T-SQL Visual http://sqlmag.com/sql-server/sql-server-and-oracle-making-connection Studio Business IntelligencePower BI SQL Server Analysis Services SQL Server Integration Services http://stackoverflow.com/questions/4833409/connect-oracle-to-sql-management-studio SQL Server Reporting Services InfoCenters Advertisement Home > SQL Server > SQL Server and Oracle: Making the Connection SQL Server and Oracle: Making the Connection Oct 23, 2001 John Paul Cook | SQL Server Pro EMAIL Tweet Comments 19 Advertisement Linked servers can bring your SQL Server and Oracle databases linked server together Suppose you have a Microsoft .NET-enabled Internet ordering system but your warranty system is a legacy Oracle database application. You don't want to bill your commercial customers when they place orders for warranty replacement parts, so you need realtime answers from your Oracle database. Creating a linked server lets you use SQL Server to query your Oracle database in realtime to ole db provider find out who your existing customers are. When your data is distributed across several databases on multiple SQL Servers, linked servers let you run queries distributed across those servers. When all the servers are SQL Servers, configuration is easy, and SQL Server Books Online (BOL) covers everything you need to know. However, if some of your data is on an Oracle database, for example, configuring a linked server brings special challenges. You need to understand that even if you configure an Oracle linked server in SQL Server Enterprise Manager, your SQL Server is a client of your Oracle database. Therefore, you must successfully install and configure Oracle client software on your SQL Server. Oracle provides product support only for Oracle8 and later, so this article assumes that you're running Oracle8 or later. The Oracle Net8 library provides the client software that SQL Server needs. In Oracle, a schema is the name for the entity SQL Server professionals know as a database. To connect to Oracle, you need to supply the schema name, password, and host string. An Oracle schema is owned by a spec
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 hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Connect Oracle to Sql Management Studio up vote 1 down vote favorite I am trying to connect oracle 9i database using SQL Management studio 2008. I tried this but it doesn't work EXEC sp_addlinkedserver 'OracleLinkedServer','Oracle','OraOLEDB.Oracle','TestDB'; EXEC sp_addlinkedsrvlogin 'OracleLinkedServer','false','SA','TestUsername','TestPassword'; I am able to create the linked server and it test correctly, But when I execute this statement: SELECT sysdate FROM OracleLinkedServer...dual; ...it gives an error: Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "OraOLEDB.Oracle" for linked server "OracleLinkedServer" reported an error. Provider caused a server fault in an external process. Msg 7311, Level 16, State 2, Line 1 Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider "OraOLEDB.Oracle" for linked server "OracleLinkedServer". The provider supports the interface, but returns a failure code when it is used. sql sql-server oracle linked-server share|improve this question edited Jan 28 '11 at 21:54 OMG Ponies 199k37359417 asked Jan 28 '11 at 21:52 Naveen Chakravarthy 2531721 1 Do you have the TNS name stuff set up correctly on the SQL Server Box (or are you using the version of the oracle client drivers that use host name resolution)? –RQDQ Jan 28 '11 at 22:01 I connect using pl/sql developer to the same oracle database. –Naveen Chakravarthy Jan 28 '11 at 22:12 1 Try to execute this: SELECT * FROM OPENQUERY(OracleLinkedServer, 'SELECT sysdate FROM DUAL'). –Johnny Jan 30 '11 at 10:51 ad