Search results for query: *

It is an error message that I get, here is my tnsnames.ora file as of right now: XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rsgis-summer2.erd.ds.usace.army.mil)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) )...

Correct, I have been setting up my original connection string using the tnsnames.ora file. the problem is that the length that the data source is at is too long, it only allows 128 characters, and mine for some reason is over that number. I tried just adding the Connection string that I had...

NO, I know my username and Password! Is there anything else that needs to be put down for the connection string to connect to a remote server? I know those are correct, it just tells me that it is tryin gto connect to the server on the Oracle database on my comuter I set up. If I try to log...

Ok, this works a bit better, except I want to access a remote server, not the Oracle server on my computer. When I put in the information for the remote username and password it says illegal Username/password: logon denied. How can I fix this issue, is there another part of the...

Like i said above, the stored procedure is in the Oracle database side of things, all im trying to do is call the procedure, input the values, let the procedure do its thing, and enter the data within the table. The values that should be in the table are as follows: num, str, numsq, len(str)...

Her it is: MsgBox("1.Connecting...") oOracleConn.Open() MsgBox("1.Connected!") MsgBox("connect for data...") Dim cmd As New OracleCommand("vb", oOracleConn) MsgBox("connection!") Dim sqlTransaction As OracleTransaction = oOracleConn.BeginTransaction() 'sqlTransaction =...

I am using Oracle Express 10g. I have tried to create a connection using VS IDE, but with no success, I have VS .NET 2003. I think what migt be happening is that it doesn't call the stored procedure, becaue I have this line, dim cmd as OracleCommand("vb",oOracleConn), where "vb" is the stored...

I have used the procedure within the SQL command prompt, and it works fine, also works when you use oci8 in Ruby from a remote connection. But For some reason when I use VB.NET it only leaves lots of hyphens, where there should be data. the stored procedure is on the Oracle side, not the...

Ok, Ive been thinking, and I think that I need to look it at a different perspective. The larger picture is that It isn't getting commited, VB.NET in this case does not commit by itself, therefore I need to find the code in which to make that happen. This has come to my attention because of...

One, I am kinda stuck using ODP.NET, Not my choice to make. And secondly yes the procedure works, my buddy has done PL/SQL statements to test it, and on that side it works perfectly fine, its on the client side that is going bonkers, or sending mixed signals. I don't have the tns file because...

That helps a bit, but I still have the issue of it not going into the table, I can't seem to figure out if its Autocommiting or not. Heres my code again: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim oradb As String = "Data...

hi, I was curious if you guys could help me out, for testing purposes I need to connect to the sys, on a remote computer. what is the right syntax for the conection string to do this with? thanks, Justin:confused:

I have found out that OracleDBType.Number does not exist, Why is this so? It makes it extremly difficult to have a number inserted into a table. also, can anyone tell me how to commit a stored procedure, I have it running, but the data doesn't show up in the table, it adds to the row count...

Here is my code, I have just one more question, how do I ask for a value to come back, because im squaring the number, and also getting the length of the string? Do I have to create a new comand to call for those valuse using the "select * from ..." Also, does the type of the string have to...

Hi there, I have been working on a program that talks to an oracle database, Oracle Express 10g right now, and I was wondering exactly how I could use a stored procedure, using the ODP.NET package, to send two variables to it, a num and str. This procedure squares the number and tells you the...