Dan,
It's hard to say, I tested it once with small db (~30.000 records) and the
difference was around 1sec.
I also found some other difficulties with native .net drivers so I'm pretty
happy with odbc now.
Other advice - go for ODBC drivers 1.2.1 it's stable and I don't have any
problems with it, I played
a little with latest betas but sometimes it was crushing with my projects so
forget about them for now.
Cheers,
Jakub
On 18/10/2007, Dan Carlton <[EMAIL PROTECTED]> wrote:
>
> Jakub,
>
> Thanks for your response. I have downloaded the firebird source and
> re-build the Provider, but something ain't right. I put displays in the code
> that was failing but they didn't display - don't know what is going on. It
> appears from the logic in the code that my connection string is fine - but I
> can't display what ibatis is sending to Firebird - so I don't know.
>
> I tried the odbc driver and that works well. Do you find that there is
> much of an performance penalty for using ODBC?
>
> Thanks again.
>
> Dan Carlton
>
> At 11:17 AM 10/18/2007, you wrote:
>
> I'm working with FB1.5, but I also tested this stuff with FB2.0.
> Currently I'm using ODBC drivers but for a moment I also had Fb native
> .net drivers.
>
> Here is my connectionstring from properties.config
>
> ODBC:
> <add key="connectionString" value="DRIVER={Firebird/InterBase(r)
> driver};Dialect=3;PASSWORD=pass;UID=USERID;DBNAME=localhost:c:\MYDB.FDB"/>
>
> .NET Drivers
> <add key="connectionString"
> value="User=USERID;Password=pass;Database=C:\\MYDB.FDB;DataSource=localhost;Port=3050;Dialect=3;Charset=NONE;Role=;Connection
> lifetime=0;Connection timeout=15;Pooling=True;Packet Size=8192;Server
> Type=0"/>
>
> And here are providers from providers.config
>
> ODBC:
> <provider
> name="Odbc1.1"
> description="Odbc, 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.Odbc.OdbcConnection"
> commandClass="System.Data.Odbc.OdbcCommand "
> parameterClass="System.Data.Odbc.OdbcParameter"
> parameterDbTypeClass="System.Data.Odbc.OdbcType"
> parameterDbTypeProperty="OdbcType"
> dataAdapterClass=" System.Data.Odbc.OdbcDataAdapter"
> commandBuilderClass="System.Data.Odbc.OdbcCommandBuilder"
> usePositionalParameters="true"
> useParameterPrefixInSql="false"
> useParameterPrefixInParameter="false"
> parameterPrefix=""/>
>
> .NET
> <provider
> name="Firebird2.0"
> description="Firebird, FirebirdClient - ADO.NET 2.0 Data Provider"
> enabled="false"
> assemblyName="FirebirdSql.Data.FirebirdClient , Version=2.0.1.0,
> Culture=neutral, PublicKeyToken=3750abcc3150b00c"
> connectionClass="FirebirdSql.Data.FirebirdClient.FbConnection "
>
> commandClass="FirebirdSql.Data.FirebirdClient.FbCommand"
> parameterClass="FirebirdSql.Data.FirebirdClient.FbParameter"
> parameterDbTypeClass="FirebirdSql.Data.FirebirdClient.FbDbType "
> parameterDbTypeProperty="FbDbType"
> dataAdapterClass="FirebirdSql.Data.FirebirdClient.FbDataAdapter"
> commandBuilderClass="FirebirdSql.Data.FirebirdClient.FbCommandBuilder"
> usePositionalParameters="true"
> useParameterPrefixInSql="false"
> useParameterPrefixInParameter="false"
> parameterPrefix="@"/>
>
> Hope that this stuff will help you.
>
> Cheers,
> Jakub
>
>
> On 18/10/2007, *Dan Carlton* <[EMAIL PROTECTED] > wrote:
> Hello,
>
> I am getting the following error when trying to connect :
>
> Unhandled Exception: System.ArgumentException: An invalid connection
> string argu
> ment has been supplied or a required connection string argument has
> not been sup
> plied.
> 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.DbProvider.CreateConnection()
> at IBatisNet.DataMapper.SqlMapSession.CreateConnection()
> at IBatisNet.DataMapper.SqlMapper.QueryForObject(String
> statementName, Object
>
> connection string:
> database>
> <provider name="Firebird1.7" />
> <dataSource name="Firebird1.7 "
> connectionString=
> "User=dan;
> Password=dan;
> Database=c:\data\firebird\test1.fdb;
> DataSource=localhost;
> Dialect=3;
> Pooling=false
> Charset=NONE;
> Port=3050;" />
>
> </database>
>
> provider.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,
> 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="@"
> allowMARS="false"
> />
>
> Notice that I changed the assemblyName information so that he would
> recognize the matching driver from V1.7.0.33200 to V1.7.0. I didn't
> have any choice about this the only .NET driver from Firebird is
> 1.7.1 - but it gives the same error.
>
> I have noticed that I am not the first with this error - However - I
> have not been able to find a fix in the archives.
> The answer doesn't seem to be in trying different combinations of
> above info - I can read these databases fine with the normal .net
> provider from firebird (in the same program).
>
> Any help would be appreciated.
>
> Thank you. Dan Carlton
>
>
>
