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

Re: [Firebird-net-provider] simple procedure in vb.net

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

Hello:

>    ex.ToString() =
>    System.NullReferenceException: Object reference not set to an
>    instance of an object. 
>    at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows,
>    DataTableMapping tableMapping) 
>    at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
>    at DSUET.Personnel.DivsMembershipForm.SaveDMDetails() in
>    S:\ISUNZ2\src\DSUET.Personnel\Ïðàö³âíèêè\DivsMembershipForm.vb:line 1212

It's giving in the DbDataAdapter class :P it's going to be a little 
difficult to know the problem.

You can't do a test case ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re[2]: [Firebird-net-provider] simple procedure in vb.net

[Dmitry A. <fd...@ua...>]

Hello Carlos,

Friday, April 9, 2004, 2:50:25 PM, you wrote:

>>     Can't understand what's this... :( Can't find bug :((
>>     And this not fb-provider bug :) or i can't create test case :(
CGÁ> Can you make a ex.ToString() and send the result ??
    sorry :) i want do it, but forget this...

   ex.ToString() =
   System.NullReferenceException: Object reference not set to an
   instance of an object. 
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows,
   DataTableMapping tableMapping) 
   at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
   at DSUET.Personnel.DivsMembershipForm.SaveDMDetails() in
   S:\ISUNZ2\src\DSUET.Personnel\Ïðàö³âíèêè\DivsMembershipForm.vb:line 1212

   i'm try all :((( a don't know what...

   PS: .NET Framework 1.0 - now it's principial
   
-- 
Best regards,
 Dmitry                            mailto:fd...@ua...

Re: [Firebird-net-provider] simple procedure in vb.net

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

Hello:

>     Can't understand what's this... :( Can't find bug :((
>     And this not fb-provider bug :) or i can't create test case :(

Can you make a ex.ToString() and send the result ??



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] simple procedure in vb.net

[Dmitry A. <fd...@ua...>]

Hello firebird-net-provider,

  i have simple procedure in vb.net:

    Private Sub SaveDMDetails()
        If Not bmdtDMDetails.Current.GetType() Is GetType(DataRowView) Then
            Return
        End If
        bmdtDMDetails.EndCurrentEdit()

        If DataTableHasChanges(dtDMDetails) Then
            Try
                con.Open()
                Dim _transaction As FbTransaction = con.BeginTransaction( _
                    FbTransactionOptions.NoWait Or _
                    FbTransactionOptions.ReadCommitted Or _
                    FbTransactionOptions.RecVersion _
                    )

                dtaDMDetails.SelectCommand.Transaction = _transaction

                dtaDMDetails.Update(dtDMDetails)

                _transaction.Commit()
                con.Close()
            Catch ex As Exception
                MessageBox.Show(ex.Message)
            End Try

            ' Возможно стоит обновить что-то на форме...
            Dim drvDMDetails As DataRowView = bmdtDMDetails.Current
            Dim drvList As DataRowView = bmdvDivsMembership.Current
            drvList("EMPLOYE") = drvDMDetails("EMPLOYE")
            drvList("SUBDIV") = drvDMDetails("SUBDIV")
            drvList("STAFFBYWORK") = drvDMDetails("STAFFBYWORK")
            drvList("RANK") = drvDMDetails("RANK")
        End If
    End Sub

    and it's work fine... but on 3th edition & save of record i'm got
    exception NullReferenceException in this call:
                dtaDMDetails.Update(dtDMDetails)

    Can't understand what's this... :( Can't find bug :((
    And this not fb-provider bug :) or i can't create test case :(

-- 
Best regards,
 Dmitry                          mailto:fd...@ua...

Re: [Firebird-net-provider] FB Connection

[Dmitry A. <fd...@ua...>]

Hello Steen,

Friday, April 9, 2004, 11:38:12 AM, you wrote:

SSA> What is the problem? It doesn't seem like I'm using the Firebird Provider at
SSA> all?

SSA> HELP!!!
     1) You need in project make reference to
     FirebirdSql.Data.Firebird.dll.
     2) You may in project options set default imports or in you .vb
     module write directive
     Imports FirebirdSql.Data.Firebird

-- 
Best regards,
 Dmitry                            mailto:fd...@ua...

