Databases :: Fetching Data From Oracle Data Base In Application?
Jun 8, 2010
I am fetching data from oracle data base in asp.net application. To achieve this functionality i have used Oracle.DataAccess dll . In my developement enviorment it working fine.
But once I deployed this code on IIS 6.0 it is stopped working and I checked my log and found connection not get established . Then I make sure Oracle.DataAccess.dll present in to bin folder also I try to put this dll in side GAC, but still my code is not working on deployed server.
View 1 Replies
Similar Messages:
Dec 28, 2010
I have two databases (DB1 & DB2) from which i wish to build a single table/gridview output, ideally i want to be able to sort the table by using any data.
However i cannot seem to figure out how to have more than one datasource per Gridview, and if i have more than one Gridviews then i can't sort all the data by any of the columns.
This is a oneway street, i do not want to update the databases from the webfront end.
Here is a Trimmed Down Version of what i have
[code]....
View 5 Replies
Sep 24, 2010
I am trying to fetching the data from Book1.xlsx file. The program is not working and throws an exception. check the code and tell me where I am doing the mistake?
[Code]....
The exception is:
An error: The Microsoft Office Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.
View 5 Replies
Feb 21, 2011
I am developing a web application with back end as Oracle. I call the procedures from web application when ever some update, create or delete for the records needs to be performed. How to maintain the connection in these scenarios.
Can I open the connection and maintain it through out the application till user logs out?
View 10 Replies
Mar 16, 2010
Is the "asp.net - oracle" a good solution for web applications?
View 6 Replies
Oct 2, 2010
how i can use Oracle database with asp.net mvc 2 web application?
View 3 Replies
Aug 27, 2010
Ours is a Asp.net web application. Database is Oracle. Its an Internet Application.
Database will be in one location and Web application in another. Data from Oracle to Web application will be passed over Internet.
We are using EnterpriseLibrary. And provider is System.Data.OracleClient.
We need a provider which encrypts the data while passing data over internet.
Do we need to go for some third party Providers or ODBC ?
View 1 Replies
Mar 15, 2011
have a sp in oracle which has 3 input parameters and 3 output parameters( 1 ref cursor, i number, 1 varchar2)
Command.CommandText = sp name;
Command.CommandType =
CommandType.StoredProcedure;
i am doing cmd.ExecuteNonQuery();I am able to get the number and varchar2 values from output parameters. But i am unable to get output from Ref Cursor. (How can i get this...)If i use dataadaptor then i am getting the datatable in the dataset(but i am not getting the other two parameters(where will get the other two??)...
View 2 Replies
Dec 3, 2010
I am developing an web application using csharp and oracle as database. I have table with columns like below. How can I ensure that sql selects from one table column but it shows two columns depending weather it is Debit or credit. How can I come up with something Statement of Account ?
Number Amount Type
2 6000 Dr
3 4500 Cr
4 2300 Dr
5 1200 Dr
6 1300 Cr
Now I want the sql out put to be as below. How can I achieve?
NUMBER Dr CR Balance
2 6000 1000
3 4500 5500
4 2300 3200
5 1200 2000
6 1300 3300
View 4 Replies
Mar 28, 2011
I wanted the step by step connection details of connecting Oracle 10g express edition to a ASP.net MVC application.
Please let me know .. if at all I have to install any dlls for the same and what are the pre-requisites for the same.
View 1 Replies
Apr 20, 2010
my data base is oracle and i'm fetching simple data id, desc from table into a data set. But i'm getting only id and my desc field is showing blank.
my table is like this id number, desc nvarchar2(100)
View 1 Replies
Jan 20, 2011
I'm using ASP.NET C# with the v3.5 framework, and need to grab data from the session and insert it into an Oracle database. I can connect to the database and manually insert data from a couple of controls I created. However, I have an application with multiple forms that stores data in the session as the user navigates between the forms. The form information is stored in DataTables, with a separate DataTable for each form. I have an idea of how to retrieve the data, but was wondering if I have to code queries to map each field in the database to the fields in the forms? Or is there a way to "give" the database the information from the DataTable and have it insert each of the values?
View 5 Replies
Dec 1, 2010
I want to do a bulk data transfer from Oracle 10.2G into CSV or Excel sheet.I would either want that an entire table's data be populated into EXcel/CSV or the result of a select query be so populated.
1)Is there any stored procedure or function that can do this?
I know of a function in postgres which does this kind of a thing.There could be something similar.The second thing is the reverse of it.I want to transfer the contents of a CSV file into a oracle table after truncating it.
2) What sp or function is available for that?
View 2 Replies
Jul 27, 2010
I want to know the best way to transfer data from a view in Oracle database 10g to Sql Server 2008.
View 1 Replies
Feb 4, 2011
am in deep trouble with retriving the data from oracle database. Please HELP ! In one line: "When i retrive the data from oracle database, it's truncate the data if it is more than 4 kb"I have oracle proc param as below:
PROCEDURE p_GetData (
ivar_id IN id_n%TYPE,
oclb_owners OUT CLOB,
onum_sqlcode OUT NUMBER,
[code]...
View 8 Replies
Jul 23, 2010
As I am working on Employee Management system, I have two table (for example) in database as given below.
EmployeeMaster (DB table structure)
EmployeeID (PK) | EmployeeName | City
MonthMaster (DB table structure)
Month | Year | EmployeeID (FK) | PrenentDays | BasicSalary
Now my question is, I want to store data in file system rather than storing data in SQL or ORACLE.
I want my data in file system storage for Insert, Edit and Delete opration with keeping relation with objects too.
I am a C# developer, Could anybody have thoughts or idea on it. (To store data in file system with keeping relations between them)
View 1 Replies
Feb 10, 2010
I`m extremely newbie to asp.net and oracle but i need to make a very simple project where asp.net inserts/updates data is oracle db. A managed to the connections, everything, made a DetailView of the DB data on the page, enabled in the Advanced SQL Generation Options the "Generate INSERT, DELETE and UPDATE statesments". Here is the code:
[Code]....
But unfortunately this does not work! I get the following error:
[Code]....
Oracle gives me creeps with these invalid characters and dates.
View 3 Replies
Aug 11, 2010
I need to fetch the data from a table with Alias name in oracle.
example: select f1 'Field Name1',f2 'Field Name2' from sometablename;
View 2 Replies
Jul 20, 2010
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.
View 3 Replies
Oct 11, 2010
MySqlCommand cmd4 = new MySqlCommand("select emp_name from employee_details where emp_category='" + cat[j] + "' and no_ofcassigned=(select MIN(no_ofcassigned) from employee_details)", AL.con);
MySqlDataReader reader2 = cmd4.ExecuteReader();
string emp=null;
while (reader2.Read())
{
emp = reader2[0].ToString();
}
reader2.Close();
i am using the above code to fetch the employee name from the datatable according to the minimum value in the column 'no_ofcassigned' in specific category but here if i have more than 3 employees with the same no_ofcassigned is there then the query is not
View 1 Replies
Feb 26, 2011
I am creating a web application that will be running on an infrastructure which will utilise a number of web servers, web gardens and a load balancer.
As the application is using Sessions, and that our application is using Oracle as the database, we would like to use the database to save the Session data. However, I am struggling to find any good examples on how to do this with Oracle.
I note that Oracle provides the following class: Oracle.Web.SessionState.OracleSessionStateStore, but I am unsure what I need to do in the Code Behind and what if any tables do I need to create in the database.
View 2 Replies
Nov 10, 2010
I need to develop an application, which will get records (orders) from one application and process them. The updates to this records (order updates) will be sent back to the source application for end customer reference. I'm planning to achieve this data synchronization at the database level using triggers and stored procedures to insert database between the 2 databases.
But, the issue is I have to deploy this application in 3 different customer sites and I have to change the database names (cannot use the same database name) in each deployment manually. Because of this deployment issue, I was thinking of handling this within the asp.net application where I can store the db name in the database and then build the query within the application, but I dont want to do it as building queries like that doesnt look very professional.
View 2 Replies
Jan 28, 2010
I want to use MYSQL database for accesssing the data in a mvc application. The connection string that i am using in web.config is:
<add name="ConnectionString" connectionString="server=localhost;user id=root;Password=abcd;database=database" providerName="MySql.Data.MySqlClient"/>
Then I have prepared a model,controller,view for accessing and displaying the data. I am using LINQ o get the data from database but getting the exception:" 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)" I have also installed the MYSQL connector. provide me the solution to access the data using MYSQL and LINQ in MVC application
View 2 Replies
Feb 27, 2010
I have a gridview which is present inside a repeater. I have been successful in displaying the data inside the grid view. Now I want to fetch data from the gridview. But i have not been able to fetch the data from the grid view.
View 5 Replies
Nov 21, 2010
is there any (foc) way to import data from excel files into my application? I'm using ms visual developer express edition 2008.
View 6 Replies