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

Re: [Firebird-net-provider] Server explorer

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

Hello Guillermo,

Thursday, May 13, 2004, 4:33:01 PM, you wrote:

G> How can I use a .NET data provider in the server explorer of visual studio?
   VS's Server Explorer work's only with OLE DB providers.

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

Re: [Firebird-net-provider] Server explorer

[Carlos G.A. <car...@te...>]

Hello:

> How can I use a .NET data provider in the server explorer of visual studi=
o?

You can't, the server explorer works with OleDb drivers only (if i'm not
wrong).



--
Best regards

Carlos Guzm=C3=A1n =C3=81lvarez
Vigo-Spain

[Firebird-net-provider] Server explorer

[Guillermo <gu...@wo...>]

How can I use a .NET data provider in the server explorer of visual studio?

[Firebird-net-provider] I Have Tonnes Of Medications For You majidae mileage

[Wen B. <xjb...@co...>]

intellect timens coveted tamus wastage freebee boarding prentice trochee parked gueridon 
unshakable foram dissension mascot lumpkin barramunda saxony sauna polyscope tzar gladden vache avifaunal 

[Firebird-net-provider] Borland Data Provider

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

Hello:

I'm starting to think on release the first Alpha of the
Borland Data Provider, but just not sure about how i'm going
to build the binaries ... huummm ... because seems that the BDP
version included in Delphi .NET and C# builder differs  ( if i'm
not wrong, if i'm please let me know :) ), more than probably
i will release binaries for the Delphi .NET version (i have the trial
installed and it's what i'm using for doing basic tests) and people that
is using C# builder (if there are) with a different BDP version will
need to build it from the sources (not difficult at all).

I will do the release probably next week (not decided yet depending
on some things can be that i release it this week).

The release will have a fixed version (1.0.0) because it's needed to
configure it in the BDP configuration files 
(BdpDataSources.xml/BdpConnections.xml)
and it can be used in connection strings as well and a change for each
alpha/beta/rc can be a mess ;)

It needs a lot of testing :) i haven't a NUnit test suite for it for now,
i will try to modify the ADO .NET provider one for use with the BDP and 
test it.


As always opinions and comments are welcome !!



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] remote conection

[<fel...@gv...>]

Hi,

=20

I=B4m going to develo pan application to a PDA using .NET, and i need to
conect to a remote data base (firebird) in real time it=B4s possible =
with
firebird .net provaider?,

How cand do it?

=20

thaks

Re: [Firebird-net-provider] using FbCommandBuilder & DataSet ---> Works now

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

Hi Carlos.

Now it works :-)

A type error. my mistake.


Complete code:

FbConnection connection =3D
FirebirdUtilities.FirebirdConnection.Instance.MyConnection;

FbDataAdapter dataAdapter =3D new FbDataAdapter();

FbTransaction transaction =3D connection.BeginTransaction();


dataAdapter.SelectCommand =3D new FbCommand("SELECT * FROM " + tableName,
connection, transaction);

FbCommandBuilder commandBuilder =3D new FbCommandBuilder(dataAdapter);


System.Data.DataSet dataSet;

dataSet =3D new System.Data.DataSet("SYSTEMSETTINGS");

dataSet.ReadXml(savePath);

dataSet.Tables[0].TableName =3D "SYSTEMSETTINGS";


dataAdapter.Fill(dataSet,"SYSTEMSETTINGS");

dataAdapter.InsertCommand =3D commandBuilder.GetInsertCommand();

dataAdapter.Update(dataSet, "SYSTEMSETTINGS");


transaction.Commit();



Thanks for you'r help/support.

Regards
Thomas



----- Original Message -----=20
From: "Carlos Guzm=E1n =C1lvarez" <car...@te...>
To: "Thomas" <ja...@ma...>
Cc: <fir...@li...>
Sent: Sunday, May 09, 2004 9:17 PM
Subject: Re: [Firebird-net-provider] using FbCommandBuilder & DataSet


> Hello:
>
> > Can anyone see the error?
> >
> DataSet.ReadXml is loading the data in a table called "Table", try this=
:
>
>     DataSet dataSet =3D new DataSet("SYSTEMSETTINGS");
>     dataSet.ReadXml(savePath);
>     dataSet.Tables[0].TableName =3D "SYSTEMSETTINGS";
>     dataAdapter.Fill(dataSet,"SYSTEMSETTINGS");
>     dataAdapter.InsertCommand =3D commandBuilder.GetInsertCommand();
>     dataAdapter.Update(dataSet, "SYSTEMSETTINGS");
>
> It should work, let me know if it works for you.
>
>
>
> --
> Best regards
>
> Carlos Guzm=E1n =C1lvarez
> Vigo-Spain
>

