firebird-net-provider — All about development of the MS .Net provider

Re: [Firebird-net-provider] How should I rollback a transaction

[<car...@te...>]

Hello:

> What is wrong in my code ?.

Your code seems to be right ... huummm ... can i send to you the dll 
built from the CVS sources ??


If yes, what version of the .NET Framework are you using ?? and what 
version of the provider ?? 1.5 ??



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] How should I rollback a transaction

[Janusz M <januszms.usunto.@usunto.interia.pl>]

Hi,

It's me again and another problem :).

I have written the code like this:

private: System::Void btnUpdate_Click(System::Object *  sender,
System::EventArgs *  e)
   {
       if(!ValidateData())
         return ;
      FbCommand * cmd = new FbCommand ;
      if(IsNew)
           cmd->CommandText = S"insert into kontrahenci
(kod_kontr,nazwa,typ,miasto,kod_poczt,adres,nip) values
(@kod_kontr,@nazwa,@typ,@miasto,@kod_poczt,@adres,@nip)" ;
     else
      cmd->CommandText= S" update kontrahenci set
nazwa=@nazwa,typ=@typ,miasto=@miasto,kod_poczt=@kod_poczt,adres=@adres,nip=@
nip "
                        S" where kod_kontr=@kod_kontr";
     cmd->Parameters->Add("@kod_kontr",FbDbType::Char)->Value = txtKod->Text
;
     cmd->Parameters->Add("@nazwa",FbDbType::Char)->Value = txtNazwa->Text ;
     cmd->Parameters->Add("@typ",FbDbType::Char)->Value = cmbTyp->Text ;
     cmd->Parameters->Add("@kod_poczt",FbDbType::Char)->Value =
txtKodPoczt->Text ;
     cmd->Parameters->Add("@miasto",FbDbType::Char)->Value = txtMiasto->Text
;
     cmd->Parameters->Add("@adres",FbDbType::Char)->Value = txtAdres->Text ;
     cmd->Parameters->Add("@nip",FbDbType::Char)->Value = txtNIP->Text ;
     try {
           cmd->Connection = dbConn ;
          // dbConn is a global application variable. This connection is
open at the begin of the programm and keep opened  all  the time.
           cmd->Transaction  = dbConn->BeginTransaction();
           cmd->ExecuteNonQuery();
           cmd->Transaction->Commit();
     }catch(Exception * e){
          cmd->Transaction->Rollback();
          MessageBox::Show(e->Message);
          return ;
     }

When the data in the update or  insert statement is correct it works ok.
But when there is an error, for example an exception in a trigger has been
fired, or a string in a field is too long
I get the exception and this is ok. The problem is that line
cmd->Transaction->Rollback();
cause an another exception "An unhandled exception of type
'FirebirdSql.Data.Firebird.FbException' occurred in
firebirdsql.data.firebird.dll. Additional information: Error reading data
from the connection."

I have tried to remove this line.

     }catch(Exception * e){
         // cmd->Transaction->Rollback();
          MessageBox::Show(e->Message);
          return ;
     }

Now the line
MessageBox::Show(e->Message);
displays the message "operation was cancelled". It is wrong too because the
transaction  is still active an any other
updates are impossible in may program.
By the way the message "operation is cancelled" is rather strange, it should
be a message from an exception because an exception
in a trigger has been fired in that case.

What is wrong in my code ?.

regards,

Janusz Mars

Re: [Firebird-net-provider] another problem

[Janusz M <januszms.usunto.@usunto.interia.pl>]

Hi,

I am sending you a simple test case.
Database is the same as in my previous test case.

CREATE TABLE TABLE_TEST (
    FIELD1  INTEGER NOT NULL,
    FIELD2  CHAR(10)
);

ALTER TABLE TABLE_TEST ADD CONSTRAINT PK_TABLE_TEST PRIMARY KEY (FIELD1);



First you must insert a one record in the tabe_test

insert into table_test (field1,field2) values (1,'a');

Then run  this form below, type the character '2' in the textbox labelled
Field1 and press the button "Update".
The program works OK.

Try to type the character 'x'  in the textbox labelled Field1 (notice that
the Field1 is an integer type)  and press the button "Update".
The program hangs

Try to type the string  '12345678901'  in the textbox labelled Field2
(notice that the Field2 is char(10) )  and press the button "Update".
The program hangs too.


This is the test form:


#pragma once


namespace fbTest
{
 using namespace System;
 using namespace System::ComponentModel;
 using namespace System::Collections;
 using namespace System::Windows::Forms;
 using namespace System::Data;
 using namespace System::Drawing;
 using namespace FirebirdSql::Data::Firebird;


