ibatis and firebird 1.7

[Serge Tahé]

Hello,

Has someone already worked with Ibatis.net 1.2.1 and a Firebird database
with the "firebird1.7" provider ?
I am using this sqlmap.config :

<?xml version="1.0" encoding="ISO-8859-1" ?>
<sqlMapConfig xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:noNamespaceSchemaLocation="Schemas\SqlMapConfig.xsd">
    <properties resource="properties.xml" />
        <database>
          <provider name="${provider}"/>
          <dataSource name="dbimpots"
connectionString="${connectionString}"/>
    </database>
    <sqlMaps>
        <sqlMap resource="..." />
    </sqlMaps>
</sqlMapConfig>

with [properties.xml] :

<?xml version="1.0" encoding="utf-8" ?>
<settings>
    <add key="provider" value="Firebird1.7" />
    <add key="connectionString"
value="User=SYSDBA;Password=masterkey;Database=dbimpots.gdb;DataSource=localhost;Port=3050;Dialect=1;Charset=NONE;Role=;" 

/>
</settings>

with [providers.config] :

    <provider
        name="Firebird1.7"
        description="Firebird, Firebird SQL .NET provider V1.7.0.33200"
        enabled="true"
        assemblyName="FirebirdSql.Data.Firebird, Version=1.7.0.33200,
Culture=neutral, PublicKeyToken=fa843d180294369d"
        connectionClass="FirebirdSql.Data.Firebird.FbConnection"
        commandClass="FirebirdSql.Data.Firebird.FbCommand"
        parameterClass="FirebirdSql.Data.Firebird.FbParameter"
        parameterDbTypeClass="FirebirdSql.Data.Firebird.FbDbType"
        parameterDbTypeProperty="FbDbType"
        dataAdapterClass="FirebirdSql.Data.Firebird.FbDataAdapter"
        commandBuilderClass="FirebirdSql.Data.Firebird.FbCommandBuilder"
        usePositionalParameters = "false"
        useParameterPrefixInSql = "true"
        useParameterPrefixInParameter = "true"
        parameterPrefix="@"
    />

I get the following error message :

[System.ArgumentException: An invalid connection string argument has
been supplied or a required connection string argument has not been
supplied.
   at FirebirdSql.Data.Firebird.FbConnectionString.Validate()
   at FirebirdSql.Data.Firebird.FbConnection.set_ConnectionString(String
value)
   at FirebirdSql.Data.Firebird.FbConnection..ctor(String connectionString)
   at FirebirdSql.Data.Firebird.FbConnection.System.ICloneable.Clone()
   at IBatisNet.Common.Provider.GetConnection()
   at IBatisNet.DataMapper.SqlMapSession.OpenConnection()
   at IBatisNet.DataMapper.SqlMapper.QueryForList(String statementName,
Object p
arameterObject)

I have a sqlmap.config to access the same database via the odbc1.1
provider and it works. I checked carefully the connection String but I
can't see where the problem is coming from.

I would appreciate some help.

Serge


begin:vcard
fn;quoted-printable:Serge Tah=C3=A9
n;quoted-printable:Tah=C3=A9;Serge
org:ISTIA
adr;dom:;;62 av Notre dame du LAc;Angers;;49000
email;internet:[EMAIL PROTECTED]
tel;work:02 41 22 65 18
x-mozilla-html:TRUE
version:2.1
end:vcard