Databases :: SqlDataSource On Oracle 64 Bit?
Aug 2, 2010
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>
View 1 Replies
Similar Messages:
Aug 2, 2010
I have an user control placed on a content page. The content correctly receives the session variables. In the user control I have the following
1. The pageload fires and the text box is correctly set.
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
if (Session["app_id"] != null)
{
txtAppId.Text = Session["app_id"].ToString();
}
</script>
2. I have datagrid in the usercontrol which has a binding variable tied to a control parameters as follows
<asp:SqlDataSource ID="SqlDataSourceMain" runat="server"
ConnectionString="Myconnectionstring"
ProviderName="MyProvider" SelectCommand="select
last_name,first_name
from applications
where (id = to_number(:pAppId))">
<SelectParameters>
<asp:controlparameter name="pAppId" controlid="txtAppId" propertyname="Text" />
</SelectParameters>
<SelectParameters>
<asp:controlparameter name="pAppId" controlID="txtAppId" propertyname="Text"
Direction="InputOutput" Type="Int32" ConvertEmptyStringToNull="True" />
I tried the following, same error
</SelectParameters>
<asp:SessionParameter
ConvertEmptyStringToNull="True"
DefaultValue="0"
Direction=" InputOutput "
Name="pAppId"
SessionField="app_id"
Size="integer"
Type="String" />
</asp:SqlDataSource>
For some reason the select parameter pAddId is getting set to null and get the following error when the content page is loaded If I hard code the value it works RA-01036: illegal variable name/number Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: Oracle.DataAccess.Client.OracleException: ORA-01036: illegal variable name/number
View 1 Replies
Jan 27, 2010
how we can use oracle 10g in asp.net 3.5 using toad
View 1 Replies
Feb 22, 2011
As 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 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
Jan 3, 2011
tried to use linq to oracle 10g express but it throws an error as I can make no errors because I throw
View 1 Replies
Mar 15, 2011
have 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??)...
View 2 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
Jan 8, 2010
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]....
View 4 Replies
Apr 13, 2010
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 Replies
Feb 21, 2011
I 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?
View 10 Replies
Jun 8, 2010
here's my error... Compiler Error Message: CS1502: The best overloaded method match for '_Default.InsertUpdateData(System.Data.SqlClient.SqlCommand)' has some invalid arguments
here's my codebehind:
[Code].....
View 10 Replies
Apr 20, 2010
I'm using oracle for my asp.net website. In website I have 3 different roles. Now do I need to create as many diff users in oracle as roles?
Someone in team insisted on having as many users in oracle. But then unnecessarily i have to maintain multiple connection strings in app.
like, I have manager/ team leader/ user roles.
Now the team member insists on having 3 users in oracle. then in DAL i've to check role and use corresponding connection string.
This is not very big app, but in all 12-15 aspx pages and some 10 table in oracle to be used only on intranet.
what is best practice for this?
View 2 Replies
Feb 1, 2010
I've developed a web app in Visual Studio 2008 using ASP.NET which connects to an Oracle database and a separate SQL Server 2005 database in the same application.
I want to convert this application to use SQL Server only. I have copied the Oracle tables that I need to SQL Server and am in the process of converting the SQL queries from Oracle format to SQL Server format.
I have also modified all the Connection Strings in web.config to point to the SQL Server database now and not the Oracle one.
However I have come across a problem. The TableAdapters are configured to use the OracleClient in the declarations code behind the scenes, i.e. it is "hard coded". But this causes problems of course while modifying/saving queries, because I don't want any trace of Oracle in my new web app.
The only thing I can think of is to delete all my TableAdapters and re-create them all.
View 6 Replies
Feb 7, 2011
I need to transfer SQL Server databse to Oracle database.
View 2 Replies
Jul 15, 2010
In my web page I have written code that writes to a table in Oracle 9i. What I find is add ing or querying the table in Oracle is very slow. I tried doing the same with SQL server database and the process if 5 times faster than Oracle. In the Oracle or SQL table I have not created any indexes / primary keys, but still I find the SQL is way faster than Oracle.
Is there any way that I could improve the speed in Oracle? My table has 3 columns (PRVal, FACVal and UserID). And when the user is selected from the web page I retreive the values from the database, using a direct sql (no pl/sql stuff here, as I am new to Oracle). I use OleDBConnection, OleDbCommand and OleDbReaders classes to access Oracle data.
View 1 Replies
Mar 5, 2011
I am trying to insert NULL value in oracle database using asp.net form. and its not inserting null value check my below code and guide me what changes I have make
Dim
cn As
New OracleConnection("Data
Source=ab; User Id=abc;Password=abc")
Dim SQL
As
String
'build the INSERT statement
Dim xy
As
New System.Text.StringBuilder
'Dim strDate As Date...............................
View 3 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
Mar 16, 2010
Is the "asp.net - oracle" a good solution for web applications?
View 6 Replies
Oct 2, 2010
how i can use Oracle database with asp.net mvc 2 web application?
View 3 Replies
Mar 16, 2011
Does Oracle support mixed mode authentication Windows (active Directory) based authentication and Database authentication together. In other words can I have one application running using Oracle Authentication and one app running using Windows Authentication from the same Database? And does that Windows Authentication comes with Oracle 10g enterprise,so I don't need to purchase any special adapters or middleware?
View 3 Replies
Sep 1, 2010
I 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?
View 1 Replies
Nov 16, 2010
Is the any term like Oracle Fragments.Someone asked me about oracle fragments and if we can join them and how. I din't knew about it.
View 1 Replies
Feb 1, 2010
VB.NET 2.0, windows forms applications. I have two applications, A and B. A accesses a remote Oracle database already, B needs to access a different database, but also Oracle, from the same outside source.So, I thought it would be easy; copy code to connect, change the query, and off we go. But I keep getting the old ORA-12154 error that it can't resolve the connect identifier.First, I developed the query usng sql plus connecting to the target database. So, I know the machine has appropriate entries in tnsnames.ora.Second, I cut-and-pasted the block of code from B into A and gave A a test. It successfully connects and runs the query. So, I know that the data source, user id, password and sql are o.k.Third, I looked in the registry (HKEY_LOCAL_MACHINESOFTWAREOracle) and found the all ORACLE_HOME paths that were set up. Went down all those paths to insure the tnsnames file had my new connection defined.Fourth, I'm able to find the database B is trying to get to via tnsping from the command prompt.Fifth, I copied the connection string from A to B, just to see if it could connect to the database A is known to connect to. Same exception.So, everything connects everywhere except B, who cannot get to Oracle at all. I just can't find what's telling B to use a different tnsnames file (maybe?).Missing something obvious, no doubt.[Edit]I realized overnight I hadn't shown how I was connecting. (The exception is thrown trying to open the connection.) Pretty simple:
[Code]....
[Code]....
View 2 Replies
Jan 27, 2010
Environment used - Asp.net MVC 1.0 with c#
Problem - I want to create the linq to oracle in .net mvc / drag & drop the oracle table onto dbml file.
how to do this?
View 1 Replies
