VPN Access To Oracle Database?
Feb 18, 2010One customer is asking me if it is possible to access an Oracle database from his .NET website using VPN. I googled around and didn't find much on this subject.
View 4 RepliesOne customer is asking me if it is possible to access an Oracle database from his .NET website using VPN. I googled around and didn't find much on this subject.
View 4 RepliesWe are building an ASP.NET application with C#.net language and Oracle 9i database. Here we installed Oracle 9i client software on our PCs.We never worked on Oracle 9i database. It's the first time.We are planning to build stored procedures in Oracle database and call them from our ASP.NET application. Does working with Oracle stored procedures and ASP.NET is similar to that of working with MS SQL Server stored procedures and ASP.NET?
View 1 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 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 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 RepliesIs there anything missing in IIS 6.0 that prevents me from (Insert into table) using MS-Access?
Explain: The application works fine under Visual Studio 2008 IDE the insert into table works fine with no error, Also I tested with hosting provider and works fine with no problem. but now I have published the same exact app in a dedicated server windows 2003 with
IIS 6.0 .NET framework 2.0 with latest service pack I gave IIS_WPG write/modify access to the folder where MS-Access database is located and database but at the time of insert an error pop-up. I need to install in the Server or settings in the IIS to recognize my MS-Access db is it some office runtime that I am missing. (BTW I am using OLEDB connection string in my C# )
Using System.Data.OleDb;
I can retrieve data off of it with no problem but when I try to insert is when it fails I thought the problem was Access Rights but I do not think is the case.
I m working on A Ware house management Software.
I have used oracle in back end. I have goodsmaster table, sales return table, sales table, invoice table,etc
So i have to update qty on stock when i enter any entry in my sales return page of asp.net from goods master table..
I 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 visual studio 2005, asp.net c#.
i want to store the uploaded files to database.
if possible tell me how to get the file properties of the uploaded files such as file name, file created date and file extension.
i am using oracle database. visual studio 2005,asp.net c#. i want to upload the images to oracle database. I need help for creating the Database table also (i know to create database table, but i don't know abt creating image table (blob or clob));
View 2 RepliesI have two tables Users (Userid, Name, PhoneNumber) Applications (ApplicationsId,UserId, ApplicationName, ActiveDate)
Every user will have more than 1 application.
In Nhibernate using lazy loading I can get the users data along with all the applications for every user. So, I used to do something like user.applications[i].Applicationname to get all the applications.
But, Now how do i retrieve all the applications along with the users data using oracle commands. I know how to get one application using joins. But, how do i retrieve multiple applications and store it in a IList.
how i can use Oracle database with asp.net mvc 2 web application?
View 3 RepliesHow to intregrate an oracle database with an asp.net web application?... Any good tutorial to start with?
View 1 RepliesI 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 am inserting a record into oracle database using vb.net,there is a password field by using md5 i am generating it and taking tht value as string(ex: "16D78A6B10D631C8C86397C35A3CCD57") now my requirement is i should insert it into database(oracle) & in database that field is "RAW" how to do this?and the error msg is
Type of value has a mismatch with column typeCouldn't store in Col_Pass Column. Expected type is Byte[].
i hv been trying to perform insert operation on Oracle 10G database using asp.net 3.5. So far i m new to oracle and i m confused as back end queries seems different froms sql server. this code is in submit button click event:-
[code]....
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'm a little confused as to what is causing the following error is a very simple application: System.ArgumentException: An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB The code-behind has this:
OleDbConnection conn = new
OleDbConnection(ConfigurationManager.ConnectionStrings["db_conn_qa"].ConnectionString);
In the Web.Config, the following is present (note the Provider is clearly there):
<configuration>
<appSettings/>
<connectionStrings>
<add name="db_conn_qa" connectionString="Data Source=xx;Persist Security Info=True;User ID=xx;Password=xx;Unicode=True"
providerName="System.Data.OracleClient" />
</connectionStrings>
<system.web>
...
I am building an object from multiple datasources. Does anyone know whether this is possible in NHibernate and how. I should mention that one source is SQL the other ORACLE.
View 1 RepliesI have an application, which connects to a Oracle 10g R2 database, but what it is doing is opening lots and lots of connections and is not disposing them.
My application is using the MVC model, and I have Database Connection Class, which on unload of the page calls my dispose method, which consists the dispose and close commands. Further, on model control, on each of methods requesting data from the database, I am calling the close method on Oracle Data Reader.
am trying to insert images into oracle database using c#.net.but am getting error "ORA-01465: invalid hex number".Here is the code.
if (FUcontrol.HasFile)
We have a site that is runnig II7 64 bit with the oracle .net 64 bit provider, when I try and open this in web developer 2010 express (I'm running windows 7 pro 64bit) it says it can't load the oracle dll as its an incorrect format. I got the impress that web developer 2010 was 64bit capable.
Ofcourse this is extremly annoying as I don't get any syntax formatting for the project or intellisense.
I am currently in the process of doing a feasibility study of using web parts in one of our company's intranet portal. The challenge that I am facing is that I would like to use the organization's existing oracle database as the personalization provider instead of aspnetdb sqlexpress database. I tried to looking for some sample code but we could not find any. In the MSDN, I found one article where it is using textfile as a provider, but this does not solve my purpose here. I am new to web parts. Request you to share with me some sample code to achieve this.
I am using Visual studio 2005 and Oracle 10g database.
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