 /// <summary>
 /// Summary for Form1
 ///
 /// WARNING: If you change the name of this class, you will need to change
the
 ///          'Resource File Name' property for the managed resource
compiler tool
 ///          associated with all .resx files this class depends on.
Otherwise,
 ///          the designers will not be able to interact properly with
localized
 ///          resources associated with this form.
 /// </summary>
 public __gc class Form1 : public System::Windows::Forms::Form
 {
 public:
  Form1(void)
  {
   InitializeComponent();
  }

 protected:
  void Dispose(Boolean disposing)
  {
   if (disposing && components)
   {
    components->Dispose();
   }
   __super::Dispose(disposing);
  }
 private: FirebirdSql::Data::Firebird::FbConnection *  fbConnection1;
 private: FirebirdSql::Data::Firebird::FbCommand *  fbCommand1;
 private: FirebirdSql::Data::Firebird::FbCommandBuilder *
fbCommandBuilder1;
 private: FirebirdSql::Data::Firebird::FbDataAdapter *  fbDataAdapter1;

 private: System::Data::DataSet *  dataSet1;
 private: System::Data::DataTable *  dataTable1;
 private: System::Data::DataColumn *  dataColumn1;
 private: System::Data::DataColumn *  dataColumn2;




 private: System::Windows::Forms::Button *  button1;
 private: System::Windows::Forms::TextBox *  textBox1;
 private: System::Windows::Forms::TextBox *  textBox2;
 private: System::Windows::Forms::Label *  label1;
 private: System::Windows::Forms::Label *  label2;


 private:
  /// <summary>
  /// Required designer variable.
  /// </summary>
  System::ComponentModel::Container * components;

  /// <summary>
  /// Required method for Designer support - do not modify
  /// the contents of this method with the code editor.
  /// </summary>
  void InitializeComponent(void)
  {
   System::Configuration::AppSettingsReader *  configurationAppSettings =
new System::Configuration::AppSettingsReader();
   this->fbConnection1 = new FirebirdSql::Data::Firebird::FbConnection();
   this->fbCommand1 = new FirebirdSql::Data::Firebird::FbCommand();
   this->fbCommandBuilder1 = new
FirebirdSql::Data::Firebird::FbCommandBuilder();
   this->fbDataAdapter1 = new FirebirdSql::Data::Firebird::FbDataAdapter();
   this->dataTable1 = new System::Data::DataTable();
   this->dataColumn1 = new System::Data::DataColumn();
   this->dataColumn2 = new System::Data::DataColumn();
   this->dataSet1 = new System::Data::DataSet();
   this->button1 = new System::Windows::Forms::Button();
   this->textBox1 = new System::Windows::Forms::TextBox();
   this->textBox2 = new System::Windows::Forms::TextBox();
   this->label1 = new System::Windows::Forms::Label();
   this->label2 = new System::Windows::Forms::Label();
   (__try_cast<System::ComponentModel::ISupportInitialize *
>(this->dataTable1))->BeginInit();
   (__try_cast<System::ComponentModel::ISupportInitialize *
>(this->dataSet1))->BeginInit();
   this->SuspendLayout();
   //
   // fbConnection1
   //
   this->fbConnection1->ConnectionString = (__try_cast<System::String *
>(configurationAppSettings->GetValue(S"User=SYSDBA;Password=masterkey;Databa
se=d:\\test.fdb;DataSource=localhost;Port=305"
    S"0;Dialect=3;Charset=WIN1250;Role=;Connection lifetime=0;Connection
timeout=15;Po"
    S"oling=False;Packet Size=8192", __typeof(System::String))));
   //
   // fbCommand1
   //
   this->fbCommand1->CommandText = S"select field1,field2 from table_test";
   this->fbCommand1->Connection = this->fbConnection1;
   //
   // fbCommandBuilder1
   //
   this->fbCommandBuilder1->DataAdapter = this->fbDataAdapter1;
   //
   // fbDataAdapter1
   //
   this->fbDataAdapter1->SelectCommand = this->fbCommand1;
   System::Data::Common::DataTableMapping* __mcTemp__1[] = new
System::Data::Common::DataTableMapping*[1];
   __mcTemp__1[0] = new System::Data::Common::DataTableMapping(S"Table",
S"Table", new System::Data::Common::DataColumnMapping * [0]);
   this->fbDataAdapter1->TableMappings->AddRange(__mcTemp__1);
   //
   // dataTable1
   //
   System::Data::DataColumn* __mcTemp__2[] = new
System::Data::DataColumn*[2];
   __mcTemp__2[0] = this->dataColumn1;
   __mcTemp__2[1] = this->dataColumn2;
   this->dataTable1->Columns->AddRange(__mcTemp__2);
   System::Data::Constraint* __mcTemp__3[] = new
System::Data::Constraint*[1];
   System::String* __mcTemp__4[] = new System::String*[1];
   __mcTemp__4[0] = S"Field1";
   __mcTemp__3[0] = new System::Data::UniqueConstraint(S"Constraint1",
__mcTemp__4, true);
   this->dataTable1->Constraints->AddRange(__mcTemp__3);
   System::Data::DataColumn* __mcTemp__5[] = new
System::Data::DataColumn*[1];
   __mcTemp__5[0] = this->dataColumn1;
   this->dataTable1->PrimaryKey = __mcTemp__5;
   this->dataTable1->TableName = S"table_test";
   //
   // dataColumn1
   //
   this->dataColumn1->AllowDBNull = false;
   this->dataColumn1->Caption = S"Kolumna 1";
   this->dataColumn1->ColumnName = S"Field1";
   //
   // dataColumn2
   //
   this->dataColumn2->Caption = S"Kolumna 2";
   this->dataColumn2->ColumnName = S"Field2";
   //
   // dataSet1
   //
   this->dataSet1->DataSetName = S"NewDataSet";
   this->dataSet1->Locale = new
System::Globalization::CultureInfo(S"pl-PL");
   System::Data::DataTable* __mcTemp__6[] = new System::Data::DataTable*[1];
   __mcTemp__6[0] = this->dataTable1;
   this->dataSet1->Tables->AddRange(__mcTemp__6);
   //
   // button1
   //
   this->button1->Location = System::Drawing::Point(240, 120);
   this->button1->Name = S"button1";
   this->button1->Size = System::Drawing::Size(72, 32);
   this->button1->TabIndex = 1;
   this->button1->Text = S"Update";
   this->button1->Click += new System::EventHandler(this, button1_Click);
   //
   // textBox1
   //
   this->textBox1->DataBindings->Add(new
System::Windows::Forms::Binding(S"Text", this->dataSet1,
S"table_test.Field1"));
   this->textBox1->Location = System::Drawing::Point(80, 32);
   this->textBox1->Name = S"textBox1";
   this->textBox1->Size = System::Drawing::Size(120, 20);
   this->textBox1->TabIndex = 2;
   this->textBox1->Text = S"textBox1";
   //
   // textBox2
   //
   this->textBox2->DataBindings->Add(new
System::Windows::Forms::Binding(S"Text", this->dataSet1,
S"table_test.Field2"));
   this->textBox2->Location = System::Drawing::Point(80, 80);
   this->textBox2->Name = S"textBox2";
   this->textBox2->Size = System::Drawing::Size(120, 20);
   this->textBox2->TabIndex = 2;
   this->textBox2->Text = S"textBox1";
   //
   // label1
   //
   this->label1->Location = System::Drawing::Point(32, 32);
   this->label1->Name = S"label1";
   this->label1->Size = System::Drawing::Size(40, 23);
   this->label1->TabIndex = 3;
   this->label1->Text = S"Field1";
   //
   // label2
   //
   this->label2->Location = System::Drawing::Point(32, 80);
   this->label2->Name = S"label2";
   this->label2->Size = System::Drawing::Size(40, 23);
   this->label2->TabIndex = 3;
   this->label2->Text = S"Field2";
   //
   // Form1
   //
   this->AutoScaleBaseSize = System::Drawing::Size(5, 13);
   this->ClientSize = System::Drawing::Size(336, 174);
   this->Controls->Add(this->label1);
   this->Controls->Add(this->textBox1);
   this->Controls->Add(this->button1);
   this->Controls->Add(this->textBox2);
   this->Controls->Add(this->label2);
   this->Name = S"Form1";
   this->Text = S"Form1";
   this->Load += new System::EventHandler(this, Form1_Load);
   (__try_cast<System::ComponentModel::ISupportInitialize *
>(this->dataTable1))->EndInit();
   (__try_cast<System::ComponentModel::ISupportInitialize *
>(this->dataSet1))->EndInit();
   this->ResumeLayout(false);

  }
 private: System::Void Form1_Load(System::Object *  sender,
System::EventArgs *  e)
    {

     fbDataAdapter1->Fill(dataSet1,S"table_test");


    }

private: System::Void button1_Click(System::Object *  sender,
System::EventArgs *  e)
   {

    try {

dataSet1->Tables->Item[S"table_test"]->Rows->Item[0]->EndEdit() ;
      fbDataAdapter1->Update(dataSet1->Tables->Item[S"table_test"]);
    }
    catch(Exception * e ){
     MessageBox::Show(e->Message);
    }

   }

};
}


