Hallo,
I installed Oracle Client 11g, ODTwithODAC1120320_32bit and Visual Stuido 2010 SP1.
In VisualBasic I added a Data Connection using Oracle Dataprovide for .NET. Then I draged a view from the Data Connection onto the Dataset. Preview Data shows the correct Data. Afterwards I dropped a Datagridview onto my Form. Tableadapters and Bindingsource is created correctly.
After starting the solution and get the error:
---------------------------
Q11g
---------------------------
Oracle.DataAccess.Client.OracleException ORA-12545: Connect failed because target host or object does not exist bei Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
bei Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
bei Oracle.DataAccess.Client.OracleConnection.Open()
bei Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
bei Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
bei System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
bei Q11g.DataSet1TableAdapters.V_NTableAdapter.Fill(V_NDataTable dataTable) in H:\VB\Q11g\DataSet1.Designer.vb:Zeile 4602.
bei Q11g.Form1.Form1_Load(Object sender, EventArgs e) in H:\VB\iQ11g\Form1.vb:Zeile 6.
---------------------------
OK
---------------------------
The client-logfile gives:
Create Relation ADR_CONTROL
Create Relation ADR_INVALIDATION
Create Relation INC_METER_IMPT_DEF
Create Relation INC_METER_PK_IMPTS
***********************************************************************
Fatal NI connect error 12545, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myserver.mydomain.dom)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=test)(CID=(PROGRAM=H:\VB\Q11g.vshost.exe)(HOST=myhost)(USER=me))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.2.0.3.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.3.0 - Production
Time: 11-NOV-2014 12:43:20
Tracing not turned on.
Tns error struct:
ns main err code: 12545
TNS-12545: Message 12545 not found; No message file for product=NETWORK, facility=TNS
ns secondary err code: 12560
nt main err code: 515
TNS-00515: Message 515 not found; No message file for product=NETWORK, facility=TNS
nt secondary err code: 1003
nt OS err code: 0
tnsping is working correctly.
Why isn't my Program able to connect to the database at runtime?
Thank you for your help!