Databases :: Connect Oracle Using Microsoft Visual Web Developer?
Dec 20, 2010
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 ?
View 6 Replies
Similar Messages:
Jan 28, 2010
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 Replies
Jul 30, 2010
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.
View 1 Replies
Mar 11, 2011
Can I install Microsoft Visual Studio 2010 Service Pack 1 in Microsoft Visual Web Developer 2010 Express?
View 1 Replies
Oct 4, 2010
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 Replies
Jul 8, 2010
Is 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();
}
View 1 Replies
Mar 8, 2011
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....
View 6 Replies
Feb 10, 2011
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 Replies
May 18, 2010
I 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
View 5 Replies
Jan 31, 2011
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
View 7 Replies
Jul 8, 2010
Microsoft Visual Web Developer 2008 Express Edition not possible to open Visual Studio?
[Code]....
View 4 Replies
Mar 15, 2010
I currently doing a website that require to have a report for higher management, but i cant seem to have the crystal report tool in my MS Visual Web Developer.
View 2 Replies
Jul 22, 2010
I need to connect to a third-party hosted database. The VPN tunnel is already set up and an IP address has been provided to me, but I'm not sure how to access the database through the tool.
I have tried the Database Solutions tab > Data Connections > and the one listed under this is called "ASPNETD8.MDF", but when I click on this, I get this error message:
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
View 1 Replies
Sep 7, 2010
i got microsoft visual web developer and do not understand what a class is would.
View 6 Replies
Feb 19, 2011
I have a 'Connection.cs' file in the App_Code folder of Microsoft Visual Web Developer 2010, but it alerts me of an error:
The type or namespace name
'Connection' could not be found (are
you missing a using directive or an
assembly reference?)
('Connection' is the name of a class in the Connection.cs file)
[Code]....
View 1 Replies
Feb 26, 2010
I want to know how do I use outer joiin with microsoft visual web developer 2008.
I am using an access database. There are two table in the table t1 and t2.
I want to list the items in both table that have the same id.
my query is as follows:
select t1.id, t1.date, t1.count, t2.date, t2.count from t1 outer join t2 on t1.id=t2.id;
I am completely depressed ... I have been trying this for more than 200hrs.
View 23 Replies
Jan 4, 2010
how to connect ASP to MySQL database. I have already install MySQL in my localhost, Add a connection through Data Source (ODBC) in ctrl panel and test connection succeed. Now I want to show the query on my default.aspx page so that I can do the insert / update / delete my table data in MySQL.
View 1 Replies
Aug 5, 2010
In Microsoft Visual Web Developer 2010 Express, Edit->Quick Find mean item, the "Quick Find" item, everytime I have to select "Find In Files" again, how can I set "Find In Files" as default?
View 3 Replies
Mar 13, 2010
I'm a new.
View 2 Replies
Nov 1, 2010
I'm working on a project based on Microsoft Visual Developer 2008 Express Edition, involving web pages and database. I would like to know how I can go live? Can I download the express edition for free? Or is there any runtime program that I can use without having to pay?
View 6 Replies
Sep 11, 2010
i have created a login.aspx file in visual web developer .now i want to connect the username and password details to SQL database
View 1 Replies
Feb 25, 2011
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
Mar 16, 2011
I have a project to build statistical reports. i am told to use crystal reports if its a license free, If it is not than user some other free source.
This is my first attempt to use reports in asp.net. Can anyone guide me how to start with e.g if i am using crystal reports than how do i add a crystal report control in my toolbox(Microsoft Visual Developer Express Edition 2008).
Please help me to understand how reports work.Any good tutorials,from scratch would be very helpful.
View 1 Replies
Jun 15, 2010
I'm using an ODBC connection to connect a SQL 2005 database to my ASP.NET app in Visual Web Developer Express. I'm finding that the expected functionality that tutorials review does not work for ODBC connected databases the same way as it does for SQL databases created in the Web Developer. For example, I can't use stored procedures because the option to create one is disabled in the Web Developer, and if I create the stored procedure in SQL Server Management Studio Express, it doesn't show up in Web Developer because Web Developer only finds the system stored procedures, not the user-defined ones. I've seen other cases as well where database management options in Web Developer don't work with ODBC databases.
Am I missing something in my setup, or is there an inherent limitation with ODBC connected databases? Or, is this a limitation with using the Express versions of these development tools?
View 2 Replies
Apr 28, 2010
I have Download "VWD_RV_Addon_enu" which is reportviewer setup when I double click it displays Below information
This add-on requires Microsoft Visual Web Developer 2008 Express Edition Service Pack 1. Upgrade to Service Pack 1 and try again.
where can I get Service Pack 1.?
View 1 Replies