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.
How 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.
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 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 RepliesI keep getting a
InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is closed.]
It is because my connection is closed. What is wrong with my connection string? Why won't it open.
[Code]....
how to connect to remote database(SQL server)using c#
View 2 RepliesWe have a database on our server, here at the office. We now want to create a asp.net website that will be accessible to the public.
Say the domain of the website is [URL] and it's hosted on a webserver of HeartInternet.
When someone connects to that domain, that webpage must be able to pull data from our server that is located here in our office.
In other words the webpage cannot just load data out of the MySQL database loaded on its server, but it has to connect to our server and get data.
I have amazon cloud aws, i am developing a website in asp, i have remote RDP access to my server..
So i have not installed postgreSQL etc.. but i am unable to connect to that database.. and when i install and run on my local system, it connect.
I have created web pages using VS Web Developer that use a local Developer Edition of SQL server database on my PC with LINQ to SQL. When I deploy my website to a remote web host SQL server, I need for my web pages to be able to use the remote database instead of the local database. So, how do I get the Server Explorer to connect with a remote SQL Server database?
View 6 RepliesI 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 am new to the asp.net, I am going to create a website which needs to talk to oracle database(i only need get the data only) which is in client place.
I want to know what do i need to do this (what are the requirements)
What i have is Client IP, DB name, Username and Password.
I have asp.net2005 on my system with sql server.
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 RepliesI'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 2 servers. the database server (DB1) which has sqlserver installed and the application server (WEB1) which has my web application. They are both on the same network and both have the same administrator login.
My web application on the application server needs to access the database on the database server. sqlserver is set to mixed mode in security. i created a random sqlserver user login that can only access my database and set it as the db owner. I use the username and password for this in my connection string. when i run my web application i can read information but i cant write to the database. My app is using windows thentication. I have set my NT AUTHORITYNETWORK SERVICE account to db_owner for my database as well... grabbing at straws!
Question 1: When my application talks to sqlserver does it use the administrator login or the NT AUTHORITYNETWORK SERVICE account which i got from using windowsidentity.getcurrent()?
Question 2: If I use ASP.Net impersonation, what does this do exactly? Because if i run the ndowsIdentity.GetCurrent() i get the username that i specified. How does this tie in with my connection string?
Question 3: If I dont use impersonation what and how do i have to configure sqlserver to accept my insert/update requests? Do i need to work with the NT AUTHORITYNETWORK SERVICE? or can i just use my user login? What do i need to add or remove from my connection string? (see below).
[code]....
I'm having problems trying to connect to a remote debugger for VS2008-SP1.I'm trying to debug an ASP.NET application on a Win2k8 VM. The host PC (WinXPsp3) running Visual Studio is connected to an AD domain, and is logged in with a domain account. The VM is not connected to the domain and is logged in with the local Administrator account.The VisualStudio remote debugger requires authentication in both directions, so I would normally add my domain account as a local admin on the VM and allow debug permissions for that user.Since the VM is not on the domain, I can't add my domain account as a local admin. What can I do to get remote debugging going between my PC and the VM?
View 3 RepliesIs it possible to connect to a Remote Desktop from my ASP.net application,If so can you guide me through it.
View 1 Replies
