Re: [Firebird-net-provider] I had probler with fb.net 1.5 beta 2

[olegmad <ol...@ya...>]

> This is the character set of the database and table fields ?? Can you
> send a sample of the
> connection string that are you using ??

I create new database with that params:

SQL Dialect = 3
Charset = UNICODE_FSS
Page Size = 4096

I create new table in this database:

CREATE TABLE TTT (
    "id"    INTEGER NOT NULL,
    "name"  VARCHAR(10)
);


You can just compile and run next sample, without editing, all info in
ConnectionString - workable!

I send you all my sample:
------------------------------------------------------------------
using System;

using System.Data;

using System.Data.Common;

using FirebirdSql.Data.Firebird;

namespace ConsoleApplication

{

class MainClass

{

static private readonly string ConnectionString =
@"Server=80.80.104.12;Database=c:\temp\carlos.gdb;Connection
Lifetime=15;Dialect=3;User=carlos;Password=carlos;";

static void Main(string[] args)

{

FbConnection connection = new FbConnection(ConnectionString);

connection.Open();

FbTransaction transaction = connection.BeginTransaction();

FbCommand command = new FbCommand("SELECT * FROM TTT", connection,
transaction);


DataTable table = new DataTable();

FbDataAdapter adapter = new FbDataAdapter(command);


adapter.Fill(table);

transaction.Commit();

connection.Close();

}

}

}

------------------------------------------------------------------

P.S.
    When I use fb.net 1.5 for 1.1 beta 1 - all works fine!!!


Thanks!