Re: [Firebird-net-provider] using FbCommandBuilder & DataSet

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

Hello:

> Can anyone see the error?
>
DataSet.ReadXml is loading the data in a table called "Table", try this:

    DataSet dataSet = new DataSet("SYSTEMSETTINGS");
    dataSet.ReadXml(savePath);
    dataSet.Tables[0].TableName = "SYSTEMSETTINGS";
    dataAdapter.Fill(dataSet,"SYSTEMSETTINGS");
    dataAdapter.InsertCommand = commandBuilder.GetInsertCommand();
    dataAdapter.Update(dataSet, "SYSTEMSETTINGS");

It should work, let me know if it works for you.



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] using FbCommandBuilder & DataSet

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

Hi

The dataSet has changed.

dataSet.HasChanges(DataRowState.Added);  <--- returns true.

DataSet xDataSet;
xDataSet = dataSet.GetChanges(DataRowState.Added);

xDataSet contains the added rows, but nothing is insert into the database
table....

Regards
Thomas





----- Original Message ----- 
From: "Cihan Karasinir" <cka...@ya...>
To: "Thomas" <ja...@ma...>
Sent: Sunday, May 09, 2004 4:34 AM
Subject: Re: [Firebird-net-provider] using FbCommandBuilder & DataSet


> I am just guessing that the RowState of the DataRow is
> probably "Unchanged" rather than "Added". I don't
> really know how to set it to "Added".
>
> You can also try to call the GetChanges() method on
> your dataset and check that it has any rows. My guess
> it would 0.
>
> I guess you could create another DataSet and iterate
> through your dataset loaded from XML and Add each row
> to the new DataSet thereby imitating as if you
> inserting new rows.
>
> Let me know how you resolved the problem.
>
> Cihan
>
> --- Thomas <ja...@ma...> wrote:
> > Hi
> >
> > I have loaded all data from a database table into a
> > dataSet, and stored this dataSet to a xml file using
> > the WriteXml method.
> >
> > Then I deleted all the data in the database table.
> >
> > Now I would like to read the xml file into a
> > dataSet, and insert the rows from the dataSet into
> > the table in the database.
> >
> >
> >
> > The code gives no error, but there are not insert
> > any data into the table...
> >
> > FbConnection connection =
> >
> FirebirdUtilities.FirebirdConnection.Instance.MyConnection;
> > FbDataAdapter dataAdapter = new FbDataAdapter();
> > FbTransaction transaction =
> > connection.BeginTransaction();
> > dataAdapter.SelectCommand = new FbCommand("SELECT *
> > FROM SYSTEMSETTINGS", connection, transaction);
> > FbCommandBuilder commandBuilder = new
> > FbCommandBuilder(dataAdapter);
> > System.Data.DataSet dataSet;
> > dataSet = new System.Data.DataSet("SYSTEMSETTINGS
> > ");
> > dataSet.ReadXml(savePath);
> > dataAdapter.Fill(dataSet,"SYSTEMSETTINGS ");
> > dataAdapter.InsertCommand =
> > commandBuilder.GetInsertCommand();
> > dataAdapter.Update(dataSet, "SYSTEMSETTINGS ");
> > transaction.Commit();
> >
> >
> >
> > Can anyone see the error?
> >
> > Thanks
> >
> > Regards
> > Thomas
> >
> >
> >
> > ******** Tables definitions ***********
> >
> > CREATE TABLE SYSTEMSETTINGS (
> >     ID INTEGER NOT NULL,
> >     VALUE1 INTEGER,
> >     VALUELONG DOUBLE PRECISION);
> >
> >
> >
> >
> >
> > *********** XML FILE ***************
> >
> > <?xml version="1.0" standalone="yes" ?>
> > - <SYSTEMSETTINGS>
> > - <Table>
> >   <ID>1</ID>
> >   <VALUE1>0</VALUE1>
> >   <VALUELONG>0</VALUELONG>
> >   </Table>
> > - <Table>
> >   <ID>2</ID>
> >   <VALUE1>25</VALUE1>
> >   <VALUELONG>0</VALUELONG>
> >   </Table>
> > - <Table>
> >   <ID>3</ID>
> >   <VALUE1>4</VALUE1>
> >   <VALUELONG>0</VALUELONG>
> >   </Table>
> > - <Table>
> >   <ID>4</ID>
> >   <VALUE1>5</VALUE1>
> >   <VALUELONG>0</VALUELONG>
> >   </Table>
> > - <Table>
> >   <ID>5</ID>
> >   <VALUE1>1</VALUE1>
> >   <VALUELONG>0</VALUELONG>
> >   </Table>
> > - <Table>
> >   <ID>6</ID>
> >   <VALUE1>3</VALUE1>
> >   <VALUELONG>0</VALUELONG>
> >   </Table>
> > - <Table>
> >   <ID>8</ID>
> >   <VALUE1>0</VALUE1>
> >   <VALUELONG>0</VALUELONG>
> >   </Table>
> > - <Table>
> >   <ID>9</ID>
> >   <VALUE1>1</VALUE1>
> >   <VALUELONG>0</VALUELONG>
> >   </Table>
> > - <Table>
> >   <ID>10</ID>
> >   <VALUE1>2</VALUE1>
> >   <VALUELONG>0</VALUELONG>
> >   </Table>
> > - <Table>
> >   <ID>7</ID>
> >   <VALUE1>0</VALUE1>
> >   <VALUELONG>0</VALUELONG>
> >   </Table>
> > - <Table>
> >   <ID>13</ID>
> >   <VALUE1>0</VALUE1>
> >   <VALUELONG>0</VALUELONG>
> >   </Table>
> >   </SYSTEMSETTINGS>
> >
>
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Win a $20,000 Career Makeover at Yahoo! HotJobs
> http://hotjobs.sweepstakes.yahoo.com/careermakeover

Re: [Firebird-net-provider] using FbCommandBuilder & DataSet

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

Hello:

> Can anyone see the error?
>
I will try to review it soon, what version are you using ??






--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] using FbCommandBuilder & DataSet

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

Hi

I have loaded all data from a database table into a dataSet, and stored =
this dataSet to a xml file using the WriteXml method.

Then I deleted all the data in the database table.

Now I would like to read the xml file into a dataSet, and insert the =
rows from the dataSet into the table in the database.



The code gives no error, but there are not insert any data into the =
table...

FbConnection connection =3D =
FirebirdUtilities.FirebirdConnection.Instance.MyConnection;
FbDataAdapter dataAdapter =3D new FbDataAdapter();
FbTransaction transaction =3D connection.BeginTransaction();
dataAdapter.SelectCommand =3D new FbCommand("SELECT * FROM =
SYSTEMSETTINGS", connection, transaction);
FbCommandBuilder commandBuilder =3D new FbCommandBuilder(dataAdapter);
System.Data.DataSet dataSet;
dataSet =3D new System.Data.DataSet("SYSTEMSETTINGS ");=20
dataSet.ReadXml(savePath);=20
dataAdapter.Fill(dataSet,"SYSTEMSETTINGS ");
dataAdapter.InsertCommand =3D commandBuilder.GetInsertCommand();
dataAdapter.Update(dataSet, "SYSTEMSETTINGS ");=20
transaction.Commit();=20



Can anyone see the error?

Thanks

Regards
Thomas



******** Tables definitions ***********

CREATE TABLE SYSTEMSETTINGS (
    ID INTEGER NOT NULL,
    VALUE1 INTEGER,
    VALUELONG DOUBLE PRECISION);





*********** XML FILE ***************

<?xml version=3D"1.0" standalone=3D"yes" ?>=20
- <SYSTEMSETTINGS>
- <Table>
  <ID>1</ID>=20
  <VALUE1>0</VALUE1>=20
  <VALUELONG>0</VALUELONG>=20
  </Table>
- <Table>
  <ID>2</ID>=20
  <VALUE1>25</VALUE1>=20
  <VALUELONG>0</VALUELONG>=20
  </Table>
- <Table>
  <ID>3</ID>=20
  <VALUE1>4</VALUE1>=20
  <VALUELONG>0</VALUELONG>=20
  </Table>
- <Table>
  <ID>4</ID>=20
  <VALUE1>5</VALUE1>=20
  <VALUELONG>0</VALUELONG>=20
  </Table>
- <Table>
  <ID>5</ID>=20
  <VALUE1>1</VALUE1>=20
  <VALUELONG>0</VALUELONG>=20
  </Table>
- <Table>
  <ID>6</ID>=20
  <VALUE1>3</VALUE1>=20
  <VALUELONG>0</VALUELONG>=20
  </Table>
- <Table>
  <ID>8</ID>=20
  <VALUE1>0</VALUE1>=20
  <VALUELONG>0</VALUELONG>=20
  </Table>
- <Table>
  <ID>9</ID>=20
  <VALUE1>1</VALUE1>=20
  <VALUELONG>0</VALUELONG>=20
  </Table>
- <Table>
  <ID>10</ID>=20
  <VALUE1>2</VALUE1>=20
  <VALUELONG>0</VALUELONG>=20
  </Table>
- <Table>
  <ID>7</ID>=20
  <VALUE1>0</VALUE1>=20
  <VALUELONG>0</VALUELONG>=20
  </Table>
- <Table>
  <ID>13</ID>=20
  <VALUE1>0</VALUE1>=20
  <VALUELONG>0</VALUELONG>=20
  </Table>
  </SYSTEMSETTINGS>

[Firebird-net-provider] Cursors

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

Hello:

After read the needs of Keith Nutt i'm thinking on restore the
ability of execute a query using a cursor name, but in a different way
than before.

I was thinking on add a ExecuteCursor method to the FbCommand class
that returns an FbDataReader instance and in add a CursorName property
to the FbDataReader class (read-only).

As always opinions are welcome !!






--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] where current of

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

Hello:

>Has someone an example of using a  cursor ie
>
>update ...  where current of
>
>Sorry to be thick but i am used to cbuilder and now having to use VS 2000
>.NET  i am a
>bit short on examples.
>
It's not possible now (it was implemented time ago using the DataReader 
but it
was removed)

