Databases :: Oracle Connection String?
Jan 7, 2010In the Web.Config
[code]...
In the Web.Config
[code]...
I am connecting to Oracle database from .net using OLEDB.
My Connection string :
[Code]....
I am using above ConnectionString to communicate with database. To make it work, I have to store password (don't want to do that) in session and use it every time I need to talk to db.
1) Is there any other connection string without username and password with oledb?
2) I use "Integrated Security" for MSSQL. How can I use the same with OLEDB - Oracle database?
string sConnectionString = "Provider=OraOLEDB.Oracle;"
I am new in Asp.net with Oracle and not build proper connection in it.
View 2 RepliesI am currently working on the connection between ASP.NET and Oracle. I tried to search over the net and know there are many ways. Is there any 'normal practice' on which method to be used? Or it depends?
I am starting a new project where I have to use oracle and asp.net. Oracle 11 enterprise edition. Problem is oracle database reside in linux server and application server is in windows. My question is1. Is there any problem connecting oracle from asp.net?
View 1 RepliesI am developing logging application with asp.net & vb.net & OracleAt present I'm using this mechanism to write logs
Method1 Connect (
Try{
Conn.open ()
[code]...
I am executing a long-running Oracle stored procedure from .NET. The procedure takes about three hours to run. Ideally, the user should be able to kick off the procedure, close the browser, and come back later to check the results.
The problem is that the connection to the Oracle procedure is lost after exactly an hour. As you would expect, the Oracle procedre runs to completion if it is executed from SQL Plus. Strangely enough, it will also run to completion if I run in debug mode on my local machine (I start two threads, one of which executes the procedure. I set a breakpoint on the second thread).
Here is my connection string:
data source= (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=serverx)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=TestSID)))
Some relevant sections from web.config:
<sessionState mode="InProc" cookieless="false" timeout="3000" stateNetworkTimeout="72000"/>
<httpRuntime executionTimeout="18000" maxRequestLength="2097151" />
Any thoughts as to why the connection is being lost in exactly an hour, and what I can do to maintain the connection until the procedure finishes?
How to connect to different data providers(Say Oracle and SQL Server) using single connection string?
View 1 RepliesAlthough the below connection string works for Select, Insert and Delete functions I can't get to work with Update.
Returns error 'unable to connect to MySQL hosts'
Sub Edit (sender As Object, e As EventArgs)
Dim myConnection As MySqlConnection[code]...
I have fried a multitude of combinations, also from MySQL site without success.
I have a query which gets values from two tables which are in different databases.How can I write a SINGLE Connection String which connects to two databases? By the way I am using SQL Server Database
View 7 Replieshow can i access an AS/400 Database/Table in ASP.net website.I thought i would add something like this in web.config, but it does not work.
<connectionStrings>
<add name="AS400" connectionString="Driver={Client Access ODBC Driver (32-bit)};SERVER=IP Address; USER=usr; PASSWORD=pwd; "/> [code].....
I am trying to write a page to read the Excel file provided by the user. I know I can't use the FileUpload to get the full path of the file from the client PC. This give me the problem when I write the connection string for the Excel file:
[Code]....
Without the full path, I can't replace the Data Source by a variable and I definitely can't assume all users will have their Excel files named Book1.xls located in C:Doc all the time.
I only made 1 other dynamic page before, without users. I do remember I setup a read-only user to the database and that was the user used in the connection string, simple.
In managing multiple users, does asp.net's membership & roles automatically switch up the databases connection string upon login? Do you setup hypothetical "groups" of user access permissions in your database (mysql) then associate that user to that group in membership & roles?
I'm just looking for a general idea of what to expect before I start reading.
i have a dropdownlist contaning years..now i want to connect my database by dropdown selection.if i select 2013 it will connect 2013 database ,if i select 2014 it connect 2014 so on..
View 1 RepliesI have a db connection string 'ApplicationServices' defined in the connectionString section of web.config and 3 Entity Framework connection strings which have the provider connection string attribute with the same connection string as the one in 'ApplicationServices'. Is there a way to reference connectionString in 'ApplicationServices' for the provider connection string attribute of the EF connection string in the web.config, rather than providing the connection string all over again?
View 1 Replieshow we can use oracle 10g in asp.net 3.5 using toad
View 1 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 RepliesI 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>
tried 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();
}
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]....
to Find website or write to me How to use Oracle Membership provider for ASP.Net and what changes should i do to Web.config and machine.config?
View 1 RepliesI am developing a web application with back end as Oracle. I call the procedures from web application when ever some update, create or delete for the records needs to be performed. How to maintain the connection in these scenarios.
Can I open the connection and maintain it through out the application till user logs out?