I am using VS 2008 with frame work 2.0. On my development machine I am using Oracle 9 as database. When I deploy my application where Oracle 9 is installed it works properly. but it gives error on oracle8 NT installed machine as follow.
"System.Data.OracleClient requires Oracle client software version 8.1.7 or greater "I can get rid from this error.
i was under the impression that using the System.Data.OracleClient namespace will allow me to deploy my application without having the client machine install any OracleClient software besides the .Net Framework 2.0 which if i'm not mistaken, contains the System.Data.OracleClient.dll.
but after creating a WinForm application and then publishing it thru ClickOnce , i found myself getting this error when running the application on the client machine. is this a normal behavior or did i do something wrong in the process?
I have a web site that I developed on Vista using Vb.net9. It makes a connection to Oracle. for the connection I use System.Data.OracleClient. It works fine on my machine, and our test server, but it does not work on the production server. We installed the Oracle Client 11 on the server. The error is System.Data.OracleClient requires Oracle client software version 8.1.7
We've tried, making a console app that opens the connection, connection runs fine, opens, displays a message and all is well there.Then we make a simple web form, put it in the directory of the program, just a button, opens the connection, try..catch, grabs error, same error.The console app was running under an Administrator, web site running under iwam. Is it possible that iwam has a different path?
Trying to insert 315K Gif files into an Oracle 10g database. Everytime I get this error "ora-01460: unimplemented or unreasonable conversion requested" whe I run the stored procedure. It appears that there is a 32K limit if I use a stored procedure. I read online that this does not apply if you are doing a direct insert, but I do not know how to create the insert string for a Byte Array. This is a thick client running on the server so not worried about SQL Injection attacks.
View 1 RepliesI have developed a windows application which connects to Oracle Database and upload and retrieve data (using System.Data.OracleClient). It is working fine in my developement system. When I build a setup and deploy in another system, it is giving error that Oracle Client is missing.
Do I have to install Oracle Client in the client system to run my application?
(When I visit Oracle site for Oracle Client, it is asking me to download a 200 MB file)
Is there any other way to do this with out installing Oracle Client in the client system?
Greetings, I have installed Oracle 10g Express Edition database on a server and install the client on my PC. Now, I`m developing a vb.net application using visual studio 2005 and I need to use the oracle 10g express edition database. SO I initialize the connection using the following connection string:
[Code]...
I have a windows service written in .NET 2.0 that will run every 5 minutes and executes bunch oracle SQL/PLSQL scripts based on time/validation, it throws the above said error some times against some SQLs, the same SQLs run fine at later point without any error, I have no idea what is going on with the app. I am not sure if this has any thing to do with oracle connection pool as I am properly closing the connections after every SQL execution.
Exception:
System.Exception: Unexpected return code: 1 at System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject, Boolean& isInTransaction) at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString,
[CODE]............................
Getting follwoing error while installing ClickOnce VB.net application"
"the application requires that assembly System.Net Version 3.5.0.0 be installed on GAC"
I can't seem to get it to recognize System.Data.OracleClient. I downloaded and installed the 11gR2, added a reference to Oracle.DataAccess. Looks like there is a 4.112.1.2 and a 2.112.1.2 versions. I'm tried adding both to the project, but neither are giving me access to that assembly. i.e.
[Code]...
Trying to write a list of oracle commands to XML but keep getting this error. "There was an error reflecting type 'System.Data.OracleClient.OracleCommand'."
Friend Sub WriteDataToFile(ByVal Commands As List(Of System.Data.OracleClient.OracleCommand))
Try
Dim PathName As String = OffloaderDataPath() & "Commands " & Now.ToLocalTime.Ticks.ToString & ".XML"
[code]....
I installed .net 2010 ultimate but my proble is i cannot find a reference to System.Data.OracleClient.
View 1 RepliesI am constructing a search function in a class to be used by several of our asp pages. The idea is simple, take a search term from the user and query the database for the item. Currently I am doing this the wrong way, which is vulnerable to SQL injection attacks (and ELMAH is in there to save the day if something goes wrong):
[Code]...
The problem is since I am using a like statement, I need to be able to have % on either side of the search word, and I can't seem to do that with '%:searchterm%', it just gives an error of ORA-01036: illegal variable name/number.Can I parameterize but still have my flexible like statement be a part of it?
I`m using oleDbConnection in order to Select a BLOB data from Oracle column, and I have to stick with this type of connection since all my application is using it.
After I used the following code, I got the error: unspecified [code]....
i Use "Imports System.Data.OracleClient .. Private conn As New OracleConnection()" to connect to my Oracle database..but when i put my program to another PC I need install Oracle Client on it...is there some other way how to connect to Oracle DB without installing oracle client to client PC?? (Database is on Server an program is on client´s PCs)
View 2 RepliesHow to save all the data displayed in DataGridview( 2 column, no primary key) and have a button and
View 7 RepliesIf I create an application in VB.NET using Visual Studio 2008, what version of the .NET Framework do other people need to have in order to run my program? Is it the same every time, or does it depend on what the application actually does?
View 1 RepliesI can create a brand new empty console app in Visual Studio 2008 and add a reference to c:myfilesCrystalDecisions.Enterprise.Framework.dll and verything works just fine.If I do the same thing with the same file in Visual Studio 2010 (after changing my targeted framework to 3.5), I get the error that "CrystalDecisions.Enterprise.Framework.dll or one of its dependencies, requires a later version of the .NET Framework than the one specified in the project." In Visual Studio 2010 it won't work unless I change my targeted framework to 4.0. How is it possible that a DLL could be incompatible with version 3.5 of the framework in VS2010, but compatible in VS 2008?
View 4 RepliesWhen I am trying to connect to database from VB.net, I am getting error.
This is my code.
Public g_Conn As new SqlClient.SqlConnection
With g_Conn
.ConnectionString = "user id=sa ;data source= CCTSRV8; " & _
"persist security info=True; " & _
"initial catalog=pubs ;password=mrwizard"
.Open()
End With
I am getting system.data.sqlclient.sqlclientpermission error.
they need to make some compare version between host version and client version.. and each 1 version different will download the file to the client..[URL]..with both example, how can i make a program in VB.NET just like i said just now?
View 15 RepliesSo I'm making a Program to Start/Restart/Stop and running commands from the Console for my Server.Now when someone uses the console, I want to be alerted of it on my Mail.I am using Visual Studio 2010.
[Code]...
I have Visual Studio 2010 and a VB Project that had a reference to Microsoft.Interop.Excel 12.0. Well recently I changed the reference version to 14.0. That was actually a mistake and now I need to bump it back down to version 12.0. However I get this error in my project now...
Project 'MyProject' requires a reference to version '14.0.0.0' of assembly 'Microsoft.Office.Interop.Excel', but references version '12.0.0.0'
of assembly 'Microsoft.Office.Interop.Excel'.
I tried removing references and adding the com object to, but no avail.
I need to have a 32 bit oracle client installed my test PC which is acctually a 64 bit machine.when i try connecting to oracle in my window application in vb.net ,it does not open the connection.
Imports
Oracle.DataAccess.Client
Public
[Code].....
I have installed Oracle 10g in one of my office's computer. I want to keep this as database server. I am developing a .net project which will communicate with the database server from client machine and from the server machine. I success to communicate with oracle from server machine but not from client machine using the .net project. The connection code is as follows:
Public OraConn As ADODB.Connection
OraConn = New ADODB.Connection
OraConn.Provider = "OraOLEDB.Oracle"
[code].....
As some of you may know, I'm trying to develop a client/server application that requires sending files and text. Text is not a problem, this works fine, and for some of the part, sending files works, but they get slightly mangled in the process. For example, I used a 4x1 BMP that was alternately coloured red and white and tried sending it across. The output was the correct image dimensions, but the colours were wrong. It was more like a very dark red and very dark grey. I inspected the files with notepad, and the header was the same, but the data was different.
I did some research and apparently need to use a BinaryReader and BinaryWriter as opposed to reading the data as a string (like I was when it was being mangled) but now the data is all wrong, even filesize is different.The code below is a simple example of code for reading an image and then writing it again elsewhere using Binary Read/Write.
[Code]...
I am trying to get this program to send an email, but still no luck. I am getting the following error that I do not understand. I do not understand what I am doing wrong. Also, I may have an issue that the computer I am writing this code on and trying to send the message does not have ISS and is just windows XP home.
The error is below
System.Net.Mail.SmtpException was unhandled
Message="The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first. k41sm2133530rvb.6"
[code].....
How to connect to oracle (Linux) without installation of Oracle Client or TOAD .....?
View 2 RepliesI am working on some window application and facing the following error while running my code An unhandled exception of type 'Oracle.DataAccess.Client.OracleException' occurred in oracle.dataaccess.dll
Additional information: System error. I don't know what type of error this is. I have successfully added the reference dll file
i would like to auto check for new version system update when the system is closing. When there is the new version system update, will automatically rename the active exe to FileName.old then copy new version of exe into the folder.
View 1 RepliesWhen I try to install an application to another user's computer I receive a message box that says "Unable to run or install application. The application requires that assembly Microsoft.SqlServer.Pipelinehost version 9.0.242.0 be installed in the global assembly cache (GAC) first.A key feature of the app is to export data from sql server to an excel spread sheet so I have the following import statements
View 3 RepliesHow can i add the stdole version 7 in client computer for .net 2008 ?
View 2 Replies