Can you explain what are you trying to do ?? maybe there any other
way for doing it.



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] where current of

[Keith N. <k....@bt...>]

Has someone an example of using a  cursor ie

update ...  where current of

Sorry to be thick but i am used to cbuilder and now having to use VS 2000
.NET  i am a
bit short on examples.


Thanks In Advance

Keith

[Firebird-net-provider] Firebird Job Board

[Helen B. <he...@tp...>]

Now showing at
http://firebird.sourceforge.net/ff/foundation/index.php?id=fbjobs.html

^heLen 

[Firebird-net-provider] Globalization and FxCop

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

Hello:

Running FxCop over the provider assembly gives a good amount of
issues related to Globalization issues (related to the usage of
Cultures and Format providers for conversions), i 'm thinking on
fix them, and probably create a new GlobalizationHelper class
that will have the CultureAwareCompare method that now is in all
collection classess (it will have other things as weel like
a CurrentCulture and CurrentUICulture properties for simplify
the fix of the issues reported by FxCop)

FxCop gives too a good amoun of naming issues, for example to use
FBxxx instead of Fbxxx, but that are not going to change ;) as seems
that in the framework this is not standarized as well ( DBNull and
DbType can be an example and maybe there are more :) )




As always opinions are welcome !!




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] bug report: UNICODE_FSS + CHAR causes exception

