I'm getting ready to do a new project and I want to use MVC and WCF, though the backend database is Oracle. Everything I'm seeing is using it against SQL 05 or 08 (mostly 08). So my question is,can I use MVC and WCF to go against an Oracle data?
View 2 RepliesWe 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 new to ASP.NET and Oracle. I was looking for a book that will provide step by step guide to develop asp.net applications with oracle database.
View 3 RepliesI'd like to know if there are any good EF providers for Oracle out there, and more specifically what experiences people have had with them. We're looking for a provider that is either free or paid for, but I'm struggling a bit with finding any real opinions on what the different frameworks are like to work with in a production environment.
EDIT,I should clarify that we are using Oracle 11g.
I am working on NHibernate with oracle in ASP.Net. Now i am trying TDD(Test Driven Development). Can you tell me the best way to develop the TDD for NHibernate with oracle?I am using MbUnit with microdesk but it is not better approach for oracle but SQL server.
View 1 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 RepliesI have a query with a where clause that looks like:
WHERE field IN ( 1, 2, 3 )
Is possible to parametrize this so it looks something like:
WHERE field in ( :list )?
How do you create the :list parameter, assuming it's a list of ints, that could be anywhere from 1 to 10 ints?ASP.net, webforms if that makes a difference.
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"
how we can use oracle 10g in asp.net 3.5 using toad
View 1 Replieshow to create model using oracle 10g
View 5 RepliesAs the title says I have a Win 7 64 bit dev machine, Win 2K3 32 bit production box and I run against Oracle 10g which Oracle clients do I need to run? Do I need to run the Oracle 32 and 64 bit clients? And if so what versions?
View 1 RepliesI 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 RepliesIn my project, I have a database in SQL which was working fine. But now I have to make the application support oracle db too.
Some limitations I found out was that in Oracle, there is no bit field and the table name cannot be greater than 30 char. Is there any other limitation that I need to keep in mind.
I have an Asp.net web application targeting .Net2.0 and my databse is oracle, I used SqlDataSource Control to communicate with oracle database its working fine on my development server, but on my production Oracle is 64 bit so im getting an error like
"<asp:ControlParameter doesnot have a property DbType="Int32"> "
i tried with Int64 also but still im getting the same error
following is the markup of sqldatasource i used
<
asp:SqlDataSource
ID="sdsEmployees"
runat="server"
ConnectionString="User Id=user;pwd=user1;server=prod" ProviderName="System.Data.OracleClient"
SelectCommand="GetEmployeeInfo" SelectCommandType="StoredProcedure"
OnSelecting="sdsEmployees_OnSelecting">
<SelectParameters> <asp:ControlParameter
ControlID="txtNumber"
DbType="Int32"
/> </SelectParameters> </asp:SqlDataSource>
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 Repliestried to use linq to oracle 10g express but it throws an error as I can make no errors because I throw
View 1 Replieshave 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??)...
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();
}
Let me start with the fact that I am fairly new to ASP.net. I have a very well estabilished Oracle database. I am working on an ASP page that will connect to the database and return the data. Nothing special there. I start having problems when trying to establish the security. All users that will be defined in my ASP page already have an Oracle login. This login has quite a lot of security already built into it. For instance a user can only see orders that would belong to their company, and inside that they may only be able to see products that they have access to. All of this secuirty is built in another application, and applied to our Oracle tables. I was thinking that maybe I could just ask them for their login information to Oracle, then validate that the account is active. Store that info in a session variable (I think that is right term), then when they request data login using their information. I have read a couple of posts that say this is not the way you should do it, and that every user should have their own ASP login and 1 generic login to go to Oracle. Can anyone give me pro's and con's of doing it either way. Also if the best way is to get the users into ASP, then what is the best way to make sure the 2 systems stay inline with as little manual effort as possible. For instance a person may move withing a company. How do I keep from having to change that secuirty in the Oracle side and the ASP side?
View 13 RepliesCan I use oracle 9i or 11g database with Entity Framework?
View 1 RepliesWe have been really tired lately dealing with all bugs that comes out of ODP.Net and the lag time to bring out any new product out. I am looking for ado.net provider for oracle and looking for the following:
1. Entity Framework
2. Linq
3. Good support (in case we run into issues)
4. Quick response to open issues
5. Quick updates and new releases
I looked at datadirect and dotConnect by DevArt...But I am not sure if any one is better than other.
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 a SQL Query. It works fine in Sql server. let me know how to make it work in Oracle.
You can run below code in Sql server and check. It will work fine. But in Oracle,( I am using TOAD for Oracle )it is giving some errors.
Code]....
I have created an SSIS package to fetch the details from an Oracle database and import the details in to SQL servers table. In development region the client provided the connection description for oracle server as shown below: Using the above string
I have selected Microsoft OLE DB provider for Oracle and gave xxxxx:1543/AU1D as server name and provided the username and password. It got connected successfully. (DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx.abc.XYZ.com)(PORT = 1543))
)(CONNECT_DATA = (SERVER=dedicated) (SID=AU1D) )) For Prod environment the Oracle servers connection description is: C10P =(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = yyyyy.abc.XYZ.com)(PORT = 1524)) (ADDRESS = (PROTOCOL = TCP)(HOST = zzzzz.abc.XYZ.com)(PORT
= 1524)) (ADDRESS = (PROTOCOL = TCP)(HOST = vvvvv.abc.XYZ.com)(PORT = 1524)) (LOAD_BALANCE = yes)(CONNECT_DATA =(SERVICE_NAME = C10P. abc. XYZ.com)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)))) Now I don't have the SID to use in the connection.
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.