I need to connect to an oracle DB from SQL server 2008

Posted on 2011-03-07
Last Modified: 2012-05-11
Ive enabled Allow in process under providers
I keep getting connection Failed messages
Is there a simple Instruction sheet ( yeah I know ).
I have a connection in my ODBC sources

Question by:Mswetsky
  • 3
  • 2
LVL 15

Expert Comment

ID: 35058549

Author Comment

ID: 35058596
Thanks Derek but I don't think this is applicable to server 2008.
Ive review it already and am lost
LVL 15

Accepted Solution

derekkromm earned 500 total points
ID: 35058691

Author Closing Comment

ID: 35059150
Thanks, This is just what I needed!
LVL 15

Expert Comment

ID: 35059156
Sorry about the initial version confusion - the question was in the SQL Server 2005 zone and I didn't catch that you were using 2008 from the title. Glad I could help.

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Divide by zero error encountered. 2 39
Why do I get extra rows when I do inner join? 12 39
SQL query to summarize items per month 5 59
Email Notifications for SQL 2005 9 28
This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question