[Peter J. <pj...@wa...>]

Hi Pierre,

> > It's 3 bytes per character.
> 
> ...because the internal coding is UTF-8, not UTF-16, so yes, basically, most
> of the simple Unicode characters map to at most 3 bytes using UTF-8. Some
> more exotic characters won't make it, however.

In fact, UNICODE_FSS is more like CESU-8 and the the non-BMP characters
will be represented as two "characters" (low and hi surrogate) each taking 
3 bytes, for a total of 6 bytes.

Regards,
Peter Jacobi

[Firebird-net-provider] [ANN] Firebird ADO.NET Data Provider 1.6 Beta 3 released

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

Hello:

The Firebird ADO.NET 1.6 Beta 3 is available for download.

Beta 3 ( 2004-05-06 )
---- - - ---- -- -- -

(Please review the changelog for details)

- Better fit to ADO.NET

- Bug fixes.

	* Fix COALESCE usage in the FbCommandbuilder class.

- Fixed issues reported by FxCop.

- Better handling of input parameters.

- Added new FbCharset enumeration for use with FbParameter class.

- Added Charset property to FbParameter class.




You can read the Changelog here:

https://sourceforge.net/project/shownotes.php?release_id=236305

You can download the sources here:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider-1.6-Beta3-Src.zip?download

You can download the documentation here:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider-1.6-Beta3-Doc.zip?download

You can download the .NET 1.1 installation here:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider-1.6-Beta3-NET1.1.exe?download