Best regards,

Janusz Mars

[Firebird-net-provider] Updated Ontology DB

[Matt H. <ma...@xp...>]

Everyone:

There is an updated ontology database on the InRAD-only FTP.  The zip is
named "ONTOLOGYDB.ZIP".  The database now includes the NAICS codes,
along with lots of properties for the NAICS codes.
 
Ed and James: this is probably as complete of a database as we'll have
for now.  Let me know if you guys have any problems with it.
 
---Matt

Re: [Firebird-net-provider] Custom Data Adapter

[<car...@te...>]

Hello:

> I would like to see FbDataAdapter fixed so that it works with FbCommand 
> objects that are stored procedures, but it may be that this isn’t doable 
> without some modifications to the Firebird database itself.

As we have talkign about this privately i'm going to comment where is 
the problem and i'm going to reproduce here the last email i have sent 
to you :).

The problem relies in that DbDataAdapter.Update is not calling 
FbDataReader.Read method for delete commands.

Now the fix that i think can solve this, and that i have sent yet to 
your private email:

Maybe there are one way, the Close method of the FbDatareader needs to 
fill output parameters values, we can try to make a call to the Read 
method if the DataReader is in the original position ( and the 
CommandType is an stored procedure and the statement is a select ), 
before call InternalSetOutputParameters .... this can be an option, i 
will try to check it.



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Custom Data Adapter

[Matt H. <ma...@xp...>]

I've been working on a custom Data Adapter for the last day.  It uses
FbDataAdapter to perform some operations, but it implements an Update()
method that works correctly with stored procedures.  It can take either
a DataSet or DataTable as input.  If called with a DataSet, it calls the
custom Update method with each DataTable within the DataSet.  For each
row in a table, the Update method checks it to see if it has been
deleted, modified, or added.  It then calls the appropriate method to
handle each case.  For example, if a row has been deleted, it calls
DoDelete with the row that needs to be deleted.  This method then checks
for the existence of a FbCommand object for doing deletes.  It loads the
command's input parameters from the source row, then executes the
command.  The method then checks for the existence of an output
parameter named "SUCCESS".  If its there, then the method checks to see
if SUCCESS is 1.  If so, it returns a value indicating that the
operation was successful.  If SUCCESS is 0, it returns a value
indicating that the operation failed.  Otherwise, it assumes that the
operation was successful and returns a value indicating success.  This
is a bit of a hack, but it's the only way I could come up with to
determine whether or not the stored procedure affected any rows.  This
requires that the stored procedure check for success (in the case of the
stored procedure for the delete command, it checks to make sure the
target row exists, sets the output parameter SUCCESS to 1 if does, then
performs the delete).
 
