Re: Ibatis.net 1.6.1 Firebird1.7 cannot connect

Thu, 18 Oct 2007 14:38:36 -0700 

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 - <http://ADO.NET>ADO.NET 
2.0 Data Provider"

    enabled="false"

    assemblyName="FirebirdSql.Data.FirebirdClient , 
Version=<http://2.0.1.0>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 
<<mailto:[EMAIL PROTECTED]>[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
























					Reply via email to