Databases :: System.Data.OracleClient.dll Deprecated?
Nov 12, 2010
I have a web application that has been using the System.Data.OracleClient.dll for the past 3 years. Recently we've been having some performance issues on the database server and it appears that this app is now causing problems when connecting to our Oracle database.I've found an updated client at the Oracle website: http://www.oracle.com/technetwork/topics/dotnet/index-085163.htmlMy question is: Is it necessary for me to update to this new client?We are running Oracle 11g on 64-bit servers in a cluster.The app is running on a Windows Server 2008 R2 64-bit machine using ASP.NET 4.0. The app was built using Visual Studio 2005 Team Suite on a 32-bit machine. It was re-compiled on a 64-bit machine and imported into Visual Studio 2010 Professional in order to switch the target framework to .NET 4.0. Then it was deployed to the server. This basically updated the Web.config file for us, the rest of the site remains the same as before.
View 2 Replies
Similar Messages:
Sep 7, 2010
I downloaded the OracleHelper.cs & I use VisualStudio 2008,I'm suppose to pass values to a stored procedure which accepts 2 parametersWhen i pass from codebehind it says,
[code]...
View 2 Replies
Jul 20, 2010
Getting the following error when browsing .net 2.0 application System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
I have setup a .net 2.0 application with oracle backend on windows server 2008 R2. I have oracle client 11g installed on the server for the application to talk to the oracle database. This worked well when the .net 2.0 application was hosted on windows server 2003 and oracle client 10g. But when it is hosted on server 2008 with new oracle client it is giving the above error when browsing the page. This error occurs when the connection is opened inside the c# code.
View 3 Replies
Mar 4, 2010
I have a asp.net web application that connects to a Oracle 10.2g database. If I'm running my site in the Visual Studio 2008 webserver everithing is ok, but when a publish it in IIS a get "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater".
I added all the permissions for the ASPNET, Authenticated Users and even Everyone but still doesn't work.
I have no idea what else to try. It seems clear to me that this is an IIS issue as the site works well in VS2008 integrated webserver. I'm using IIS 5.1.
View 1 Replies
Jul 18, 2010
Can anyone share a link to sample (ASP).Net code that uses the new Oracle Data Provider.Net library?I have code a web application code that uses the System.Data.OracleClient classes and want to migrate to the new Oracle Data Provider for .Net.
View 2 Replies
Feb 25, 2011
I am using .net framework 4 and connecting to oracle 10 g via System.Data.OracleClient. It is working but it says it is deprecated and what else should I use instead of it?
View 2 Replies
Jul 23, 2010
As I am working on Employee Management system, I have two table (for example) in database as given below.
EmployeeMaster (DB table structure)
EmployeeID (PK) | EmployeeName | City
MonthMaster (DB table structure)
Month | Year | EmployeeID (FK) | PrenentDays | BasicSalary
Now my question is, I want to store data in file system rather than storing data in SQL or ORACLE.
I want my data in file system storage for Insert, Edit and Delete opration with keeping relation with objects too.
I am a C# developer, Could anybody have thoughts or idea on it. (To store data in file system with keeping relations between them)
View 1 Replies
Aug 26, 2010
i got the following error while i am trying to get my web application to run on windows server 2003. I've installed 2007 data access components on windows server 2003 but the web application does not seem to work. The codes that i use is as follows:
[code]....
I've read a lot of forum posts and almost all of them mentioned ab out the connectionstring being wrong. However, when i ran the codes on my local machine, there were no errors. The error only show when i was running on windows server 2003.
View 9 Replies
Feb 16, 2010
I have defined an ODBC Command and ODBCdatareader as follows
OdbcConnection myConnection = new OdbcConnection(connectionString);
OdbcCommand myCommand = new OdbcCommand();
myCommand.Connection = myConnection;
myCommand.CommandText = "select UOPGM from GREG.TUSROPTF";
OdbcDataReader myReader;
myConnection.Open();
myReader = myCommand.ExecuteReader();
When I try to retreive from the reader as follows:
while (myReader.Read())
{
string someString = myReader["UOPGM"];
lstNames.Items.Add(someString);
}
I get the following error
Error reading the database. Unable to cast object of type 'System.Byte[]' to type 'System.String'."
I have also tried string someString = (string)myReader["UOPGM"]; to no avail
View 4 Replies
Nov 23, 2010
I hear HTTP endpoints are being deprecated in SQL Server. What takes its place in future?
View 1 Replies
Jan 21, 2010
i am trying to do: Parameters.Add("@ProfileHtml", SqlDbType.Text, MAX_TEXT).Direction = ParameterDirection.Output but i keep getting this error. MAX_TEXT is integer = 2147483647 Data type 0x23 is a deprecated large object, or LOB, but is marked as output parameter. Deprecated types are not supported as output parameters. Use current large object types instead.
View 4 Replies
Apr 29, 2010
I read on MSDN that Ntext and Image will be removed from future version of SqlServer, but as I check my db the aspnet_Profiles uses ntext and image MSDN says replace them with nvarchar and varbinary
1. I tried to replace these column and got an error
2. When should I replace these datatypes?
3. Will Microsoft put out an update for this particular setup?
View 4 Replies
Jan 5, 2011
We have the data in excel file and want to upload the same into Oracle table.To achieve this we are using following query
insert into [ODBC:Driver={Microsoft ODBC for oracle};connectionstring].tablename (select * from sheet$ )
This is working fine for less records but when the record count increases following is the error faced. Error : System Resource Exceeded
We tried the following:
1. We tried to remove connection pooling for oracle.
2. We tried to remove connection pooling for excel.
3. We also verified that only one connection for each (oracle and excel) is open.
Our assumptions:
1. Either the server setting is the issue
2. Jet oledb Driver is the issue.
View 1 Replies
Jan 8, 2011
is it possible to put my database in the system databases in the program ?
View 2 Replies
Feb 14, 2011
I am using a web method to submit my form data , having Oracle DataBase. And in my local development machine every thing is fine.I am successfully able to submit my form data asynchronously through a web method. But the same project when deployed to test server then while submiting form date there an error occurs as stated above. One field in the table is of DataTime type, and i am inserting server's date into that field, all other fields are of type varchar2 or int. I googled about that but it seems that no one has got such error.
View 16 Replies
Jul 6, 2010
i want to develop a data access layer ,it can support multiple database like oracle ,Mssqlserver and Mysql using enterprise library and C#.net 3.5 based on database connection
View 1 Replies
Jul 6, 2010
I have been trying to get the data display on the datagrid after selecting a customer.
With the same connection it populates the selection right. But just do not seem to extract the following SQL.
The litABC is to check the flow of control.
There is no syntax error but in the debug menu,
I got A first chance exception of type 'System.Data.Odbc.OdbcException' occurred in System.
Where did I do wrong?
[code]....
View 1 Replies
Nov 25, 2010
When i fill my sql adapter daAuthors.Fill(dsPubs, "MYTable") sometime i get A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dllmy code can run for a lot hours without any problems but sometime i get the message
View 1 Replies
Aug 20, 2010
my table column is:
AttachContent varbinary (max)
when i try to retrieve the data and i get this below error, i am using linq
cannot convert from 'System.Data.Linq.Binary' to 'System.IO.BinaryReader'
View 1 Replies
Oct 19, 2010
currently, I am working on the project where I have to configure Application on IIS7 with network drive and doing this I am getting the error regarding security. Let me explain in detail. We have two production server, both having Windows 2008. now one server acting as the storage server and other server will work as web server which having the IIS (here IIS7). Now, I have to deploy the application on the storage server and in web server I have to configure the application in IIS with the path of network drive (here network drive means path of the folder at storage server). At here I had provide the full path like \ servernamedrivename$foldername, and also provide the credential at "connect at" button.Now when I open the page it will display the page but with the following error.
Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. Now new question that Credential is proper or not? Here my both production server having the user : username1 and password: Password1 but the domain is different. So, what I do that enter only the username1 in user name and password1 in password box.
View 1 Replies
Apr 21, 2010
I am LINQ querrying against a datatable. However, I am unsuccessfull with catching null values. Here is my code that is giving me the following error.
[Code]....
I am checking to see if minperc is null. However to check that it still is trying to convert the value to double. Cant figure out a way around it. Here is the error: Cannot cast DBNull.Value to type 'System.Double'. Please use a nullable type.
View 1 Replies
Jan 5, 2010
Unable to cast object of type 'System.Web.UI.LiteralControl' to type 'System.Web.UI.WebControls.TextBox'.
[code]....
View 3 Replies
Jul 12, 2010
in my web project i got an error that i couldnt find any solution. the error says: System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. when i work in local there were no problem i put files to our server and i changed the database also. when i work in server in web application in Default.aspx i can connect db and get values without any problem using my DataLibrary
BUT the problem in my web service i also use my DataLibrary in webservice but when i try to run a method in web service it gives me the error which is : System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
my new db connection is
strConnectionString = "Data Source=OURSERVERNAME\SQLEXPRESS;Initial Catalog=DoveTR;Persist Security Info=True;User ID=sa;Password=123456789;Pooling=True";
View 1 Replies
Oct 1, 2010
Basically, what I did is that: I have a table in SQL database and some of data fields allow null. I built Objectdatasource through dataset. When I built update page using dataset. It generate the following error before showing the update page correctly. It seems I have issue to retrieve the null value from the database through using objectdatasource through dataset. Any suggestions?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
View 6 Replies
Sep 30, 2010
I am trying to upload a picture into database using FormView insertItemTemplate. FormView is bounded by objectdatasource.To upload, I placed FileUpload control inside insertItemTemplate.In table the dataType is image.Error:Object of type 'System.Boolean' cannot be converted to type 'System.Byte[]'.
View 3 Replies