There is more logic in the custom adapter than I've described (basic
initialization and cleanup mainly), but I think that describes the
important pieces.
 
I would like to see FbDataAdapter fixed so that it works with FbCommand
objects that are stored procedures, but it may be that this isn't doable
without some modifications to the Firebird database itself. 
 
If anyone has any questions or suggestions, please feel free to contact
me.
 
---Matt

[Firebird-net-provider] Implicit transaction support question

[<car...@te...>]

Hello:

I'm thinking on change a little the behavior if the implicit transaction 
support.

The change i have in mind is that when there are no explicit transaction 
assigned to a FbCommand object the prepare method will start a new 
implicit trasaction, this transaction will be commited when the command 
is executed, in the case of ExecuteReader when the Reader is closed.

The Dispose method will check in any case if there are a uncommitted 
implicit transaction and commit it in that case.

Opinions ???





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Fwd: Re: [Firebird-net-provider] slow FbDataReader]

[<car...@te...>]

-------- Original Message --------
Subject: Re: [Firebird-net-provider] slow FbDataReader
Date: Tue, 20 Jan 2004 14:03:41 +0100
From: Jan <ja...@uv...>
To: Carlos Guzmán Álvarez <car...@te...>
References: 
<OF7...@pr...> 
<400...@te...>

I suppose that your problem ist that BDE / IBX does not fetch the entire
dataset on execution. This is, on the other hand, not the case in the sample
you provided. Remember BDE /IBX is optimized for long running connections
whereas ADO.NET is a disconnected data model.

Regards
Jan Jensen
----- Original Message -----
From: "Carlos Guzmán Álvarez" <car...@te...>
Newsgroups: sourceforge.firebird-net-provider
To: <hre...@pr...>
Cc: <fir...@li...>
Sent: Tuesday, January 20, 2004 1:05 PM
Subject: Re: [Firebird-net-provider] slow FbDataReader


> Hello:
>
> > Data access with FbDataReader is more slower than access with Delphi-BDE
or
> > IBO Objects.
> > Actually fatch times are twice slower.
> > What do you think about it ? Have you a similar experience ?
>
> Can you explain what type of tests you have done ??
>
>
>
>
> --
> Best Regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] slow FbDataReader

[<car...@te...>]

Hello:

> I purposly uses * , not column enumeration becouse I want to fetch all data
> for this test.
> If I use similar data access with Delphi's TQuery object, fetch-time is
> twice faster.
> So I don't know if slower access is FbDataReader attribute or I should use
> another way to fetch all data from table.

Are you running the test in local ?? Maybe i am wrong but IBO, IBX , .. 
are using the firebird client library that for for local connections 
doesn't use tcp/ip and this can make the times to be better.

Or are you using a database that is in a different machine ??

What is the number of records you are trying to fetch ?? Can you post 
the results ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] slow FbDataReader

[<vsn...@pr...>]

>> Data access with FbDataReader is more slower than access with Delphi-BDE
or
>> IBO Objects.
>> Actually fatch times are twice slower.
>> What do you think about it ? Have you a similar experience ?

>Can you explain what type of tests you have done ??


I purposly uses * , not column enumeration becouse I want to fetch all data
for this test.
If I use similar data access with Delphi's TQuery object, fetch-time is
twice faster.
So I don't know if slower access is FbDataReader attribute or I should use
another way to fetch all data from table.


string sql = "SELECT * FROM TABLE";
FbConnection myConnection = new FbConnection(connectionString);
FbCommand myCommand = new FbCommand(sql,myConnection);
myConnection.Open();
FbDataReader myReader = myCommand.ExecuteReader();
int i = 0;
while(myReader.Read())
{
      Console.WriteLine("{1} {0}",myReader.GetString(0),i++);
}
myReader.Close();
myConnection.Close();

thanks

Re: [Firebird-net-provider] slow FbDataReader

[<car...@te...>]

Hello:

> Data access with FbDataReader is more slower than access with Delphi-BDE or
> IBO Objects.
> Actually fatch times are twice slower.
> What do you think about it ? Have you a similar experience ?

Can you explain what type of tests you have done ??




--
Best Regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] slow FbDataReader

[<hre...@pr...>]

Hi,
Data access with FbDataReader is more slower than access with Delphi-BDE or
IBO Objects.
Actually fatch times are twice slower.
What do you think about it ? Have you a similar experience ?

thanks
                                                Peter

Re: [Firebird-net-provider] another problem

[<car...@te...>]

Hello:

> All works OK but when I have filled the textbox with the invalid characters,
> for example instead of a number
> ( field Field1 is integer ) I have written non number string 'abc', after
> call fbDataAdapter1->Update
> the programm hangs. Should it be exception "Invalid format ...".

I can't reproduce this, can you send a test case ?? please.






--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] another problem

