i use below DLL to connect direct to oracle from client.oci.dll, Oracle.DataAccess.dll, oraociicus11.dll, OraOps11w.dll, orannzsbb11.dll, oraocci11.dll, ociw32.dll
connection string:
Dim oradb As String = "Data Source=(DESCRIPTION=(ADDRESS_LIST=" _
+ "(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.128.33)(PORT=1521)))" _
+ "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=bipcdb)));" _
+ "User Id=msavameri;Password=123456;"
but when I run application the following error occurs:
ORA-28547: connection to server failed, probable Oracle Net admin error
I have the following Stored Procedures create or replace PROCEDURE WEB_AC
[Code]...
First one: At some point in the application I have the valor parameter (of the visual Basic Function) as a string with spaces that is something like "some string with spaces". When this happens, the stored procedure don't update the table. If I execute the SP directly in the DB (with SQL Developer) all works fine. I know it has something to do with the string missing some quotes(') but I haven't make it work yet. Some ideas on this?
Second problem: Sometimes, when debuging the application, if I interrupt the execution, I start getting the ORA-24338 'statement handle not executed' error for hours every time I try to execute it again. I believe it has something to do with an open transaction. But honestly, as I'm new in working with Oracle, I really have no idea what the problem could be.
In SQL I had to alias my column header with some text containing special character, So to mask these characters {}, I had to keep them in double qoutes. eg: select column1 as "{Ctrix}" from table; When ran in sql the result is
{Ctrix} ------- 1
2
3
The problem that I got was while passing the same above query in the code that I had written in VB.strSQL="select column1 as "{Ctrix}" from table;" The query is getting truncated and giving error. Please help me, how to handle this properly at sql/vb... which satisfies both.
I want to update a particular row in the database table but no success,i keep on receiving this error One or more errors occurred during processing of command. ORA-00907: missing right parenthesis
Cmd = New OleDbCommand("UPDATE SUB_DETAIL SET (LECT_ID = " & TextBox3.Text & ") WHERE SUB_ID = " & cmb_subID.Text & ")", con) con.Open()
I'm using crystal reports 9, visual studio 2008, and oracle 9i in this project I'm doing. My crystal reports pull data from an oracle database, and are displayed on a CrystalReportViewer on a windows form. How would I make this connection using vb.net code?[code]...
I recently upgraded my system to Windows 7 64bit and ever since then I have had nothing but issues with my code attempting to access an Oracle database. I was using msdaora for my connection string however that does not work in 64bit. I changed over to OraOLEDB.Oracle which everything I can find on Google says to use however it fails every time. I have installed Oracle 11g 2 times now and even tried reinstalling VB.net 2010 and still no luck.
I am trying to Connect my VB.net Window Application to IBM_DB2 Database.I have used the same method to connect to previous other databases such as SQL Server, Oracle. But getting an error in DB2.
Dim cn As New OdbcConnection("dsn=Sample;uid=db2admin;pwd=password") 'Sample is DSN
cn.Open()
Dim da As New OdbcDataAdapter("Select * from Employee", cn)[code]......
I have the following insert into statement. What I want to do is insert the values to gprdsql.TblOracleNos if TxtOracleNo is not empty, therefore if a user logs on and fill the textbox the values are saved to the table. However, if the oracle number exists in gprdsql.TblOracleNos (i.e, the values ) it should not insert the values, presently it creates the same record again with same values (when the save button is clicked) and this creates duplication. Instead probably bring a pop up message "Oracle number already exists. [Code]
I am reading a csv file in to a datatable in vb.net and making a few checks and appending an extra column. I then want to perform a bulk insert using microsofts Oracle.DataAccess (no choice in this) to an Oracle database. what would be the best way to perform this as there is no bulkImport like in SQLserver.
can you tell me,how can i add a provider for oracle(Microsoft Provider oledb for oracle).Actually i had Microsoft ODBC for oracle but i want to add a provider above mention.
what is wrong with my code and I get no feedback from my button click event, i have imported. ( code Below) and i have tied differrent combinations of the code without sucess.maybe add extra to my code for the list to show open Port or closed ports.
I realize this post is rather long, but I wanted to give all the information up front instead of people having to ask me for more information.At the end of the re-installation of Visual Studio 2008, there is this message:
"Microsoft SQL Publishing Wizard: [2] Error: Installation failed for component Microsoft SQL Publishing Wizard. MSI returned error code 1638" in the log file dd_error_vs_procore_90.txt.
I have searched on Google for this whole message and found some references to this error, but I have done what they said worked for them and it did not fix the problem for me.When I searched for just "MSI returned error code 1638", I got that it cannot install something because it is already installed:"Another version of this product is already installed. Installation of this version cannot continue. To configure or remove the existing version of this product, use Add/Remove Programs on the Control Panel".In Add/Remove Programs I see these two programs:
Microsoft SQL Server Database Publishing Wizard 1.3 Microsoft SQL Server Database Publishing Wizard 1.4
Are these programs/versions what the error is refering to? Am I safe to remove them and depend on the similarly-named item which would be newly installed with Visual Studio 2008 - "Microsoft SQL Publishing Wizard"? I still use SQL Server 2000 and 2005 on my computer, as well as 2008. I had installed VS 2008 on my computer before without this problem and also have VS 2005 and 2010.
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)
Following is the OnCallBack (async communications handler method) in C# and translated to VB.NET.The c# one works fine, but the VB.NET one gives a compilation error: "Property access must assign to the property or use its value." The error happens on the following line:
When I run this function I receive the error "Incorrect syntax near ','. When I click OK, the data is transferred to the database with the event_date values all set to 01/01/00 00:00:00. Eventhough, it is 09/09/2009 and 19/03/2009
Private Sub Exportdata() Dim cmd As New SqlCommand Dim conn As SqlConnection = GetDbConnection()[code]....
I am fairly new to programming and hence require some help and advice. Here goes my problem.I have an excel workbook with defined list of names and I want to change the cell reference for each name using macros. I then want to loop this so that it can change the cell reference for each of the names. I have written a statement to achieve the above but it is throwing object defined error.
I pulled the script and tried to find the error however, line 214 is "End If" with a matching "If" statement. Here is the code in its entirety. Line 214 is near the end with "End If" [Code]
Error1Unable to copy file "objx86DebugPONG.exe" to "binDebugPONG.exe". The process cannot access the file 'binDebugPONG.exe' because it is being used by another process.PONG
I've done it as I've been instructed but what I need to know is why, after I've entered code that gives the value to the btnGuessL_Click event, the strLetterGuessed with an equal sign after it then txtLetter() it is underlined in blue and when I mouse over the underlined portion it says, Value of type "system.windows.forms.textbox" cannot be converted to 'string"
14.Declare a form-level variable named strLetterGuessed as type String.
15.Add code to the btnGuessL_Click event procedure to set the value of strLetterGuessed to the value in txtLetter.
I'm using winmm.dll to playing sounds using c#. Some of mp3/wma/wav files are throwing error code : 277 & 275. How to handle this problem?. Is there anyway to play these type files using winmm.dll's mciSendString() function?
My goal was to make something that would constantly update the amount of gold that someone had. If they had X number of gold, it would display a certain image for a picturebox. You get the deal.I get "Error1'Money_Checker_Loop.My.Resources' is a namespace and cannot be used as an expression. C:**AppDataLocalTemporary ProjectsMoney Checker LoopForm1.vb3347Money Checker Loop.[code]
The same code is being run in 2 different programs to fill an JanusSystem multiselect combobox.
Code: Private Sub Tasks() **************************************************************************** ' Description: Load the combo box for Tasks ' Created by: LMarshall
[code]....
I am unable to determine why it is a problem in one program and not a program in the other one.
