First connect to database with ODP fails error=-3002 msg=''
Tried the example in the odp pdf file. When trying to do con.open()
i get an OraExeception: (the message is empty, the error-number is 3002)
see below for detailed error log...
Tnsping works, TOAD also works (currently I don't have other client tools on my pc, I will download sqlplus et al. but that will take a day on my corporate network...
If I interpret -3002 as ORA-3002 then that means 'operator not supported' but, I doubt that is the correct error-interpretation.
connect_string="User Id=rainbow; Password=youwish;Data Source=pc353_rbow"
Next is the output from:
Console.Write("#=" + ex.Number.tostring + "|msg=" + ex.Message + "|proc=" + ex.Procedure + "|src=" + ex.Source + "|trace=" + ex.StackTrace)
#=-3002|msg=|proc=pc353_rbow|src=Oracle Data Provider for .NET|trace= at Oracle.DataAccess.Client.OraException.HandleErrorHelper(Int32 errCode, OraConnection conn, IntPtr opsErrCtx, IntPtr opsSqlCtx, Object src, String procedure)
at Oracle.DataAccess.Client.OraException.HandleError(Int32 errCode, OraConnection conn, IntPtr opsErrCtx, Object src)
at Oracle.DataAccess.Client.OraConnection.Open()
at WindowsApplication6.Form1.btnConnect_Click(Object sender, EventArgs e) in C:\Documents and Settings\pe\My Documents\Visual Studio Projects\WindowsApplication6\WindowsApplication6\Form1.vb:line 124