[Janusz M <januszms.usunto.@usunto.interia.pl>]

Hi,

I have added to this form I have send to you a textbox control and a button
control. I have bound the textbox to the datasource and to the field Field1.
On button click I update the datatable.

The code is

private: System::Void button1_Click(System::Object *  sender,
System::EventArgs *  e)
   {

    try {
      dataSet1->Tables->Item[S"table_test"]->Rows->Item[0]->EndEdit() ;
      fbDataAdapter1->Update(dataSet1->Tables->Item[S"table_test"]);
    }catch(Exception * e ){
        MessageBox::Show(e->Message);
    }

   }

All works OK but when I have filled the textbox with the invalid characters,
for example instead of a number
( field Field1 is integer ) I have written non number string 'abc', after
call fbDataAdapter1->Update
the programm hangs. Should it be exception "Invalid format ...".

Sorry for my english.

regards,

Janusz










Uzytkownik "Carlos Guzmán Álvarez" <car...@te...> napisal w
wiadomosci news:400...@te......
> Hello:
>
> > My test case
>
> I will try to take a look at it soon, thanks
>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Bug with FbDataAdapter.Update ?

[<car...@te...>]

Hello:

> I can provide code if needed.

Yes, please, if you can provide a test case it will be helpful



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Bug with FbDataAdapter.Update ?

[<ma...@xp...>]

I think I've found a bug with the Update() method of FbDataAdapter.  When 
called on a DataSet that has deleted rows and a DeleteCommand that is a stored 
procedure, the method returns the number of affected rows as expected.  
However, the rows are not actually removed from the database.  I've tried to 
perform the Update() call both within and outside of a transaction, and 
nothing seems to make a difference.  I haven't tested Update() with updated 
rows, but it does work properly for inserted rows.  I've also tested the 
command separately, and it works fine.

I can provide code if needed.

---Matt

RE: [Firebird-net-provider] Creating new database with C#

[Frode L. <fr...@li...>]

Isn't it typical, as soon as I've sent the mail I see the problem. Just
had to remove the (10) behind int to get it working!

Sorry!


-----Original Message-----
From: fir...@li...
[mailto:fir...@li...] On Behalf Of
Frode Lillerud
Sent: 19. januar 2004 15:38
To: Firebird mailinglist
Subject: RE: [Firebird-net-provider] Creating new database with C#

Thanks to both Sander and Carlos, I got it working :)

Now I am pondering one thing. Can anyone see a reason why the following
query is successful;
sql = "CREATE TABLE tokens (f1 varchar(10), token varchar(10));";

while the one below doesn't work - only difference is varchar => int
sql = "CREATE TABLE tokens (f1 int(10) NOT NULL, token VARCHAR(50));";

I get a Dynamic SQL Error code = -104
Token unknown
(

Anyone?

Frode




-------------------------------------------------------
The SF.Net email is sponsored by EclipseCon 2004
Premiere Conference on Open Tools Development and Integration
See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
http://www.eclipsecon.org/osdn
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

RE: [Firebird-net-provider] Creating new database with C#

[Frode L. <fr...@li...>]

Thanks to both Sander and Carlos, I got it working :)

Now I am pondering one thing. Can anyone see a reason why the following
query is successful;
sql = "CREATE TABLE tokens (f1 varchar(10), token varchar(10));";

while the one below doesn't work - only difference is varchar => int
sql = "CREATE TABLE tokens (f1 int(10) NOT NULL, token VARCHAR(50));";

