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 RepliesHow 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 want to pick the date from the table(Oracle) & want to insert it into the another table. In Pic see,I am picking the date of the second row. I convert the date to the dd/MM/yyyy format
Code:
TxtHiddenCtrl .Text = DateTime.Parse(ds.Tables[0].Rows[0]["FROM_DATE"].ToString()).ToString("dd/MM/yyyy");
Code:
?TxtHiddenCtrl.Text
"05/10/2001"
If I dont convert the date then
Code:
TxtHiddenCtrl.Text =ds.Tables[0].Rows[0]["FROM_DATE"].ToString()
"10/5/2001 12:00:00 AM"
I convert the date!
Now when i save the date into another table
Code:
cmd.Parameters.Add("@p_FROM_DATE", TxtHiddenCtrl .Text );
Error is dere not a valid Month!Why the error is coming?Its a valid month?
I'm deploying a small ASP.NET (framework 3.5) application in a Windows Server Web 2008 32 bits, IIS 7. The applications needs connection to an Oracle DB in another Server, using the tradicional DataAdapter, Oracle Connection, etc.
Iīve installed correctly the Oracle Client in the server (the server is another serverīs client) and Iīve checked that this server has access to the server where the database is.
Even though my app isnīt able to connect to DataBase. The message says that Oracle components havenīt been found. It doesnīt find the OleDB Provider for Oracle or some dll.
ŋSomething I shluod know about permissions of the ASP.NEt users or something like this?
I have a form wilh couple of Drop downs and text boxes and a Data Grid View which displays data from Access Table. When I hit add button on the form, I can see the data being added to the Grid View. But when I close the form and open the Access Database File (.mdb), the respective table is empty. The Access Table is not being updated. Second time if I open the form, the Grid View is also empty.I am pasting my code here.
Public Class Home
Shared OleDbConnection As System.Data.OleDb.OleDbConnection
Shared ExpensesDataAdapter As System.Data.OleDb.OleDbDataAdapter [code]....
I am trying to insert values into oracle database using visual studio 2010 express edition. find the below code I used:
[Code]....
I am trying to insert data to Excel Document using OLEDB as follows:-
sql = "Insert into [MyFirstSheet$] (" + Title1 + "," +Title2 + "," + Title3 + ")
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"
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 using oracle 11g client and want to connect with asp.net?
How i can populate gridview with oracle 11g?
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
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 have used Ado.net entity framework...how to insert an image to a table and retrieve it an show it.
View 21 Replieshow i can insert image in SQL database?
View 8 Repliesi am newbie to asp.net.i am trying to make sign up kind of webform where user can submit his image. i have used fileupload control to take image from user.i want to insert that image into a database.how can i achieve this functionality?
i am new to asp.net development.
I have Oracle 10G express edition. I have configured it on windows 7 system. Now I want to make a 64 bit application using visual studio 2010 and connect to oracle 10 g server. If I run my application in VS2010 explecitly in 86 mode then I am connected to database but I want it to happen for 64 bit
View 2 Replies