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


Post New Web Links

connect using Oracle.DataAccess.Client

Posted By:      Posted Date: October 01, 2010    Points: 0   Category :ASP.Net
 

Hi all,

I want to insert some values (from asp.net  web application) in a table on oracle DB that hosted on a machine rather than the machine that hosts the asp.net application

i use "oracle.dataaccess.client" and  the following function

  Function DB_Insert_HIS_ORACLE_cn1(ByVal InsertStatment As String) As Integer

        Dim identity As Integer


        Dim oradb As String = "Data Source=(DESCRIPTION=" _
           + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=150.173.10.61)(PORT=1522)))" _
           + "(CONNECT_DATA=(SERVER=NOOR)(SERVICE_NAME=NOOR)));" _
           + "User Id=via;Password=fly;Connect Timeout=5"

        Dim conn As New OracleConnection(oradb)
        conn.ConnectionString = oradb
        conn.Open()



        Dim sql As String = InsertStatment
        Dim cmd As New OracleCommand(sql, conn)
        cmd.CommandType = CommandType.Text
        identity = cmd.ExecuteNonQuery()

        conn.Close()
        conn.Dispose()



        Return identity

    End Function


but i get the following exception

The type initializer for "Oracle.DataAccess.Client.OracleConnection" threw an exception

please help me knowing that i don't know anything about the machine that hosts the oracle db except the machine name,db


View Complete Post


More Related Resource Links

Errors in the back-end database access module. The managed provider 'Oracle.DataAccess.Client' cou

  
Hi. I have connected my SSAS in SQL server 2008 to an Oracle database.  I have installed the Oracle ODAC to enable me to set up the Data Source, the Data Source View and the Cube.  Now everything was going fine.  I could connect to the Oracle Database and I could see my tables and pull them into the DSV. But.  When I come to process the Cube it throws these errors.  Why all of a sudden do the connection objects stop working? Errors in the back-end database access module. The managed provider 'Oracle.DataAccess.Client' could not be instantiated. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DBIBGEORAclients', Name of 'DBIBGEORAclients'. Can anyone help here please? Thanks, David.

Oracle.DataAccess.Client very slow

  

When I run my piece of SQL through SQL developer it takes less than half a second with an overall cost of 618 on the explain plan.

When I run the same SQL through .NET via the oracle.dataaccess.client connection it is impossibly slow taking over 5 minutes to run.

What could be causing this and what can I do?


Oracle.DataAccess.Client.OracleException: ORA-03113:end-of-file on communication channel in Oracle 1

  

ORA-03113: end-of-file on communication channel

Exception details: Oracle.DataAccess.Client.OracleException: ORA-03113:end-of-file on communication channel

 My database is Oracle 10g, I am using .NET Framework 3.5 with Visual Studio 2008.

 It happened only once when first time in the morning I open my URL in my test server then this error popup at very first page of my site.

Next time onwars it work perfectly fine.

 Any Idea friends, Have you face the similar error, please tell me in details.

Thanks,

Vivek


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.


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=3.0.0.0, 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

Unable to connect to SQL Server 2005 remotly, all client protocols are blank

  
I have an installation of SQL 2005 and had issues connecting remotly. Looking at the client protocolols, they are all blank. I can see that TCPIP, Named Pipes, VIA, etc. are 'enabled', but where the words 'TCPIP', 'Names Pipes', etc. should be, it's just blank. I tried to install SQL 2008R hoping the Client Protocols would be corrected during the installaion, but they were not. I'm assuming the issue with the Client Protocols not showing up is a symptom of the problem. Does anyone have any ideas? Thanks!