Re: [Firebird-net-provider] FB Connection

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

Hello:

> What is the problem? It doesn't seem like I'm using the Firebird Provider at
> all?
> 
> HELP!!!

Try adding an

	Imports FirebirdSql.Data.Firebird




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] FB Connection

[Steen S. A. <ste...@ms...>]

Hi
As earlier told I am a NEWBIE.

I'm still trying to connect to Firebird 1.5 from Visual Studio .Net
(VB.Net).
1) I have manually inserted a reference (in the Solution Explorer) to
Firebird.Data.Firebird
2) Just to test if all is allright I'm using a bit of a code send from
Carlos:

Public myConnectionString As String

Public myConnection As FbConnection

Public myTxn As FbTransaction

Public selectCmd As String

Public mycommand As FbCommand

Public myReader As FbDataReader

Public myXMLfile As String = "data.xml"

Sub Connect()

' Use Pooling=False so that connections are physically dropped immediately
when connection is closed

myConnectionString =
"Database=C:\Data\NY.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=ser
ver;Pooling=False"

myConnection = New FbConnection(myConnectionString)

myConnection.Open()

myTxn = myConnection.BeginTransaction()

End Sub



When compiling I get severel errors starting with:

1) Type 'FbConnection' is not defined

2) Type FbTransaction' is not defined

3) Type 'FbCommand' is not defined

4) Type 'FbDataReader' is not defined

...an so on.

What is the problem? It doesn't seem like I'm using the Firebird Provider at
all?

HELP!!!



Best Regard

Steen

Re: [Firebird-net-provider] Problem with connection pool

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

Hello:

> I want to execute gbak utility from my client program to restore 
> database (FbRestore can't restore database from client computer to 
> server) . In this case I have problem because of active connections in 
> pool. How can I clear connection pool? I think (for example) that will 
> be very good to have static method ClearConnectionPool() in FbConnection 
> class.

This is possible in 1.6 version only.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Problem with connection pool

[Fedor E. S. <FSh...@sp...>]

I want to execute gbak utility from my client program to restore database 
(FbRestore can't restore database from client computer to server) . In 
this case I have problem because of active connections in pool. How can I 
clear connection pool? I think (for example) that will be very good to 
have static method ClearConnectionPool() in FbConnection class.

Sorry for bad English.
Best regards Fedor,
Moscow Russia 

Re: [Firebird-net-provider] Error in 1.6 Beta 1

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

Hello:

> For selection I use function Fill of FbDataAdapter.

Fixed in CVS (both read and write)


Thanks very much.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Error in 1.6 Beta 1

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

Hello:

> If I select data from the numeric fields it returns without
> "," or ".";
> 
> For example:
> Field - numeric(9,2)
> Value - 30,12
> Result of selection 3012
> 
> For selection I use function Fill of FbDataAdapter.

I will try to review it later today, thanks




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re[2]: [Firebird-net-provider] FbCommandBuilder incorrect behaivor in where clause generation on nullable fields!

[Dmitry A. <fd...@ua...>]

Hello Carlos,

Wednesday, April 7, 2004, 8:30:56 PM, you wrote:

CGÁ> Sorry for the delay :P
     :P :D

CGÁ> I think we have two solutions for this:

CGÁ> 1. Check server version and use COALESCE when possible (i will try to
CGÁ> retrieve the server version after connect)
     I think what it's solution is maximal correct.

CGÁ> 2. Use always PK Fields only for in the where clausule
     For using PK Fields only -- we have CommandBuilderBehaivor property... :)

CGÁ> Opinions ??
     My opinion -- FbCommandBuilderEx %))))

-- 
Best regards,
 Dmitry                            mailto:fd...@ua...

[Firebird-net-provider] Error in 1.6 Beta 1

[work <she...@fo...>]

Hello!

If I select data from the numeric fields it returns without
"," or ".";

For example:
Field - numeric(9,2)
Value - 30,12
Result of selection 3012

For selection I use function Fill of FbDataAdapter.

Best regards, Alex Shevelev                         mailto:she...@fo...

Re: [Firebird-net-provider] Firebird VB.Net Connection

[Steen S. A. <ste...@ms...>]

Hi

Thanks to everybody - Carlos as well as Umberto!!

