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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

BIDS Connection Manager Cannot Connect to Remote Oracle Db

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :Sql Server
Hi All,
I'm not having much luck getting an 'Oracle Provider for OLE DB' remote connection in connection manager to work when creating an SSIS package in BIDS.

I've covered off all the steps in the following link

The local machine is running SQL 2005 Sp2 Enterprise Edition on W2003 Sp2 Standard Edition X64

Using the Oracle 'Net Configuration Assistant' I can connect successfully to the remote service

I'm using ODAC 10g Release 2.

The steps to reproduce the error are as follows

1. in BIDS after creating an SSIS Solution
2. Right click in the  Connection Manager and select new OLE DB Connection
3. Click 'New'
4. Select 'Oracle provider for OLE DB'
5. Under server I enter the service name that I created in the Oracle 'Net Configuration Assistant'
6. Enter the user name and password as I entered in the Oracle 'Net Configuration Assistant'
7. When I click 'Test Connection' I get the following error

Test connection failed because of an error in initializing provider. ORA-12154: TNS could not resolve the connect identifier specified

I've spent a lot of time trying to get this to work and tried othe

View Complete Post

More Related Resource Links

Connect to an existing connection manager from within a custom transformation?

I'm developing a custom data flow transformation and have hit a roadblock.  I need to create an ADO connection to one of the connection managers that's defined in the package already.  I can either hardcode the name of the connection manager, or define it as a custom property....the problem I'm having is accessing it at all.  What I've found is that ComponentMetaData.RuntimeConnectionCollection[0].ConnectionManager only has the connection managers defined by the component itself, not already existing in the package.  How do I create a connection to a connection manager that's defined at the package level at design time? Thanks

SSRS 2008 - report manager: System.Net.WebException: Unable to connect to the remote server