connect client certificate to an account in a membership database

  
Hello I have created a web service that authenticates with username and password, works fine.Basically this one, http://msdn.microsoft.com/en-us/library/ff649647.aspxNow I also want to connect to this web service using client certificates, works finehttp://msdn.microsoft.com/en-us/library/cc948997.aspx But I would like to when authenticated via client certificates, connect that certificate to a user in the membership database.So that I can use Roles.IsUserInRole(...) and such.I thought that, well if I implement a Custom certificate Validatorhttp://msdn.microsoft.com/en-us/library/ms733806.aspxthen I could check for example subject and map that against a created username in the membership database.But in the class X509CertificateValidatorpublic override void Validate(X509Certificate2 certificate)I don't have the same ability as when the user is authenticatedlike  void OnAuthenticateRequest(object source, EventArgs eventArgs)HttpApplication app = (HttpApplication)source;Basically how can I do this app.Context.User = new GenericPrincipal(new GenericIdentity(username, "Membership Provider"),roles);withinpublic override void Validate(X509Certificate2 certificate)and if that is not possible, can this be solved differently?Bottom line, how do I connect a client certificate to a user account in the membership database. Is there a MSDN article

Unable to connect Oracle UCM Secured site with .NET Application

  
Hi, I am working on an integration of a .NET application which calls Oracle UCM web services which does Search, checkin of files to Oracle UCM( Stellent). Here i have an option to connect to a secured Oracle UCM server with credentials which retrieves the result. Here i am facing a problem. When we send a (https://) request we are getting an error as shown below: The underlying connection was closed: An unexpected error occured on a send. We are unable to do any code change on web services code as we have only the wsdl files. Tried Timeout related procedures which didnt work out. One more thing noticed is the .NET program connect to a http:// web url but not to https://. Is this a https:// issue with .NET application?   Kindly help with any inputs      

Unable to connect Oracle UCM Secured site with .NET Application

  
Hi, I am working on an integration of a .NET application which calls Oracle UCM web services which does Search, checkin of files to Oracle UCM( Stellent). Here i have an option to connect to a secured Oracle UCM server with credentials which retrieves the result. Here i am facing a problem. When we send a (https://) request we are getting an error as shown below: The underlying connection was closed: An unexpected error occured on a send. We are unable to do any code change on web services code as we have only the wsdl files. Tried Timeout related procedures which didnt work out. One more thing noticed is the .NET program connect to a http:// web url but not to https://. Is this a https:// issue with .NET application?   Kindly help with any inputs      

WCF client consuming oracle webservice is inconsistently works

  
Hi, In my WCF client application, I am consuming the Oracle  webservices. Strangely this wcf client functioning inconsistently. That means sometime, it does not find the service endpoint and some times it does. Where the code and environment are absolutely same in both the cases. But when I use web services, I see the code works consistently. There is no endpoint listening at the address http://<serviceurl> Does any one faced similar issue with WCF? Thanks!

The provider is not compatible with the version of Oracle client

  
I am having the error stated above. The stack trace is as follows: [OracleException: The provider is not compatible with the version of Oracle client] Oracle.DataAccess.Client.OracleInit.Initialize() +550 Oracle.DataAccess.Client.OracleConnection..cctor() +518 [TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.] Oracle.DataAccess.Client.OracleConnection..ctor() +51 InputForm.SelectRegion() +123 InputForm.Initialize() +952 InputForm.Page_Load(Object sender, EventArgs e) +53 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25 System.Web.UI.Control.LoadRecursive() +71 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3048   Some info's: Server: Windows Server 2008 R2 .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1 Oracle.DataAccess, Version=1.102.3.0 Dev Computer: Windows Vista Business 32bit .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1 Oracle.DataAccess, Version=1.102.3.0 My Code: OracleConnection cn;String con1 = ConfigurationManager.ConnectionStrings["myConnectionString"].ToString();cn = new OracleConnection();cn.ConnectionString = con1;cn.Open(); string mysql = "select region_code, 'Region ' || reg_

How can a C# client app list the authorized CA certificates sent by a web server over an SSL connect

  
Hello, I am currently writting a C# client application that must access a web page over SSL authentication, having the Client authentication required. I know that the SSL protocol defines that the web server sends the list of authorized Certification Authority that the web server can trust for the SLL session to be successful. My client application has to filter a X509Certificate collection in order to popup a Certificate Selection dialog box to the user. I fould like to only display certificates that the web server would accept. I already have filtered the certificates according to the "Client Authentication" Enhanced Key Usage and other stuf. I know how to set the client certificate to be used for SLL conection, but I just would like to access the CA cert list provided by the server.   Could someone help me ? Thanks a lot !

Can not connect to SQL 2005 Instances from Client

  
Dear Experts I have a problem. I am not able to connect to Remote SQL Server instances from my PC. Though some of my team members are able to connect to the Instances without any problem. We have tried with all the below options and no joy. 1. We tried connecting, with the IP Address, like IP\<ServerInstance>, Port# 2. Added the IP address to Host file with the network address and tried, like <WINServerName>.<networkaddress>\<ServerInstance>, Port#, even without the Port#. 3. Tried to create an ODBC DSN, why this because, this had resolved the issue some times. Thought will help, but didn't work out. After all these, whenever we tried to connect to the server, we received the below error message. Error Message : Can not connect to <WINSERVER>.NetworkAddress\<DBInstance> 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 that SQL Server is configured to allow remote connections. (Provider :TCP Provider, error:0 - No such Host is known) (Microsoft SQL Server, Error - 11001). Kindly help to resolve this issue. I have been strugling since quite some time. Regard Deepak

The provider is not compatible with the version of Oracle client

  
We are getting following error message while trying to execute sql package thru 'ExecuteNonQuery' our .NET code. This was working perfectly few days back, but suddenly VS2008 on our local is not able to execute the code. We are not sure what had exactly happened here, but code stopped working  on all develop machine all of sudden    Details for the error are as follows "The provider is not compatible with the version of Oracle client" or sometimes "Typeinitializer exception" We were using oracle.dataacess.dll version 1.102.3.0 which was working fine.It still works fine when we deploy it in the production. We checked the GAC of the developer machines and Server,i found one difference that in the GAC of the server only the 1.102.3.0 is installed while on the developer machines,two version of oracle.client are installed in the GAC,one is 1.102.3.0 and the other is 1.102.4.0 When we run the code,it might be the case that .net framework is picking up 1.102.4.0 and that may be the problem,so we tried to include it in our project and that still gave us the same error !.We requested to uninstall 1.102.4.0 from developer machines but client refuses to uninstall that its security fix and can not remove it ! Than we thought to upgrade the version of oracle.dataacess.dll to 2.102.4.0 and code started working but it started giving onther trouble..which is

Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when

  
We are migrating our application from windows server 2003 32 bit to windows server 2008 64bit, after I have created the virtual folder on the new machine, I am unable to connect to the database. We have oracle 11g client installed and below is the error which I am getting - </BR></BR> System.InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. ---> System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) at System.Data.Common.UnsafeNativeMethods.OCILobCopy2(IntPtr svchp, IntPtr errhp, IntPtr dst_locp, IntPtr src_locp, UInt64 amount, UInt64 dst_offset, UInt64 src_offset) at System.Data.OracleClient.OCI.DetermineClientVersion() --- End of inner exception stack trace </BR>Any help is greatly appreciated, I have tried couple of solutions going through some threads online but no luck.

Attempt to load Oracle client libraries threw BadImageFormatException from 64-bit machine.

  
We are receiving below error while connecting local ASP.NET site to Oracle server from 64-bit Win2k3 machine.  (System.InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException.  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. ---> System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)) One strange thing is that from same machine, if we connect through local SharePoint site, it connects well to oracle.  Please help...

How to connect to MOSS server using visual studio from client side

  
Dear All We are having one moss development environment and we are having many developers working on it.Since all the developers cannot work at a time,we are facing difficulties while developing sharepoint components. Is there any way to connect to sharepoint server from visual studio(from client side) so that we can compile our sharepoint components from client side and deploy later to the server? Any help on this would be much appreciated? Thanks Karthik S
Categories: 
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