FbConnectionStringBuilder Database Property return null [DNET48]

[firebird-automations]

Submitted by: Cevdet Nuhrat (nuhrat)

Assigned to: @carlosga

Attachments:
WindowsApplication2.rar

FbConnectionStringBuilder fc = new FbConnectionStringBuilder();
fc.DataSource = "localhost";
fc.Database = "d:\\tp2006.gdb"; --> This line returns Value cannot be null. Parameter name: keyword
fc.Dialect = 3;
fc.Password = "***";
fc.UserID = "SYSDBA";

Used to work ok on 1.7.1 version

[firebird-automations]

Commented by: @carlosga

I can't get this to fail, can you send a test case ????

[firebird-automations]

Commented by: Cevdet Nuhrat (nuhrat)

Operating System:XP SP2 (all patches applied)
Firebird : 1.5.2
.net provider: 2.0
Visual Studio 2005

Regards
-cevdet

[firebird-automations]

Modified by: Cevdet Nuhrat (nuhrat)

Attachment: WindowsApplication2.rar [ 10105 ]

[firebird-automations]

Commented by: @carlosga

Hello:

The test you have sent looks as working fine for me, i don't get any exception.

[firebird-automations]

Commented by: Cevdet Nuhrat (nuhrat)

I still have that problem on 2 of my development machines.
After your message I freshly installed XP sp2 VS2005 firebird 1.5.3 & .net provider on 3rd machine and I dont get any exception as you said.

The 2 machines I got error, have both 1.71. & 2.0 provider, I will uninstall 1.7.1 & try to compile the app.

regards
-cevdet

[firebird-automations]

Commented by: @carlosga

It wasn't a real bug

[firebird-automations]

Modified by: @carlosga

status: Open [ 1 ] => Closed [ 6 ]

resolution: Cannot Reproduce [ 5 ]

[firebird-automations]

Commented by: Musa Ulker (musaulker)

I get the same issue too, but in a different line:

Here is the code:

using System;
using System\.Collections\.Generic;
using System\.Text;
using FirebirdSql\.Data\.FirebirdClient;
using System\.Windows\.Forms;

namespace Program\.Operations
\{
    public static class Config
    \{
        private static String connectionString;

        public static bool setConStr\(String filename\)
        \{
            try
            \{

                FbConnectionStringBuilder cs = new FbConnectionStringBuilder\(\);
                cs\.DataSource = "localhost";
                cs\.UserID = "SYSDBA"; // ===\> This line gives an error
                cs\.Password = "masterkey";
                cs\.Database = filename;
                cs\.Port = 3050;
                cs\.Charset = "Windows1254";
                cs\.Pooling = true;
                cs\.ConnectionLifeTime = 30;
                // To use the embedded server set the ServerType to 1
                cs\.ServerType = 0;
                connectionString = cs\.ToString\(\);

                return true;
            \}
            catch \(Exception ex\)
            \{
                MessageBox\.Show\("An error occured\.\\n\\nError Message:" \+ ex\.Message \+ "\\n\\nDetails: " \+ ex\.StackTrace \+ "\\n\\nPlease try again later\.\.\.", "Error", MessageBoxButtons\.OK, MessageBoxIcon\.Error\);
            \}
            return false;
        \}

        public static String getConStr\(\)
        \{
            return connectionString;
        \}
    \}
\}

and here is the exception detials:

A first chance exception of type ' System.ArgumentNullException' occurred in System.Data.dll
An error occured.

Error Message:Value cannot be null.
Parameter name: keyword

Details: at System.Data.Common.DbConnectionStringBuilder.set_Item (String keyword, Object value)
at FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder.set_UserID(String value)
at Program.Operations.Config.setConStr(String filename) in C:\Documents and Settings\user\My Documents\Visual Studio 2005\Projects\Program\Program\Operations\Config.cs:line 19

What do you advice me to solve this issue?

Thanks for your help..

[firebird-automations]

Commented by: @carlosga

The code you have sent works fine for me.

Try to send the question to the .net provider devel list to see if others users have the same problem

[firebird-automations]

Commented by: benjamin indeherberge (dfhwze)

Hi,

I have the same problem in some situations.

I have an embedded firebird database version 2.1, which need to be portable on a windows xp service pack 2 system.
Accessing the database works fine for English and German windows languages, but not for Turkish !
In Turkish I get the same System.ArgumentNullException as Musa Ulker gets.

failed solution: I tried to open the database using all possible charsets firebird can work with, yet without succes.

Could it be a character set problem of windows/firebird ?

[firebird-automations]

Commented by: @cincuranet

Until we can get the reproducible test case with system settings (or maybe access to this system), we can do nothing with it. And as Carlos said, send the question to list.