You can download the .NET 1.0 installation here:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider-1.6-Beta3-NET1.0.exe?download



CVS Tag: NP_1_6_BETA3



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] bug report: UNICODE_FSS + CHAR causes exception

[Pierre A. <pie...@op...>]

>> the value of len is 32 (presumably the size of the CHAR(32) field)
>> buffer.Length is 96 (why it is not 64 I don't know... thought unicode
>> was 2 bytes per char)
>> 
> It's 3 bytes per character.

...because the internal coding is UTF-8, not UTF-16, so yes, basically,
most of the simple Unicode characters map to at most 3 bytes using UTF-8.
Some more exotic characters won't make it, however.

    Pierre

[Firebird-net-provider] Re: is OK

[shigueru t. <shi...@ya...>]

confirm 465409



	
		
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
http://hotjobs.sweepstakes.yahoo.com/careermakeover 

[Firebird-net-provider] Development status report

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

Hello:

I have plans for release the Beta 3 today or tomorrow,
after that my plans are to enter in release candidate stage
and allow only bug fixes.

The Borland Data Provider development will continue during the
release candidate stage of the ADO.NET provider, as it's a
separate, i think, there will be no great problems.

I have committed into the CVS the changes for allow to set the
character set of a FbParameter instance.

There are too some changes on the input parameter descriptor
generation, for try to make it more simple (the NUnit test suite
runs fine for me with that changes).


Abel Eduardo if you read this, please, send to me another email the
latest one doesn't show a valid email for reply (at least in Mozilla
and FireFox) ;)



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

P.S.: I have an update version of the Firebird database script for the
Microsoft IssueTracker starter kit, that will solve some little problems
i have found while using it :), if anybody is interested on the new script
please, let me know to my private email.

Re: [Firebird-net-provider] Implicit transactions in FB...

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

Hello:

Sorry for the delay, i was thinking i ave answered this yet :) for
doesn't appear
in my sent email folder.

>BTW, when do I need (must) to use explicit transactions?
>

This will depend on your application, and example can be when you want
to have
atomic updates (inserts, deletes, updates) or when you need to use a
Isolation level
different than ReadCommitted that is the one used always for implicit
transactions.






--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] FbParameter and Charsets

[Chris W. <ch...@co...>]

It has my vote.  I think that's a great idea.

-----Original Message-----
From: fir...@li...
[mailto:fir...@li...] On Behalf Of
Carlos Guzm=E1n =C1lvarez
Sent: Tuesday, May 04, 2004 5:04 AM
To: Firebird ADO.NET Provider
Subject: [Firebird-net-provider] FbParameter and Charsets

Hello:

Now the FbCommand class builds the input parameter descriptor
without making a call to the server, in the case of char and
varchar parameters the descriptor will have always the same
charset as the specified in th connection string, i'm thinking
on add a charset property to the FbParameter class for allow
to set the parameter charset, probably a FbCharset enum will
be needed as well, this will be useful only in the case of work
with fields which charset is different than the database (connection
string) one.


As always opinions are welcome ??




--
Best regards

Carlos Guzm=E1n =C1lvarez
Vigo-Spain



-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g.

Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3D3149&alloc_id=3D8166&op=3Dclick
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] FbParameter and Charsets

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

Hello:

Now the FbCommand class builds the input parameter descriptor
without making a call to the server, in the case of char and
varchar parameters the descriptor will have always the same
charset as the specified in th connection string, i'm thinking
on add a charset property to the FbParameter class for allow
to set the parameter charset, probably a FbCharset enum will
be needed as well, this will be useful only in the case of work
with fields which charset is different than the database (connection
string) one.


As always opinions are welcome ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] bug report: UNICODE_FSS + CHAR causes exception

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

Hello:

>I have a CHAR(32) field in my database using UNICODE_FSS as charset
>trying to insert a string of 32 chars using 
>INSERT MyTable (ColumnName) VALUES (?)
>causes an exception in GdsInetWriter.WriteOpaque
>in the line Write(fill, 0, len - buffer.Length);
>
Huumm can you send a test case ?? What version of the .NET provider are
you using ??
What character set are you using in the connection string ?? And in the
database ??
And in the Field ?? 8-)

>the value of len is 32 (presumably the size of the CHAR(32) field)
>buffer.Length is 96 (why it is not 64 I don't know... thought unicode 
>was 2 bytes per char)
>
It's 3 bytes per character.






--
Best regards

Carlos Guzmán Álvarez
Vigo-spain