Best Regards
Steen

Re: [Firebird-net-provider] Firebird VB.Net Connection

[Umberto <um...@kk...>]

> 1) I have installed FirebirdNetProvider 1.6 - on problem
> 2) In the vb.net project I'm trying to connect to Firebird using the tool:
> Connect to Database - BUT in the Provider-Window I simply can't find the
> .net Provider.

If you use Visual Studio you will not use the visual wizards to make
connection - that wizards works only with MS data abses (MS SQL Server,
Access), Oracle and ODBC. If you wany use FB.NET provider just register the
dll into your project and manually put the string connection into your
program. Everything will work fine !

Greetings,

Re: [Firebird-net-provider] FbCommandBuilder incorrect behaivor in where clause generation on nullable fields!

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

Hello:

> COALESCE... ;)))))))


Sorry for the delay :P

I think we have two solutions for this:

1. Check server version and use COALESCE when possible (i will try to
retrieve the server version after connect)

2. Use always PK Fields only for in the where clausule




Opinions ??





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] RE: Unable to load DLL (fbembed)

[Thomas <ja...@ma...>]

Hi Carlos


I have tried all sort of stuff, but still cannot get the embedded server =
to work with Firebird .NET Provider in a WebApp.

Is it possible that you could send me you example project?

Or just you'r connection string ?


Regards
Thomas

-------------------------------------------------------------------------=
------------------------
Hello:

> My DLL are located in:
> =20
> C:\Inetpub\wwwroot\MyWebAPP\bin:
> =20
> fbembed.dll
> FirebirdSql.Data.Firebird.dll
> ib_util.dll
> myDB.GDB
> =20
> =20
> Where exact did you place you'r dLL's ?

I have a virual directory created in IIS for the web app sources (i have =

the sources in other place not inside the IIS folder),
the dll are located in the bin directory of the real web app sources :P=20
(not sure if i have explained it ok)


--
best regards

Carlos Guzm=E1n =C1lvarez
Vigo-Spain

-------------------------------------------------------------------------=
--------------------------------------------

Hello:

>> Have you tried Firebird .NET Provider 1.6 and a WebApp ?
>=20
> Yes but no using the embedded server, i will try to test the MS Issue=20
> Tracker ASP.NET starter kit using the embedded server tomorrow.

I have done a little test but without luck due to problems with the intl =

stuff, were you have located the fbembed.dll ?? ( i was running the test =

with the fbembed.dll in the same directory as the provider dll )


--=20
Best regards

Carlos Guzm=E1n =C1lvarez
Vigo-Spain

-------------------------------------------------------------------------=
----------------------------------------------
 > Have anyone tried to use the FirebirdNet Provider 1.6 (beta1), and =
the
  > embedded server in a .NET WebApp ?
  >=20
  > I get this error when trying to open a connection: (using =
serverType=3D1)
  >=20
  > "Unable to load DLL (fbembed)"..
 =20
  You have this problem with Alpha 1 too ?? How you have installed the=20
  embedded server ??


=20

Re: [Firebird-net-provider] Installing FB .NET Provider 1.5.2 into Delphi 8

[Tobias G. <tob...@ca...>]

Hello Peter,

Using the FB .NET Provider with Delphis form designer is a mess... even 
in a winforms project you can't simply "click" a simple application 
together. Maybe that's not so bad, because it gives you the chance to 
write better code with a nice separated GUI ;)

There are three ways of using the FB .NET Provider in Delphi with visual 
controls, I'm aware of:

1) Stick to WinForms... That's more or less the same as C#.

2) Use FbConnection / FbCommand / FbAdapter and fill your VCL Control,
    i.e. a TLixtBox by hand, using DataSet or DataReader.

3) Use FbConnection / FbCommand / FbAdapter and use TADONETConnector
    to connect a DataSet or DataTable to your data-aware VCL Controls
    like TDBGrid.

A quick and dirty example for 3):

On your form DBGrid1 is connected to DataSource1 and DataSource1 is 
connected to ADONETConnector1.

Now you can do something like this:

procedure TForm1.Button1Click(Sender: TObject);
var
   Connection : FbConnection;
   Adapter : FbDataAdapter;
   empDataTable: DataTable;
