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 > >> > > > > > > > > > > >
