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
[Code]....
but i get the following exception
The type initializer for "Oracle.DataAccess.Client.OracleConnection" threw an exception
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?
I can't connect to both 9i and 10g from asp.net,when i installed 9i client in a machine which already contain 10g xpress edition and no 10g client 9i client used to connect 9i db in another machine. Both 9i and 10g can be connected with TOAD. i got the following error msg from the asp.net application. System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
View 3 RepliesI have a vs2008 Website project(it was converted from vs2005), when i right click the Website node in the solution and open the property page, i select the references link, then click add reference to Oracle.DataAccess.dll(11g, 64bits), Version=2.112.2.0 in the website BIN directory, it doesn't work, i don't see the Oracle.DataAccess.dll is added, Can you give me any advice why the website project can not add the Oracle.DataAccess.dll ? And I can add rOracle.DataAccess.dll to my other Web Application project, what difference between Website project and Web applicatoin project caused the issue? Since i can not add the Oracle.DataAccess.dll , when i compile, it gave the error:
Could not load file or assembly 'Oracle.DataAccess, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. An attempt was made to load a program with an incorrect format.
In development I installed "ODAC Entity Framework and LINQ Beta (11.2.0.2.30)" so that we could have a 32 bit version of Oracle.DataAccess for ODP.Net. In Visual Studio 2010 (on Windows Server 2008 R2) I made a reference to:
C:Oracleodp.netin4Oracle.DataAccess.dll.This adds: <add assembly="Oracle.DataAccess, Version=4.112.2.30, Culture=neutral, PublicKeyToken=89B483F429C47342" /> to the assembly in the web.config.
We set the AppPool to Enable 32 bit applications and everything works great. For anyone who doesn't know the story here, we do this because Visual Studio 2010 runs in 32 bit so you need the 32 bit ODAC/ODP.net components to get a development environment running. I then publish the files and move to a 64 bit machine.
I downloaded the "ODAC112021Xcopy_x64.zip" Then ran: install.bat odp.net4 c:oracle odac and I can see the Oracle.DataAccess.dll file at: C:Oracleodp.netin4Oracle.DataAccess.dll. Then added c:oracle;c:oraclein;c:oraclein4 to the System Path.
At this point I would think I just replace the version and PulbicKeyToken in: <add assembly="Oracle.DataAccess, Version=4.112.2.30, Culture=neutral, PublicKeyToken=89B483F429C47342" />
on production to the versioin installed on prod. So first thing I do is just remove that line on production to see what error I will get. And I still get the same error:
System.IO.FileLoadException: Could not load file or assembly 'Oracle.DataAccess, Version=4.112.2.30, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
Actually this is if I move the new dll into the applicaitons bin directory. If I remove the dll from the directory I get: Could not load file or assembly 'Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
So I put the line back in.
I right click on on the new Oracle.DataAccess.dll and click properties. In the details tab I see verion is 4.112.2.0. That makes sense. The 64 bit XCopy version is an earlier build then the 32 bit Beta that comes with Entity Framework and LINQ(Version=4.112.2.30).
So on production I change the Version attribute to: 4.112.2.0. But now I get the same error: System.IO.FileLoadException: Could not load file or assembly 'Oracle.DataAccess, Version=4.112.2.30, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
(This is with the new dll back in the web app's bin directory as is the rest of the thread).
It's still looking for the same version of the assembly. Why is it doing that? The web.config has a connection string with the ODP.Net provider type (Oracle.DataAccess.Client). Which would take from the assembly reference. It should not care what the version number is. Could there be something in code somewhere that is specifically looking for the old dev box version? Just what is the way to make it use the new assembly?
I would think the system would just know where to find the new dll. Just as in development the add reference dialog knew that the dll was in c:oracle... rather then c:program files(x86)... like out-of-the-box Microsoft assemblies.
I have a vs2008 web application. it built fine and it was runing fine use visual studio development server, but when i use IIS web server, it gave me the following error.
Server Error in '/Vendorapplication' Application.
I need to find a way to connect to the remote Oracle server without a DSN. There are some practical problem for accessing the server using a DSN. I need a way to connect to Oracle server like I connect to SQL Server etc. For example, in SQL server, I can connect directly with server using Servername (IP adress) + Username + Password + DB Name. Any way to connect to the Oracle server like in SQL Server we do ??
View 6 RepliesIs required to install Oracle client software to connect Oracle DB?
As following code will generate exception, prompt:"System.Data.OracleClient requires Oracle client software version 8.1.7 or greater."
using System.Data.OracleClient;
string dataSource ="(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=addr)(PORT=pt))(CONNECT_DATA=(SERVICE_NAME=svc)))";
string connectionString=string.Format("Data Source={0};User Id={1};Password={2};",dataSource,"id","pwd");
using (OracleConnection connection=new OracleConnection(connectionString))
{
connection.Open();
}
I need to connect to oracle database (10g) which is on different server.
Can i use the latest ODP.net provider or i need to use ODP.net provider related to oracle 10g only?
After installing the ODP.Net what are the next steps to do in order to connect to database....
I am having an issue coinnecting to Oracle using the Oracle Database (OracleClient). I can connect to Oracle using other tools such as TOAD, POWERBUILDR, SQL PLUS but not Visual Studio. These other tools use the TNSNAMES.ORA file so that is not the problem. I can use use oledb and it connects ORACLE but not the ODP.Net.
View 1 RepliesHow to connect to a remote oracle database with Visual Studio?
I know how to create the connectionSting in web.config. I wonder if I can connect to an oracle database when creating a LINQ class so that tables will show in the Server Explorer.
I'd like to connect my Oracle Server Database 11g (in another machine) with the default project of Microsoft Visual Web Developer 2010.
I did :
Start A new Project : ASP.NET Web Application
The design fit very well with my simple needs, so i've modified the css file and some apsx for my project, and i'm trying tu use Oracle instead of SQL-Server
I've downladed ODTwithODAC112012 from the Oracle website, and installed it. First problem i thought that it will recognize Visual Web Developer as a Visual Studio solution, but it doesn't ! so in the Project/Add Class i haven't Oracle.DataAccess
In fact i just want to use the authentification from Oracle to log my user, using my tnsnames.
What i should i do to get it, or do i need to use another way ?
In the Web.config file there's a lots of definition like "provider", that i don't know how to use !! is there a typical way to do with oracle ?
Using VS 2008 and oracle 10g.
I have installed oracle odp.net (11.1.0.7.20). This client installation includes all VS developer tools.
All my application seems to be working ok. I have never attempted to use VS Server Explorer.
For ReportViewer I was trying to create a dataset and in the server explorer I was trying to create a new dataconnection for oracle. As soon as I click new connection I get the following error.
An unexpected error occured in Oracle Data Net provider for .NET. contact the provider vendor to resolve this problem.
Also I am unable to add a server to the server explorer. When I enter the IP address of
oracle DB Server, it gives the following error.
An error occured while connecting to 999.99.99.999
I am using oracle 11g client and want to connect with asp.net?
How i can populate gridview with oracle 11g?
In my asp.net application im using Oracle client. In the connection string, we specify the 3 basic attributes: data source, User Id, and Password. We are using connection pooling. Our data resides in 2 different Oracle schemas. Most of the requests are for data from both Schema1 and Schema2.
Is it possible that the connections are implicitly tied to a schema1 or schema2?
I am having the error stated above. The stack trace is as follows:
[Code]....
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.0bit
.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(); [code]....
I have checked all forums and posts regarding this error. They mention that there are 2 versions of Oracle.DataAccess.Client on the server, I only have 1 version. This runs on VS2010, but when I publish the website the error above shows up. I checked my Oracle connection from the installer and connection test passed. I tried uninstalling Oracle and reinstall, but still the same. The query above I tried changing to 'select region_code, reg_rom, ...', still the same error..
I want to access oracle database which is on diffrent server my application is giving error in connection string that is object ref not set
View 1 RepliesGetting the following error when browsing .net 2.0 application System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
I have setup a .net 2.0 application with oracle backend on windows server 2008 R2. I have oracle client 11g installed on the server for the application to talk to the oracle database. This worked well when the .net 2.0 application was hosted on windows server 2003 and oracle client 10g. But when it is hosted on server 2008 with new oracle client it is giving the above error when browsing the page. This error occurs when the connection is opened inside the c# code.
I have a MySQL data at a web hotel. I can connect to the database from my web application hosted at the hotel . But trying to connect from a client application running on my PC fails using the same ConnetionString. The error is: Unable to connect to any of the specified MySQL hosts
In fact the method below (the method is protected in the web application) fails in my client application but works in my web application.
[code]....
I just tried to download WorkBench 5.2 and HeidiSQL, both connects to the database from my PC when supplying server and password information.
I would like to connect oracle via ODBC. I downloaded the dll and add as reference.
Here is the sample code:
Dim cn As OdbcConnectioncn = New OdbcConnection("PROVIDER=MSDAORA; DATA SOURCE=aaa; USER ID=aaa; PW=aaa;")
But getting this error "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
How do I connect to an Oracle 11g database using asp.net3.5? what is the name space and how to write connection string in web.config file?
View 1 RepliesI have Oracle (10g Express Edition) installed on one pc.
Visual Studio 2008 SP1 is installed on another pc.
I want to run an ASP.NET web app that uses the remote database. The two PCs are connected by a LAN (wired) connection. How can I connect to the database? What will the connection string be? The operating system on both PCs is Windows XP.
I need to connect to oracle database (10g) which is on differenet server.
Can i use the latest ODP.net provider or i need to use ODP.net provider related to oracle 10g only? After installing the ODP.Net what are the next steps to do in order to connect to database. This is totally new to me (connecting to oracle... i have worked with sql databases till now...)
I have two PC. In one pc(PC1) i have installed oracle express edition 10g (10.2.0.0 as far as i know). And in another(PC2) i have installed visual studio 2008 sp1. In PC2 the ASP.Net application is running. But i can not connect to the oracle database to PC1. PC1 and PC2 are connected by LAN(TCP/IP {Actually they are connected by wire and given two IP} ) But it was working perfectly while both ASP.net application and database were in the samae PC. ca
the NHibernate configuration file is:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
<session-factory> [code].....
i am using oledb to connect with oracle from asp.net. i am inserting image into my database.i could insert large and samll image into database. but i couldn't update large image with small image. ie if i insert small image(50kb)and if i want to update small image with large image(200kb) it is not updating.it updates with null value. i don't know why.
View 6 Replies