Do you/someone have an example of code and tnsnames.ora and sqlnet.ora
configures for connecting to oracle database?
I have mine as followings but they didn't work.
string connectStr = "User Id=scott;Password=tiger;Data Source=ORCL";
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = my_leptop)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
I tried sqlplus with ORCL, it works fine. Do I need to set sqlnet.ora? How?
-Henry
Ron Grabowski wrote:
Could you post more of the exception?
Have you verified that the Oracle.DataAccess.dll assembly works
correctly? Try creating a simple console app using just ADO.Net and the
Oracle.DataAccessd.dll assembly and see if you can execute a simple
"SELECT COUNT(*) FROM tblUsers" statement.
--- [EMAIL PROTECTED] wrote:
Could someone help to run this HelloWorld program? I go the following
errors:
An unhandled exception of type
'IBatisNet.DataMapper.Exceptions.DataMapperException'
occurred in ibatisnet.datamapper.dll
Additional information: Unable to open connection to "Oracle, oracle
provider V10.1.0.301".
sqlmap.config file is following:
<?xml version="1.0" encoding="utf-8"?>
<sqlMapConfig xmlns="http://ibatis.apache.org/dataMapper";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; >
<providers embedded="Resources.Providers.config, HelloWorld" />
<database>
<provider name="oracle10.1"/>
<dataSource name="HelloWorld" connectionString="Data
Source=lu10g;User Id=scott;Password=tiger"/>
</database>
<sqlMaps>
<sqlMap embedded="Resources.OleDb.Person.xml, HelloWorld" />
</sqlMaps>
</sqlMapConfig>
I am using Oracle.DataAccess.dll for provider downloaded from oracle
site this morning.
Here is my provider file:
<?xml version="1.0" encoding="utf-8"?>
<providers xmlns="http://ibatis.apache.org/providers";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
<clear/>
<provider name="OleDb1.1" description="OleDb, provider V1.0.5000.0
in
framework .NET V1.1" enabled="true"
assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
connectionClass="System.Data.OleDb.OleDbConnection"
commandClass="System.Data.OleDb.OleDbCommand"
parameterClass="System.Data.OleDb.OleDbParameter"
parameterDbTypeClass="System.Data.OleDb.OleDbType"
parameterDbTypeProperty="OleDbType"
dataAdapterClass="System.Data.OleDb.OleDbDataAdapter"
commandBuilderClass="System.Data.OleDb.OleDbCommandBuilder"
usePositionalParameters="true" useParameterPrefixInSql="false"
useParameterPrefixInParameter="false" parameterPrefix=""/>
<provider name="oracle10.1" description="Oracle, oracle provider
V10.1.0.301"
enabled="true" assemblyName="Oracle.DataAccess,
Version=10.1.0.301,
Culture=neutral, PublicKeyToken=89b483f429c47342"
connectionClass="Oracle.DataAccess.Client.OracleConnection"
commandClass="Oracle.DataAccess.Client.OracleCommand"
parameterClass="Oracle.DataAccess.Client.OracleParameter"
parameterDbTypeClass="Oracle.DataAccess.Client.OracleDbType"
parameterDbTypeProperty="OracleDbType"
dataAdapterClass="Oracle.DataAccess.Client.OracleDataAdapter"
commandBuilderClass="Oracle.DataAccess.Client.OracleCommandBuilder"
usePositionalParameters="true" useParameterPrefixInSql="true"
useParameterPrefixInParameter="true" parameterPrefix=":"
useDeriveParameters="false"/>
</providers>
-Henry
Quoting Ron Grabowski <[EMAIL PROTECTED]>:
Here's a console application that calls the QueryForList method on
a
SqlMapper object and prints out Count property of the returned
PersonCollection object:
http://www.ronosaurus.com/IBatisNet/HelloWorld.zip
The path the the Person.mdb file is hard-coded to C:\Person.mdb in
the
SqlMap.config file. The program uses the Log4Net logging adapter
and
records the sql queries sent to the database to a file called
HelloWorld.log.
If you have any questions, try doing this tutorial:
http://tinyurl.com/78use
http://opensource2.atlassian.com/confluence/oss/display/IBATIS/Quick+Start+Guide
--- Henry Lu <[EMAIL PROTECTED]> wrote:
Is there one who can send me a complete console example of c#
ibatis
net
project? I got so many errors one after another. I am not sure I
got/downloaded the right version for everything.
-Henry