I get a Dynamic SQL Error code = -104
Token unknown
(

Anyone?

Frode

Re: [Firebird-net-provider] Visual C++ Standard 2003 - FbDataAdapter-TableMappings

[<car...@te...>]

Hello:

> My test case

I will try to take a look at it soon, thanks




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Visual C++ Standard 2003 - FbDataAdapter-TableMappings

[Janusz M <januszms.usunto.@usunto.interia.pl>]

Hi,

My test case

Firebird 1.5RC8.
FirebirdNETProvider1.5 RC2

Database test.fdb,

/***************************************************************************
***/
/****         Generated by IBExpert 2003.12.18 2004-01-19 00:05:32
****/
/***************************************************************************
***/

SET SQL DIALECT 3;

SET NAMES WIN1250;

CREATE DATABASE 'd:\test.fdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 1024
DEFAULT CHARACTER SET WIN1250;



/***************************************************************************
***/
/****                                Tables
****/
/***************************************************************************
***/

CREATE TABLE TABLE_TEST (
    FIELD1  INTEGER NOT NULL,
    FIELD2  CHAR(10)
);

/***************************************************************************
***/
/****                             Primary Keys
****/
/***************************************************************************
***/

ALTER TABLE TABLE_TEST ADD CONSTRAINT PK_TABLE_TEST PRIMARY KEY (FIELD1);



The simple form whitout any controls except
FbConnection,FbCommand,FbDataAdpter,FbCommandBuilder.

The code generated from Visual C++ Standard 2003 :


#pragma once


namespace fbTest
{
 using namespace System;
 using namespace System::ComponentModel;
 using namespace System::Collections;
 using namespace System::Windows::Forms;
 using namespace System::Data;
 using namespace System::Drawing;
using namespace FirebirdSql::Data::Firebird;

 /// <summary>
 /// Summary for Form1
 ///
 /// WARNING: If you change the name of this class, you will need to change
the
 ///          'Resource File Name' property for the managed resource
compiler tool
 ///          associated with all .resx files this class depends on.
Otherwise,
 ///          the designers will not be able to interact properly with
localized
 ///          resources associated with this form.
 /// </summary>
 public __gc class Form1 : public System::Windows::Forms::Form
 {
 public:
  Form1(void)
  {
   InitializeComponent();
  }

 protected:
  void Dispose(Boolean disposing)
  {
   if (disposing && components)
   {
    components->Dispose();
   }
   __super::Dispose(disposing);
  }
 private: FirebirdSql::Data::Firebird::FbConnection *  fbConnection1;
 private: FirebirdSql::Data::Firebird::FbCommand *  fbCommand1;
 private: FirebirdSql::Data::Firebird::FbCommandBuilder *
fbCommandBuilder1;
 private: FirebirdSql::Data::Firebird::FbDataAdapter *  fbDataAdapter1;

 private:
  /// <summary>
  /// Required designer variable.
  /// </summary>
  System::ComponentModel::Container * components;

  /// <summary>
  /// Required method for Designer support - do not modify
  /// the contents of this method with the code editor.
  /// </summary>
  void InitializeComponent(void)
  {
   this->fbConnection1 = new FirebirdSql::Data::Firebird::FbConnection();
   this->fbCommand1 = new FirebirdSql::Data::Firebird::FbCommand();
   this->fbCommandBuilder1 = new
FirebirdSql::Data::Firebird::FbCommandBuilder();
   this->fbDataAdapter1 = new FirebirdSql::Data::Firebird::FbDataAdapter();
   //
   // fbConnection1
   //
   this->fbConnection1->ConnectionString =
S"User=SYSDBA;Password=masterkey;Database=d:\\test.fdb;DataSource=localhost;
Port=305"
    S"0;Dialect=3;Charset=WIN1250;Role=;Connection lifetime=0;Connection
timeout=15;Po"
    S"oling=False;Packet Size=8192";
   //
   // fbCommand1
   //
   this->fbCommand1->CommandText = S"select field1,field2 from table_test";
   this->fbCommand1->Connection = this->fbConnection1;
   //
   // fbCommandBuilder1
   //
   this->fbCommandBuilder1->DataAdapter = this->fbDataAdapter1;
   //
   // fbDataAdapter1
   //
   this->fbDataAdapter1->SelectCommand = this->fbCommand1;
   System::Data::Common::DataTableMapping* __mcTemp__1[] = new
System::Data::Common::DataTableMapping*[1];
   __mcTemp__1[0] = new System::Data::Common::DataTableMapping(S"Table",
S"Table", new System::Data::Common::DataColumnMapping * [0]);
   this->fbDataAdapter1->TableMappings->AddRange(__mcTemp__1);
   //
   // Form1
   //
   this->AutoScaleBaseSize = System::Drawing::Size(5, 13);
   this->ClientSize = System::Drawing::Size(552, 254);
   this->Name = S"Form1";
   this->Text = S"Form1";

  }
 };
}


regards

Janusz Mars

Re: [Firebird-net-provider] Visual C++ Standard 2003 - FbDataAdapter-TableMappings

[<car...@te...>]

Hello:

> First thanks for a good job.

Tanks :)

> So I always have to write myself the code for the table mapinngs and column
> mappings

Can you send a test case ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Visual C++ Standard 2003 - FbDataAdapter-TableMappings

[Janusz M <januszms.usunto.@usunto.interia.pl>]

Hi,

First thanks for a good job.
Second a little problem.
I am using Visual C++ Standard 2003,NET 1.1,Managed C++,Windows XP
Home,Firebird 1.5 RC8.
When  I try to open the TableMappings collections editor in the
FbDataAdapter
I get such a message "Unable to retrieve the schema from the database
table.Source column mapping information will not be avaible. Would you like
to continue.". After clicking the Yes button I get the error message
"Specified cast is invalid".
So I always have to write myself the code for the table mapinngs and column
mappings

thanks for any help,

Janusz Mars

Re: [Firebird-net-provider] Creating new database with C#

[Sander B. <sbo...@es...>]

a good example :-)
System.Collections.Hashtable newDB = new System.Collections.Hashtable();


newDB.Add("User","user");

newDB.Add("Password","password");

newDB.Add("ServerType",1);

newDB.Add("Dialect",3);

newDB.Add("DataSource","localhost");

newDB.Add("Pooling",false);

newDB.Add("Database",Environment.CurrentDirectory + DB + Config.sAFile);

FirebirdSql.Data.Firebird.FbConnection.CreateDatabase(newDB);

newDB.Clear();



