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