I have an instance of Reporting Services 2008 running on Windows 2003 server.  So, the webservice URL is running on port 801, and runs fine (I can browse reports from that directory, and upload / deploy new reports and overwrite existing reports. Report manager is set to use port 800 (IIS is also on that machine running port 80).  When I attempt to connect to report manager, I get the following error, with a link to "Home" in report manager (which brings me back to the existing error page):    Unable to connect to the remote server  In the logfiles for reporting services, the following error is there: " System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it.   Any ideas? Windows Firewall is NOT running on this machine.   Thanks, Chrisrjp

The underlying connection was closed: Unable to connect to the remote server.




I get this error message when i kick off my web service to run. It gathers survey feedback from a database via http soap. Recently i put in a proxy that is required for access to internet. The web service started to fail that day as well. Can anyone tell me how i could hard code the proxy that should be used by the web service? I found this link: http://support.microsoft.com/kb/307220

and tried editing the machine.config file but that didn't fix my issue. Any Ideas?




8/2/2007 1:02:25 PM
The underlying connection was closed: Unable to connect to the remote server.
   at System.Net.HttpWebRequest.CheckFinalStatus()
   at Syst

Cannot connect to Oracle from BIDS


I receive error ORA-12154: TNS could not resolve the connect identifier specified
when trying to setup a datasourec within BIDS.

Strange here is that the creation of a linked server to the same Oracle db is working, also importing data from the Oracle db works perfectly; but when saving the import as a package, I get the same error when running the package in BIDS.

I run everyting on my local workstation which is 32 bit.

Thanks for any help

Need Oracle Data Provider .CS File for Oracle 10g Database connection !



I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where

i can just call the method with my SQL Query


Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");


Plz Post the link if there is any open source !    

Going Places: How Connection Manager Connects


Marcus Perryman explains the correct use of Connection Manager when a Windows Mobile application requires network data.

Marcus Perryman

MSDN Magazine December 2008

ASP.Net connect to Oracle.


 We have an application which uses  'System.Data.OracleClient'. On the box it was developed we can change the TNSNAMES.ORA entries to connect to different oracle databases. Moving the code to a  Microsoft Server 2008 box it would appear that the application ignores the TNSNAMES.ORA file. It has cached the first Oracle connection and will now work without any TNSNAMES.ORA file. Where is it getting the connection? We have set tns_admin to point at the TNSNAMES.ORA file. We can tnsping the connection OK.

Basic ODBC Connection to connect to Crystal ???


I have visual studio 2008 professional with the inbuilt crystal reports version 10 I think.  I create everything from my laptop and IIS runs from my laptop as well.

I have created the most basic report to try and figure out a problem I have, anyways the report contains one database field that is it .... which I connect to by ODBC.  I then create a web form add the crystal report viewer to the report and the crystal report source run the web page and it loads the data from the field as I would expect to the crystal report viewer !!

I have several ODBC connections setup on my machine one using integrated security the other using SQL authentication both are system DSNs.  Now when I publish my application and access it from IIS and not the localhost I can access everything from my application ok except when I go to form that has the crystal reports I get this error (ODBC used here is the 'sa' account)

Logon failed. Details: IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Error in File

If I use the other ODBC that uses Windows authentication I get this error message

Logon failed. Details: 42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database  requested by the login. T

An existing connection was forcibly closed by the remote host


I get this message when I try to launch a report (.rdl) from Windows Sharepoint 2007.  I have followed the steps to integrate SQL 2005 SP2 with Sharepoint 2007.  I can launch the report by navigating to "http://server:880/reportserver/.."  I am using a shared datasource that I created within sharepoint.  Any help would be appreciated.

How to Establish a Remote Web Site Connection in SharePoint Designer 2007


I am modifying a SharePoint site and so far so good.  Some of the objects were created using Visual Studio 2008 (C#).  I was able to modify these objects and implement them on the targete machine without issue.  The final step is to implement the ASPX pages that were modified using SharePoint Designer 2007.  These are aspx pages that are used to modify items in lists.  All the pages involved in this upgrade are customized.  I need to upgrade the target site with the modified version of these pages.  My intent is to copy the code from the page in the source site and past it into the same page on the target site.  I tried using the Remote Web Site connection tool in SharePoint Designer 2007 but received the following error message:

"Unable to open 'https://(site address)'.  Server Error:  Could not find a Web server at 'website'.  Please check to make sure that the Web server name is valid and your proxy settings are set correctly.  If you are sure that everything is correct, the Web server may be temporarily out of service."

I am not sure how to first check to see if the Web Server is temporarily out of service.  I would appreciate your input on how to verify this.

Background information of target machine:  WinServer 2008, IIS 7, Sharepoint (MOSS2007), site on port 80

need help about "Unable to connect to remote server." using HttpWebRequest


Hello friends 
I am creating an application where I want to store an html page from one of my websites into another web site. 
For the same purpose I am taking the url of the html pages 
for example if I want to copy this page "http://mydomain.com/html/page1.html" then i take this url from a text box which user enters.

Remoting from WebService throws: An existing connection was forcibly closed by the remote host

Hello everyone, I have a problem with using .NET remoting from webservice. When using remoting from console application, there is no problem. I suppose problem is somewhere in IIS. My system is Windows Vista. Thank you for any help. Best regards, Jozef

WCF issues sending large data - "An existing connection was forcibly closed by the remote host"

Hi Guys I have posted the following on www.asp.net but thought it might be productive posting here too.I have been pulling my hair out trying to fix an issue with sending data over WCF, I have read pretty much every THREAD on this forum regarding or similar to this issue without any successful solution.  I have a simple data object which has a [DataMember] with a data type of byte[]. I use this to send binary data from my web app as follows: Asp.net MVC website --> WCF Client (Has my Service References) --> My Services (MyServices.svc) --> Business/Data Tier Everything is being executed from within VS 2008 Pro.   Now I have successfully sent data up to 2.2MB, however it fails if i try and send a file such as 2.3MB or larger i get the following exceptions: General Exception Exception rethrown at [0]:    at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)   at SoftApp.WCFClient.MyServiceReference.IMyService.Document_Save(DtoDocument dtoDocument, Int32 usercode)   at SoftApp.WCFClient.MyServiceReference.MyServiceClient.Document_Save(DtoDocument dtoDocument, Int32 usercode) in c:\dev\softapp\softapp.wcfclient\service references\myservicereference\refe

Excel Connection Manager Problem

I am building a package that has 2 tasks that need to use the same excel connection manager. I use a execute sql task to dynamically build a table from the headers of the excel sheet  ,then I use an excel source component to load the data from the sheet. However when I try to edit the excel source and switch the data access mode to a variable and select the variable(for the path), when I try to close the editor I get this message 'S:\myfolder'.  It is already opened exclusively by another user, or you need permission to view its data. I need this package to access the same folder each time because the files will be placed in that folder. This package also has a branch for loading a text file into sql server. It access the same folder but uses a flatfile connection manager It looks like permissions on the folder are correct

Remote Connection Unavailable

Hello, I am attempting to attach to my new Windows 2008 R2 SQL Server 2005 standard clustered remotely.  The firewall is temp off, remote connections in the surface area configuration is set to pipes and tcp/ip.  I have attempted to check the browser configuration but I can't find this. I can attach to the sql server on my cluster but am unable to on a remote machine error is: Cannot connect to clustered name\instance name Addtional info A network-related or instance-specific error occured while establishing a connection to sql server.  The server was not found or was not accessible.  Verify that the instance name is correct and the SQL Server is configured to allow remote connections. Ideas? Thx -- Paul Bergson MVP - Directory Services MCITP: Enterprise Administrator MCTS, MCT, MCSE, MCSA, Security+, BS CSci 2008, Vista, 2003, 2000 (Early Achiever), NT4 http://www.pbbergs.com    Twitter @pbbergs Please no e-mails, any questions should be posted in the NewsGroup This posting is provided "AS IS" with no warranties, and confers no rights.

SQL Server Configuration Manager: Connection to target machine could not be made in a timely fashion

I have a SQL Server 2005 box that was moved from a domain environment to a non-domain environment and was never dropped from its original domain before moving over.  Subsequently a new domain was created at the data center this SQL Server box now resides in.  The machine was dropped from its old domain and joined to the new one.   All the while the service accounts were set to the local admin account.  When I tried to start the Configuration Manager I got the message "Connection to target machine could not be made in a timely fashion.".  I read some blog entries and tried changing all the service accounts to Local System and the error message still came up.   All of the SQL Server services run fine.  It is just this management console that I cannot open.  I wasn't with this employer when this box was moved to the data center so I do not know if it worked prior and there isn't anyone here that could give me its history.   Any help would be appreciated.

WCF Client (netTcpBinding) does not connect to remote DNS on Vista and Windows 7

Hi, WCF Client (netTcpBinding) does not connect to remote DNS on Vista and Windows 7. With other OS like XP and Windows 2003, client connects to remote DNS properly. I got the following exception. Same client works in Vista and Windows 7 if service is available in local network. Following are the exceptions: <Exception> <ExceptionType>System.ServiceModel.EndpointNotFoundException, System.ServiceModel, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType> <Message>No DNS entries exist for host icelive.theice.com.</Message> <StackTrace> at System.ServiceModel.Channels.DnsCache.Resolve(String hostName) at System.ServiceModel.Channels.SocketConnectionInitiator.GetIPAddresses(Uri uri) at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout) at System.ServiceModel.Channels.BufferedConnectionInitiator.Connect(Uri uri, TimeSpan timeout) at System.ServiceModel.Channels.TracingConnectionInitiator.Connect(Uri uri, TimeSpan timeout) at System.ServiceModel.Channels.ConnectionPoolHelper.EstablishConnection(TimeSpan timeout) at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.Comm
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