""Frode Lillerud"" <fr...@li...> wrote in message
news:000801c3dd45$261702b0$0300000a@scalpel...
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0009_01C3DD4D.87DB6AB0
> Content-Type: text/plain;
> charset="us-ascii"
> Content-Transfer-Encoding: 7bit
>
> Hello all, I'm a newcomer to this list.
>
> I'm writing an application in C# (with Visual Studio .NET) which is
> going to use a Firebird database.
> I have successfully been able to connect and query the example
> employee-database, but I'm struggling with creating my own database.
>
> I see in the object browser that there is supposed to be a method called
> CreateDatabase, but I seem unable to use it. Here is the code I use:
>
> string connectionString =
>                                                 "Database=C:\\PROGRAM
> FILES\\FIREBIRD\\EXAMPLES\\EMPLOYEE.FDB;" +
>                                                 "User=SYSDBA;" +
>                                                 "Password=masterkey;" +
>                                                 "Dialect=3;" +
>                                                 "Server=localhost";
> IDbConnection dbcon = new FbConnection(connectionString);
> dbcon.ConnectionString = connectionString;
> dbcon.Open();
>
> For some reason I am not able to use dbcon.CreateDatabase.
>
> Could anyone explain how to get this working? Or point me in the
> direction of a good C# example? I've already had a look at the
> ibphoenix.com site, to no avail.
> Also I'd like to understand what where to set SYSDBA and masterkey.
>
> Thanks
> Frode
>
> ------=_NextPart_000_0009_01C3DD4D.87DB6AB0
> Content-Type: text/html;
> charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
>
> <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
> xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
> xmlns=3D"http://www.w3.org/TR/REC-html40">
>
> <head>
> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
> charset=3Dus-ascii">
>
>
> <meta name=3DProgId content=3DWord.Document>
> <meta name=3DGenerator content=3D"Microsoft Word 10">
> <meta name=3DOriginator content=3D"Microsoft Word 10">
> <link rel=3DFile-List href=3D"cid:filelist.xml@01C3DD4D.873C92A0">
> <!--[if gte mso 9]><xml>
>  <o:OfficeDocumentSettings>
>   <o:DoNotRelyOnCSS/>
>  </o:OfficeDocumentSettings>
> </xml><![endif]--><!--[if gte mso 9]><xml>
>  <w:WordDocument>
>   <w:SpellingState>Clean</w:SpellingState>
>   <w:GrammarState>Clean</w:GrammarState>
>   <w:DocumentKind>DocumentEmail</w:DocumentKind>
>   <w:EnvelopeVis/>
>   <w:Compatibility>
>    <w:BreakWrappedTables/>
>    <w:SnapToGridInCell/>
>    <w:WrapTextWithPunct/>
>    <w:UseAsianBreakRules/>
>   </w:Compatibility>
>   <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
>  </w:WordDocument>
> </xml><![endif]-->
> <style>
> <!--
>  /* Style Definitions */
>  p.MsoNormal, li.MsoNormal, div.MsoNormal
> {mso-style-parent:"";
> margin:0cm;
> margin-bottom:.0001pt;
> mso-pagination:widow-orphan;
> font-size:12.0pt;
> font-family:"Times New Roman";
> mso-fareast-font-family:"Times New Roman";
> mso-ansi-language:NO-BOK;}
> a:link, span.MsoHyperlink
> {color:blue;
> text-decoration:underline;
> text-underline:single;}
> a:visited, span.MsoHyperlinkFollowed
> {color:purple;
> text-decoration:underline;
> text-underline:single;}
> span.EmailStyle17
> {mso-style-type:personal-compose;
> mso-style-noshow:yes;
> mso-ansi-font-size:10.0pt;
> mso-bidi-font-size:10.0pt;
> font-family:Arial;
> mso-ascii-font-family:Arial;
> mso-hansi-font-family:Arial;
> mso-bidi-font-family:Arial;
> color:windowtext;}
> span.SpellE
> {mso-style-name:"";
> mso-spl-e:yes;}
> span.GramE
> {mso-style-name:"";
> mso-gram-e:yes;}
> @page Section1
> {size:612.0pt 792.0pt;
> margin:72.0pt 90.0pt 72.0pt 90.0pt;
> mso-header-margin:35.4pt;
> mso-footer-margin:35.4pt;
> mso-paper-source:0;}
> div.Section1
> {page:Section1;}
> -->
> </style>
> <!--[if gte mso 10]>
> <style>
>  /* Style Definitions */=20
>  table.MsoNormalTable
> {mso-style-name:"Table Normal";
> mso-tstyle-rowband-size:0;
> mso-tstyle-colband-size:0;
> mso-style-noshow:yes;
> mso-style-parent:"";
> mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
> mso-para-margin:0cm;
> mso-para-margin-bottom:.0001pt;
> mso-pagination:widow-orphan;
> font-size:10.0pt;
> font-family:"Times New Roman";}
> </style>
> <![endif]-->
> </head>
>
> <body lang=3DEN-US link=3Dblue vlink=3Dpurple =
> style=3D'tab-interval:36.0pt'>
>
> <div class=3DSection1>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;
> font-family:Arial;mso-ansi-language:EN-US'>Hello all, I&#8217;m a =
> newcomer to
> this list.<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;
> font-family:Arial;mso-ansi-language:EN-US'><o:p>&nbsp;</o:p></span></font=
> ></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;
> font-family:Arial;mso-ansi-language:EN-US'>I&#8217;m writing an =
> application in
> C# (with Visual Studio .NET) which is going to use a Firebird =
> database.<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;
> font-family:Arial;mso-ansi-language:EN-US'>I have successfully been able =
> to
> connect and query the example employee-database, but I&#8217;m =
> struggling with creating
> my own database.<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;
> font-family:Arial;mso-ansi-language:EN-US'><o:p>&nbsp;</o:p></span></font=
> ></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;
> font-family:Arial;mso-ansi-language:EN-US'>I see in the object browser =
> that
> there is supposed to be a method called <span =
> class=3DSpellE>CreateDatabase</span>,
> but I seem unable to use it. Here is the code I =
> use:<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;
> font-family:Arial;mso-ansi-language:EN-US'><o:p>&nbsp;</o:p></span></font=
> ></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><span
> class=3DGramE><font size=3D2 color=3Dblue face=3DArial><span =
> style=3D'font-size:10.0pt;
> font-family:Arial;color:blue;mso-ansi-language:EN-US'>string</span></font=
> ></span><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'> <span class=3DSpellE>connectionString</span> =3D =
> <o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'><span =
> style=3D'mso-tab-count:4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
> ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
> nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
> bsp;&nbsp;&nbsp; </span>&quot;Database=3DC<span
> class=3DGramE>:\</span>\PROGRAM =
> FILES\\FIREBIRD\\EXAMPLES\\EMPLOYEE.FDB;&quot; =
> +<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'><span =
> style=3D'mso-tab-count:4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
> ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
> nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
> bsp;&nbsp;&nbsp; </span>&quot;User=3DSYSDBA;&quot;
> +<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'><span =
> style=3D'mso-tab-count:4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
> ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
> nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
> bsp;&nbsp;&nbsp; </span>&quot;Password=3D<span
> class=3DSpellE>masterkey</span>;&quot; +<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'><span =
> style=3D'mso-tab-count:4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
> ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
> nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
> bsp;&nbsp;&nbsp; </span>&quot;Dialect=3D3;&quot;
> +<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'><span =
> style=3D'mso-tab-count:4'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
> ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
> nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
> bsp;&nbsp;&nbsp; </span>&quot;Server=3D<span
> class=3DSpellE>localhost</span>&quot;;<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><span
> class=3DSpellE><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:
> Arial;mso-ansi-language:EN-US'>IDbConnection</span></font></span><font =
> size=3D2
> face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'> <span class=3DSpellE>dbcon</span> =3D new <span =
> class=3DSpellE><span
> class=3DGramE>FbConnection</span></span><span =
> class=3DGramE>(</span><span
> class=3DSpellE>connectionString</span>);<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><span
> class=3DSpellE><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:
> Arial;mso-ansi-language:EN-US'>dbcon.ConnectionString</span></font></span=
> ><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'> =3D <span =
> class=3DSpellE>connectionString</span>;<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><span
> class=3DSpellE><span class=3DGramE><font size=3D2 face=3DArial><span =
> style=3D'font-size:
> 10.0pt;font-family:Arial;mso-ansi-language:EN-US'>dbcon.Open</span></font=
> ></span></span><span
> class=3DGramE><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:
> Arial;mso-ansi-language:EN-US'>(</span></font></span><font size=3D2 =
> face=3DArial><span
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:EN-US'>);<o=
> :p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'><o:p>&nbsp;</o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'>For some reason I am not able to use <span =
> class=3DSpellE>dbcon.CreateDatabase</span>.<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'><o:p>&nbsp;</o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'>Could anyone explain how to get this working? Or point me in the
> direction of a good C# example? I&#8217;ve already had a look at the
> ibphoenix.com site, to no avail.<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'>Also I&#8217;d like to understand what where to set SYSDBA and =
> <span
> class=3DSpellE>masterkey</span>. <o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'><o:p>&nbsp;</o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'>Thanks <o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><span
> class=3DSpellE><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:
> Arial;mso-ansi-language:EN-US'>Frode</span></font></span><font =
> face=3DArial><span
> style=3D'font-family:Arial;mso-ansi-language:EN-US'><o:p></o:p></span></f=
> ont></p>
>
> </div>
>
> </body>
>
> </html>
>
> ------=_NextPart_000_0009_01C3DD4D.87DB6AB0--
>
>
>
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Creating new database with C#