begin
   Connection := FbConnection.Create(FConnectionString);
   Connection.Open;
   try
     Adapter := FBDataAdapter.Create(
       'SELECT EMP_NO, FIRST_NAME, LAST_NAME FROM employee', Connection);
     empDataTable := DataTable.Create('employee');
     Adapter.Fill(empDataTable);
     ADoNetConnector1.DataTable := empDataTable;
     ADoNetConnector1.Active := True;
   finally
     Connection.Close;
   end;
end;


Tobias

Re: [Firebird-net-provider] Firebird VB.Net Connection

[Steen S. A. <ste...@ms...>]

Thank you for your answer!

> Maybe that that tool is for OLEDB drivers only ??
- Maybe - I don't know.


> You can see an ASP.NET sample here:
http://cvs.sourceforge.net/viewcvs.py/*checkout*/firebird/NETProvider/NETProvider_15/examples/ASP.NET/VBNETExample.aspx?rev=1.2

- For some reason I Can't se the Samles - T only see an empty picture?


Best Regards
Steen

Re: [Firebird-net-provider] Firebird VB.Net Connection

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

Hello:

> Now - have in mind that I'm a NEWBIE in regard to Firebird and VB.Net.
> I'm trying to connect a vb.net-project to firebird 1.5:
> 
> 1) I have installed FirebirdNetProvider 1.6 - on problem
> 2) In the vb.net project I'm trying to connect to Firebird using the tool:
> Connect to Database - BUT in the Provider-Window I simply can't find the
> .net Provider.

Maybe that that tool is for OLEDB drivers only ??

> ..and last:
> 3) Is it possible to show a working example of a connection from vb.net to
> firebird.

You can see an ASP.NET sample here:

http://cvs.sourceforge.net/viewcvs.py/*checkout*/firebird/NETProvider/NETProvider_15/examples/ASP.NET/VBNETExample.aspx?rev=1.2





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Using provider with DataSet

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

Hello:

> The Ole data objects can create a dataset for you, adding all fields, 
> etc. so that you can use it with a data grid.  Is there something 
> similar in the firebird-net-provider, or do I have to add each field 
> manually?  I have looked all over the place but can’t find a practical 
> way of adding tables with relationships and use them on a form.

If you mean visually no, you can search the list for ea message where a 
  guy explain how to make it using the ODBC provider and using the 
result with the Firebird provider.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Firebird VB.Net Connection

[Steen S. A. <ste...@ms...>]

Hi Experts

Now - have in mind that I'm a NEWBIE in regard to Firebird and VB.Net.
I'm trying to connect a vb.net-project to firebird 1.5:

1) I have installed FirebirdNetProvider 1.6 - on problem
2) In the vb.net project I'm trying to connect to Firebird using the tool:
Connect to Database - BUT in the Provider-Window I simply can't find the
.net Provider.

..and last:
3) Is it possible to show a working example of a connection from vb.net to
firebird.

Thanks to all.
:0)
Steen

[Firebird-net-provider] Using provider with DataSet

[Nelson A. R. <Ne...@ai...>]

The Ole data objects can create a dataset for you, adding all fields,
etc. so that you can use it with a data grid.  Is there something
similar in the firebird-net-provider, or do I have to add each field
manually?  I have looked all over the place but can't find a practical
way of adding tables with relationships and use them on a form.

=20

Thank you.

=20

Nelson

=20

Re: [Firebird-net-provider] FB, dotNet provider & BLOBs - appending

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

Hello:

> Well, hope there's (or will be) a similar functionality in the lower level
> API waiting to be exposed through FB.NET provider...

Huummm ... maybe using stream blobs, i can try to take a look at them

> Never mind, keep up the good work Carlos. :)

:)





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FB, dotNet provider & BLOBs - appending

[Mike J. <jo...@do...>]

I c...
Well, hope there's (or will be) a similar functionality in the lower level
API waiting to be exposed through FB.NET provider...
Never mind, keep up the good work Carlos. :)

Regards, Alex.

"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:407...@te......
> Hello:
>
> > No. In MSSQL server there's an option of just appending binary content
to
> > the BLOB (Image) field without retrieving previous one first and doing
the
> > appending manyally.
>
>
> No, that isn't allowed.
>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>