title: ASP.Net C# - SqlDataSource and Oracle: The network path was not found
body: <p>Help please with my problem. I get an error when data from Oracle DB "drawing" on web page via asp:SqlDataSource and asp:ListView.</p>
  
  <p>I'm using ODP.Net driver and it works fine (I have many SELECT and UPDATE queries\commands in code-behind and they are working!). But when page must be rendered it says:
  "The network path was not found "</p>
  
  <pre><code>Exception Details: System.ComponentModel.Win32Exception: The network path was not found
  
  [Win32Exception (0x80004005): The network path was not found]
  
  [SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]
     System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5341687
     System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +546
     System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover) +5353471
     System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) +145
     System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) +923
     System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) +311
     System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData) +646
     System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) +278
     System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) +38
     System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) +732
     System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) +85
     System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal&amp; connection) +1057
     System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal&amp; connection) +78
     System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&amp; connection) +196
     System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +146
     System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +16
     System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +94
     System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +110
     System.Data.SqlClient.SqlConnection.Open() +96
     System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
     System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +316
     System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +86
     System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1474
     System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +21
     System.Web.UI.WebControls.DataBoundControl.PerformSelect() +138
     System.Web.UI.WebControls.ListView.PerformSelect() +167
     System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +30
     System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +105
     System.Web.UI.WebControls.ListView.CreateChildControls() +122
     System.Web.UI.Control.EnsureChildControls() +83
     System.Web.UI.Control.PreRenderRecursiveInternal() +42
     System.Web.UI.Control.PreRenderRecursiveInternal() +155
     System.Web.UI.Control.PreRenderRecursiveInternal() +155
     System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +974
  </code></pre>
  
  <p>Connection string (web.config):</p>
  
  <pre><code>&lt;add name="OracleDB" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=srv00)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=seln)));User Id=USR;Password=Password.USR;" /&gt;
  </code></pre>
  
  <p>SqlDataSource code:</p>
  
  <pre><code>&lt;asp:SqlDataSource ID="SqlDataSource1" ConnectionString="&lt;%$ ConnectionStrings:OracleDB %&gt;" runat="server"
      SelectCommand="SELECT Field1, Field2, Field3 FROM ban.fj_table WHERE Field1= :Field1"
  </code></pre>
  
  <p>And SELECT parameter of SqlDataSource:</p>
  
  <pre><code>&lt;SelectParameters&gt;
      &lt;asp:ControlParameter Name="Field1" ControlID="CntrlName" PropertyName="SelectedValue" /&gt;
  &lt;/SelectParameters&gt;
  </code></pre>
  
  <p>There's no code in code-behind for this operation.
  Thanx for any help.. And sorry for poor eng (:</p>