[<car...@te...>]

Hello:

> For some reason I am not able to use dbcon.CreateDatabase.

Because it is static, you need to call it as FbConnection.CreateDatabase

The list of valid keys for the hashtable is:

Name 		Description
-------------	------------------------
Database 	Database path.
User 		User name.
Password 	User Password.
Dialect 	Database dialect.
DataSource 	Server name.
Port 		Port number.
Charset 	Database Character Set.
PageSize 	Database page size.
ForcedWrite 	Create database using forced writes mode.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Creating new database with C#

[Frode L. <fr...@li...>]

Hello all, I'm a newcomer to this list.
 
I'm writing an application in C# (with Visual Studio .NET) which is
going to use a Firebird database.
I have successfully been able to connect and query the example
employee-database, but I'm struggling with creating my own database.
 
I see in the object browser that there is supposed to be a method called
CreateDatabase, but I seem unable to use it. Here is the code I use:
 
string connectionString = 
                                                "Database=C:\\PROGRAM
FILES\\FIREBIRD\\EXAMPLES\\EMPLOYEE.FDB;" +
                                                "User=SYSDBA;" +
                                                "Password=masterkey;" +
                                                "Dialect=3;" +
                                                "Server=localhost";
IDbConnection dbcon = new FbConnection(connectionString);
dbcon.ConnectionString = connectionString;
dbcon.Open();
 
For some reason I am not able to use dbcon.CreateDatabase.
 
Could anyone explain how to get this working? Or point me in the
direction of a good C# example? I've already had a look at the
ibphoenix.com site, to no avail.
Also I'd like to understand what where to set SYSDBA and masterkey. 
 
Thanks 
Frode