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 Replies
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 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
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..
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?
When installing an instance of SQL Server, to make sure that any Web Application that has user rights to access the database can make a connection to it, what user must be used for service accoiunts, provisioning, etc.
I always use the "NT Authority Network Service" for my service accounts, and then use "mixed mode" and enable "administrators" for provisioning. Doing it this time, for some reason I can't get access to my SQL Server databases without turning off the firewall completely even though I have the correct ports opened up.
I know that I used mixed mode, but the only thing I can think of is that I chose a different user for the service accounts.
Getting 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 want to read write excel file in my application without installing the office on my server. Means my server don't have any excel (MS office) installation. Is it necessory to install the office on server to excute the program of read or write the excel file.
View 5 Replies I've developed a web app in Visual Studio 2008 using ASP.NET which connects to an Oracle database and a separate SQL Server 2005 database in the same application.
I want to convert this application to use SQL Server only. I have copied the Oracle tables that I need to SQL Server and am in the process of converting the SQL queries from Oracle format to SQL Server format.
I have also modified all the Connection Strings in web.config to point to the SQL Server database now and not the Oracle one.
However I have come across a problem. The TableAdapters are configured to use the OracleClient in the declarations code behind the scenes, i.e. it is "hard coded". But this causes problems of course while modifying/saving queries, because I don't want any trace of Oracle in my new web app.
The only thing I can think of is to delete all my TableAdapters and re-create them all.
I need to transfer SQL Server databse to Oracle database.
View 2 RepliesDoes anyone know of a way that I could sync a few contact info views from an OracleDB to SQL Server without spending thousands on syncing software?
View 1 RepliesI have to automate one database process in .Net web applicaiton which uses Oracle 11g Database as Backend.
I need to know two things:
(1) How to check space on Oracle database server? I need space on server and not in the Database itself. My process creates few tables so I want to make sure that we have sufficient space before the process starts.
(2) Also I need to create script to backup Indexes and Triggers on the table so that I can recreate them after data transfer process is completed. Any idea how to create script form c# code?
I would like to monitor all the queries running under Oracle which are being fired. Looking for some good UI tool for Oracle similar to Microsoft SQL Server Profiler.
View 1 RepliesI want to know the best way to transfer data from a view in Oracle database 10g to Sql Server 2008.
View 1 RepliesUsing 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 starting a new project where I have to use oracle and asp.net. Oracle 11 enterprise edition. Problem is oracle database reside in linux server and application server is in windows. My question is1. Is there any problem connecting oracle from asp.net?
View 1 Repliespage1.aspx
<input type="text" runat=server id="text1"/>
page2.apx
protected void btnCreateMember_Click(object sender, EventArgs e)
{
text1.text="test";
}
How can I change Input on Page1.aspx through Page2.aspx Method btnCreateMember_Click
Is there anything special to do with Windows 2008 R2 Server and Visual Studio 2010 to get Oracle quereis to work? I have the same DB Connnection.string I have used before and it works. I am at a loss here.
View 6 RepliesI'm working with Oracle database and I want to improve performance of my website.I read about caching. So is it possible to implement caching (SQL Server Database Dependency) with oracle?
View 2 RepliesI am a biggner in SQL DB . but i started a complicated and painfull work in SQL SERVER 2008. the problem convert Oracle hierarchical query to SQL query. the query
SELECT DISTINCT
LEVEL LVL,
SCH.NSCHEDULE_SL,
SCH.NSCHEDULE_SL_FM,
SCH.CSHED_CNAME
FROM FA_SCHEDULES SCH
WHERE LEVEL = 1
AND NSCHEDULE_SL_FM IS NULL
AND NBRANCH_SL = 2
CONNECT BY PRIOR SCH.NSCHEDULE_SL_FM = SCH.NSCHEDULE_SL
AND NBRANCH_SL = 2
I don't know why I did have the following problem with this. USE [myschema]; select acc,acc_name from ORA_sys2..oraschema.acc_table; Msg 7314, Level 16, State 1, Line 3 The OLE DB provider "OraOLEDB.Oracle" for linked server "ORA_sys2" does not contain the table ""oraschema"."acc_table"". The table either does not exist or the current user does not have permissions on that table. But within the SP, I did make use of the following way without any problem! from ORA_sys2..oraschema.tab2
View 2 Replieshow we can use oracle 10g in asp.net 3.5 using toad
View 1 RepliesAs the title says I have a Win 7 64 bit dev machine, Win 2K3 32 bit production box and I run against Oracle 10g which Oracle clients do I need to run? Do I need to run the Oracle 32 and 64 bit clients? And if so what versions?
View 1 RepliesI 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 Replies
