http://www.connectionstrings.com/ lists this as a sample connection string:
"User=SYSDBA;Password=masterkey;Database=SampleDatabase.fdb;DataSource=localhost;Port=3050;Dialect=3;Charset=NONE;Role=;Connection lifetime=15;Pooling=true;MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0" --- Serge Tahé <[EMAIL PROTECTED]> wrote: > 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 > >
