.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

Is it possible to use ODP.NET under SQL CLR and how?

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Hi. Is it possible to use odp.net(Oracle.DataAccess.dll)  under SQLCLR circumstance on MSSQL Server 2005 ? I'd like to create a dll using odp.net to connect and retreive data from remote oracle server.  And I'd like to call a dll function in MSSQL Server. I don't know how to register Oracle.DataAccess.dll and my custom dll on mssql server using CREATE ASSEMBLY . It always raised a error . I don't like to use MS Oracle Provider Or Linked Server. In Visual Stuido SQL Server Project type supports MS ORacle Provider library whne i try to refer other dll. How can i use ODP.NET dll as same as using MS Oracle provider dll? I don't get how to register ODP.NET dll on MSSQL Server? Could you please tell me steps to register odp.net dll on sql server and making custom library using odp.net and call custom library function on MSSQL Server 2005? Any advice will  be apprecitated in advance Regards,Park  

View Complete Post

More Related Resource Links

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend