ASP.NET - Oracle using Asp.net:
Asked By vinod kumar on 19-Nov-12 08:21 AM
Hi Friends,
what is the SqlDataSourceEnumerator equivalent to Oracle?. I want to get all serverlist in Oracle. how can i get all servers list in Oracle?
Thanks
@vk
Robbe Morris replied to vinod kumar on 19-Nov-12 09:13 AM
What Oracle provider for .NET are you using? ODP.NET?
vinod kumar replied to Robbe Morris on 20-Nov-12 12:30 AM
Robbe Morris replied to vinod kumar on 20-Nov-12 07:45 AM
There is no native equivalent in .NET for Oracle. You'll have to issue native Oracle commands to iterate through the TNS entries.
NET 06-Jun-13 10:15 AM My code is like this: Imports System.Data.OracleClient 'Here oracle9i is TNS service name Dim connString As String = "server = oracle9i;uid = scott;password = tiger;" Dim oraCon As New OracleConnection(connString) Public bDbOpen As Boolean 'Using- --> OracleClient bDbOpen = False Try oraCon.Open() bDbOpen = True Catch ex As Exception MsgBox(ex.Message(), MsgBoxStyle Then only that wil work. keywords: Oracle, Error, OracleConnection, VB.NET, DB, oracle DB connection, OracleClient, Connect, oracle9i description: remote oracle DB connection My code is like this: Imports System.Data.OracleClient 'Here oracle9i is TNS service name Dim connString As St
Oracle, Oracle 10g Express, System.Data.OracleClient, "ORA-12514: TNS:listner Could Not Resolve SERVICE_NAME Given In Connect Descriptor" 06-Jun-13 10:18 AM Server name and put username and password. 4. I added a Reference named "System.Data.OracleClient" on Solution Explorer After that, when i clicked OK button. . . . it gives me an error message like "ORA-12514: TNS:listner could not resolve SERVICE_NAME given in connect descriptor" Can any one help me. . ??. . Cause will be deleted. keywords: Visual Studio .NETOracle DBMS, Oracle, Linux, OracleConnection, descriptor description: ORA-12514: TNS:listner could not resolve SERVICE_NAME given in connect descriptor I am trying to connect to
is what the error page looks like: [CODE] Server Error in ' / WebApplication1' Application. - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - ORA-12154: TNS:could not resolve the connect identifier specified Description: An unhandled exception occurred during the execution and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: ORA-12154: TNS:could not resolve the connect identifier specified Source Error: Line 48: Dim MyCommand As OleDbCommand typing in the windwows command prompt: [CODE] tnsping mobapp1 [ / CODE] It through an error saying "TNS-12541: TNS:no listener" I am just really confused. If there is anything you could do it would be really appreciative. Thanks ahead of time For error "ORA-12154: TNS:could not resolve the connect identifier specified " Do you get same error if you use the Microsoft or Oracle managed provider? System.Data.OracleClient or Oracle.DataAccess.Client. Check out http: / / www.oracle.com / technology / tech / windows / odpnet / index.html For error: "TNS-12541. . ." Check with the admin if oracle port is opened eg. 1521 Go on the
net application i need to list all sqlservers i have this code Dim servers As SqlDataSourceEnumerator = SqlDataSourceEnumerator.Instance Dim serversTable As DataTable = servers.GetDataSources() For Each row As DataRow In serversTable.Rows System.EventArgs) Handles Me.Load PopulateServers() 'PopulateDBs() End Sub Private Sub PopulateServers() Dim servers As SqlDataSourceEnumerator = SqlDataSourceEnumerator.Instance Dim serversTable As DataTable = servers.GetDataSources() For Each dr In serversTable.Rows Dim serverName net application i need to list all sqlservers i have this code Dim servers As SqlDataSourceEnumerator = Sq
ORA-01460 C# .NET 06-Jun-13 10:14 AM Issue: I get System.Data.OracleClient.OracleException was unhandled by user code Message = ORA-01460: unimplemented or unreasonable conversion requested Source = System.Data.OracleClient ErrorCode = -2146232008 Code = 1460 StackTrace: at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc) at System.Data OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals) at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor) at System.Data.OracleClient.OracleCommand.ExecuteNonQuery() at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteNonQuery(DbCommand command) at Microsoft.Practices.EnterpriseLibrary SQL developer, any string > 2000 also works. I think the issue is with System.Data.OracleClient. any ideas / pointers will be appreciated. try this This problem occurs when you use the description: Inserting long string ( 2000) in Oracle gives ORA-01460 Issue: I get System.Data.OracleClient.OracleException was unhandled by user code Message = ORA
siteUsers.NameTable); umanager.AddNamespace( "dfs" , "http: / / schemas.microsoft.com / office / infopath / 2003 / dataFormSolution" ); umanager.AddNamespace( "tns" , "http: / / schemas.microsoft.com / sharepoint / soap / directory / " ); / / get the node that contains all the users from the call to the web service XPathNavigator allusers = siteUsers.SelectSingleNode( " / dfs:myFields / dfs:dataFields / tns:GetUserCollectionFromSiteResponse / tns:GetUserCollectionFromSiteResult / tns:GetUserCollectionFromSite / tns:Users" , umanager); XPathNavigator siteUsersAndGroups = this .DataSources[ "SiteUsersAndGroups" ].CreateNavigator(); XmlNamespaceManager dmanager = new XmlNamespaceManager (siteUsersAndGroups.NameTable); dmanager.AddNamespace( "tns" , "http: / / schemas.microsoft.com / sharepoint / soap / directory / " ); / / get the node within this data source that represents users XPathNavigator dusers = siteUsersAndGroups.SelectSingleNode( " / SiteUsersAndGroups / tns:Users" , dmanager); / / fill this data source with the users returned by the web service call Users )); su = ( Users )serializer.Deserialize(allusers.ReadSubtree()); XPathNavigator siteUser = this .DataSources[ "SiteUsers" ].CreateNavigator().SelectSingleNode( " / SiteUsersAndGroups / tns:Users / tns:User" , dmanager); XPathNavigator currentNode = siteUser.Clone(); for ( int i = su.Items.Length - 1
hi Every one, System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. please help me Hi, The Client is not installed in your system You are refering to this namespace System.Data.OracleClient without Oracle Client installed in your system Try these- • Give full permission to AUTHENTICATED USERS Framework, Windows XP, NET Framework Data Provider, Oracle, The Oracle Data Provider description: System.Data.OracleClient requires Oracle client software version 8.1.7 hi Every one, System.Data.OracleClient requires Oracle client software version 8
i am getting this error when i connect to oracle System.Data.OracleClient requires Oracle client software version 8.1.7 or greater but i able to connect Data OracleClientVisual Studio .NET, Oracle, Application Pool, ASP.NET, Oracle client software description: System Data OracleClient requires Oracle client i am getting this error when i connect to oracle System.Data.OracleClient requires Oracle client softw