[nant-dev] Nant + Oracle Issue.

Wed, 01 Feb 2006 09:22:08 -0800


I am using Nant script to execute Oracle Script.

my Syntax is like this.
<sql
   connstring="Provider=MSDAORA; Data Source=15.31.12.30:1250,db3;User Id=pons;Password=pons;"
   transaction="true"
   delimiter=";"
   delimstyle="Normal"
   print="true"
   source="oracle.txt"
   output="oracleoutput.txt"
/>

my databse server is in linux.
server IP: 15.31.12.30
server Port : 1250

i m getting runtime error and log file is generated.

log file description

***********************************************************************
Fatal NI connect error 12514, connecting to:
 (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=10.31.180.30)(CID=(PROGRAM=E:\msbuild\nant-0.85-rc3\bin\NAnt.exe)(HOST=VSDT0989)(USER=ponvannanp)))(ADDRESS=(PROTOCOL=TCP)(HOST=20.31.1258.30)(PORT=1521)))

  VERSION INFORMATION:
    TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
    Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
  Time: 04-JAN-2006 15:55:49
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12564
    TNS-12564: TNS:connection refused
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0


Error Output.

BUILD FAILED

INTERNAL ERROR

System.Data.OleDb.OleDbException: Oracle error occurred, but error message could not be retrieved from Oracle.
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInf
o, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnection
PoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory conne
ctionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at NAnt.Contrib.Util.SqlHelper..ctor(String connectionString, Boolean useTransaction) in e:\cvs\NAntContrib\src\Util\
SqlHelper.cs:line 46
   at NAnt.Contrib.Tasks.SqlTask.ExecuteTask() in e:\cvs\NAntContrib\src\Tasks\SqlTask.cs:line 330
   at NAnt.Core.Task.Execute()
   at NAnt.Core.Target.Execute()
   at NAnt.Core.Project.Execute(String targetName, Boolean forceDependencies)
   at NAnt.Core.Project.Execute()
   at NAnt.Core.Project.Run()

Please send bug report to nant-developers@lists.sourceforge.net.

Total time: 1.7 seconds.

Please help me on this issue.

Thanks and Regards
P.Ponvannan.


***********************************************************************
Fatal NI connect error 12514, connecting to:
 
(DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=10.31.180.30)(CID=(PROGRAM=E:\msbuild\nant-0.85-rc3\bin\NAnt.exe)(HOST=VSDT0989)(USER=ponvannanp)))(ADDRESS=(PROTOCOL=TCP)(HOST=10.31.180.30)(PORT=1521)))

  VERSION INFORMATION:
        TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
        Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 
9.2.0.1.0 - Production
  Time: 04-JAN-2006 15:55:49
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12564
    TNS-12564: TNS:connection refused
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

Reply via email to