Menu
▾
▴
firebird-net-provider — All about development of the MS .Net provider
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(10) |
Nov
(55) |
Dec
(36) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(38) |
Feb
(108) |
Mar
(79) |
Apr
(95) |
May
(64) |
Jun
(130) |
Jul
(146) |
Aug
(121) |
Sep
(96) |
Oct
(149) |
Nov
(161) |
Dec
(113) |
| 2004 |
Jan
(113) |
Feb
(163) |
Mar
(248) |
Apr
(132) |
May
(157) |
Jun
(160) |
Jul
(236) |
Aug
(284) |
Sep
(293) |
Oct
(277) |
Nov
(257) |
Dec
(356) |
| 2005 |
Jan
(203) |
Feb
(190) |
Mar
(220) |
Apr
(165) |
May
(124) |
Jun
(160) |
Jul
(190) |
Aug
(142) |
Sep
(152) |
Oct
(189) |
Nov
(187) |
Dec
(159) |
| 2006 |
Jan
(170) |
Feb
(151) |
Mar
(212) |
Apr
(262) |
May
(226) |
Jun
(196) |
Jul
(223) |
Aug
(165) |
Sep
(163) |
Oct
(348) |
Nov
(225) |
Dec
(141) |
| 2007 |
Jan
(261) |
Feb
(161) |
Mar
(222) |
Apr
(193) |
May
(121) |
Jun
(157) |
Jul
(151) |
Aug
(159) |
Sep
(61) |
Oct
(123) |
Nov
(172) |
Dec
(96) |
| 2008 |
Jan
(104) |
Feb
(138) |
Mar
(131) |
Apr
(131) |
May
(74) |
Jun
(107) |
Jul
(89) |
Aug
(89) |
Sep
(172) |
Oct
(158) |
Nov
(119) |
Dec
(86) |
| 2009 |
Jan
(52) |
Feb
(84) |
Mar
(78) |
Apr
(83) |
May
(54) |
Jun
(79) |
Jul
(60) |
Aug
(62) |
Sep
(50) |
Oct
(147) |
Nov
(50) |
Dec
(70) |
| 2010 |
Jan
(135) |
Feb
(113) |
Mar
(74) |
Apr
(93) |
May
(35) |
Jun
(71) |
Jul
(33) |
Aug
(110) |
Sep
(47) |
Oct
(18) |
Nov
(61) |
Dec
(34) |
| 2011 |
Jan
(46) |
Feb
(47) |
Mar
(25) |
Apr
(24) |
May
(21) |
Jun
(22) |
Jul
(20) |
Aug
(51) |
Sep
(31) |
Oct
(42) |
Nov
(22) |
Dec
(22) |
| 2012 |
Jan
(31) |
Feb
(19) |
Mar
(25) |
Apr
(55) |
May
(16) |
Jun
(28) |
Jul
(33) |
Aug
(25) |
Sep
(32) |
Oct
(25) |
Nov
(52) |
Dec
(35) |
| 2013 |
Jan
(43) |
Feb
(18) |
Mar
(36) |
Apr
(45) |
May
(22) |
Jun
(13) |
Jul
(31) |
Aug
(24) |
Sep
(19) |
Oct
(59) |
Nov
(47) |
Dec
(25) |
| 2014 |
Jan
(27) |
Feb
(15) |
Mar
(38) |
Apr
(10) |
May
(15) |
Jun
(36) |
Jul
(24) |
Aug
(28) |
Sep
(16) |
Oct
(6) |
Nov
(44) |
Dec
(40) |
| 2015 |
Jan
(52) |
Feb
(22) |
Mar
(13) |
Apr
(17) |
May
(22) |
Jun
(36) |
Jul
(18) |
Aug
(41) |
Sep
(71) |
Oct
(60) |
Nov
(49) |
Dec
(43) |
| 2016 |
Jan
(60) |
Feb
(13) |
Mar
(21) |
Apr
(28) |
May
(23) |
Jun
(39) |
Jul
(17) |
Aug
(37) |
Sep
(33) |
Oct
(15) |
Nov
(22) |
Dec
(20) |
| 2017 |
Jan
(27) |
Feb
(40) |
Mar
(48) |
Apr
(19) |
May
(29) |
Jun
(2) |
Jul
(19) |
Aug
(36) |
Sep
(18) |
Oct
(10) |
Nov
(11) |
Dec
(5) |
| 2018 |
Jan
(5) |
Feb
(4) |
Mar
(5) |
Apr
(3) |
May
(4) |
Jun
(17) |
Jul
(7) |
Aug
(7) |
Sep
(12) |
Oct
(8) |
Nov
(2) |
Dec
|
| 2019 |
Jan
(8) |
Feb
(5) |
Mar
(3) |
Apr
(5) |
May
(3) |
Jun
(2) |
Jul
(8) |
Aug
(7) |
Sep
(3) |
Oct
(12) |
Nov
(7) |
Dec
(1) |
| 2020 |
Jan
(8) |
Feb
(3) |
Mar
(7) |
Apr
(1) |
May
(2) |
Jun
(1) |
Jul
(3) |
Aug
(25) |
Sep
(5) |
Oct
(3) |
Nov
(7) |
Dec
(16) |
| 2021 |
Jan
(11) |
Feb
(10) |
Mar
(16) |
Apr
(8) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From:
<car...@te...> - 2004-03-15 18:24:49
|
Hello: > I have a initial fix in my local tree i will try to do some tests later > today before commit it. Changes are in CVS yet -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-03-15 12:10:28
|
Hello: > I've noticed that I'm able to assign a string of length 765 or less to > the parameter which then somehow makes it through the stored procedure's > 255 character limit and into the database table. How is this possible? > Surely the table (not to mention the SP) should only allow 255 unicode > characters to be stored, despite the fact that it may have a limit of > 765 bytes? I have a initial fix in my local tree i will try to do some tests later today before commit it. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-03-15 10:37:58
|
Hello:
> where the version and PublicKeyToken is same as in C:\WINDOWS\assembly ..
It works for me :( i'm afraid seems that this works only for me ;), i
have updated in the CVS the web.config file with the configuration i use.
<compilation>
<assemblies>
<add assembly="FirebirdSql.Data.Firebird,
Version=1.5.1517.178, Culture=neutral, PublicKeyToken=e1b4f92304d7b12f" />
</assemblies>
</compilation>
Using WebMatrix (that is using .NET 1.0 in my case, i have both
frameworks installed 1.0 and 1.1), having the .NET 1.0 Firebird .NET
provider assembly installed only in the GAC ( i mean i don't have it in
a bin directory in the examples dir ), and it works for me.
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
|
|
From: weng <cw...@tm...> - 2004-03-15 00:52:02
|
Hi,
Thks for Carlos for asking me trying installing on FirebirdNETProvider1.5.1-NET1.1 , I din have problem on
msvcr70.dll problem anymore... it looks great... But the only problem I have is I can't declared the variable type
'FbDbType'...while trying the vbnetexample.aspx ..
It show Compiler Error Message: BC30451: Name 'FbDbType' is not declared.if I modify the web.conf such as
<compilation>
<assemblies>
<add assembly="FirebirdSql.Data.Firebird" />
</assemblies>
</compilation>
It show Compiler Error Message: BC30560: 'FbConnection' is ambiguous in the namespace 'FirebirdSql.Data.Firebird'. if I modify the web.conf as
<compilation>
<assemblies>
<add assembly="FirebirdSql.Data.Firebird, Version=1.5.1517.216, Culture=neutral, PublicKeyToken=e1b4f92304d7b12f" />
</assemblies>
</compilation>
where the version and PublicKeyToken is same as in C:\WINDOWS\assembly ..
Thks In advance
regards,
weng
|
|
From:
<car...@te...> - 2004-03-14 11:34:11
|
Hello: > I've noticed that I'm able to assign a string of length 765 or less to > the parameter which then somehow makes it through the stored procedure's > 255 character limit and into the database table. How is this possible? > Surely the table (not to mention the SP) should only allow 255 unicode > characters to be stored, despite the fact that it may have a limit of > 765 bytes? Thanks, i will review it as sonn as possible. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: easyTree <eas...@ds...> - 2004-03-14 10:48:21
|
Hi all ;)
I've recently discovered firebird and the .net provider (wow! :) and am r=
unning a couple of tests to familiarise myself with it, in the form of th=
e database version of 'hello world!' - customers/orders/orderdetails/prod=
ucts.
I'm using the embedded version of firebird 1.5 and .net provider 1.6.1524=
.24952 (according to the SDK help file) and a demo version of EMS IBManag=
er to define the database.
The relevant DDL statements to give context to my question are tagged-on =
at the end.
I've got a 'new customer' form in a c# windows forms app. The form has a =
command which passes its parameters to a stored procedure. The parameter =
matches the stored procedure in size/type - ie VARCHAR (255).
Ok. at last, to the question.. :)
I've noticed that I'm able to assign a string of length 765 or less to th=
e parameter which then somehow makes it through the stored procedure's 25=
5 character limit and into the database table. How is this possible? Sure=
ly the table (not to mention the SP) should only allow 255 unicode charac=
ters to be stored, despite the fact that it may have a limit of 765 bytes=
?
Any pointers would be appreciated.
--
CREATE TABLE CUSTOMERS (
CUSTOMER_ID INTEGER NOT NULL,
NAME VARCHAR (255) CHARACTER SET UNICODE_FSS NOT NULL COLLATE UNICOD=
E_FSS);
CREATE PROCEDURE NEWCUSTOMER (
CUST_NAME VARCHAR (255))
RETURNS (
NEW_ID INTEGER,
SUCCESS INTEGER)
AS
BEGIN
/* Procedure body */
SUCCESS =3D 1;
NEW_ID =3D GEN_ID(CUSTOMERS_CUSTOMER_ID_GEN, 1);
INSERT INTO CUSTOMERS (CUSTOMER_ID, NAME)
VALUES (:NEW_ID, :CUST_NAME);
WHEN ANY DO SUCCESS =3D 0;
END
|
|
From:
<car...@te...> - 2004-03-13 13:44:16
|
Hello: > What is the method for creating a DB programatically. I cant figure out > what the connection string should be. Review the FbConnection.CreateDatabase method. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Bob L. <bo...@ta...> - 2004-03-13 13:26:33
|
Carlos: What is the method for creating a DB programatically. I cant figure out = what the connection string should be.=20 Thanks Bob |
|
From:
<car...@te...> - 2004-03-13 13:03:14
|
Hello: > Let's say there are two tables - first has an unique identifier and second > uses these ID as foreign key. All data are entered without connection to > server on field, and data should be updated to server in the evening (there > is no way to be connected to server during day). > Does DataAdapter localy make unique identifiers (on server defined with > triggers/generators)? No, and i'm not sure that the SqlDataAdapter will do that, i will try to do a test next week using MSDE. > Is that possible using Firebird .NET provider? I am asking it because that's > one of examples I heard on Microsoft ADO.NET training session. There are online information about that session ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-03-13 10:16:12
|
Hello: > When I install the FirebirdNETProvider1.5-NET1.1 I have following problem:- > The application has failed to start because MSVCR70.dll was not found. Can you try using the 1.5.1 ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: weng <cw...@tm...> - 2004-03-13 01:28:03
|
Hi,
Anyone familiar with following error? ?
Compiler Error Message:
CS1595: 'FirebirdSql.Data.Firebird.FbConnection' is defined in multiple places; using definition from 'C:\WINDOWS\assembly\GAC\FirebirdSql.Data.Firebird\1.6.1524.24952__e1b4f92304d7b12f\FirebirdSql.Data.Firebird.dll'
I have this error while trying to declare the variable
FbConnection myConnection;
using C#...
and I did include lib:-
<%@ Page Language="C#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="FirebirdSql.Data.Firebird" %>
and I check my web.config
<assemblies>
<add assembly="FirebirdSql.Data.Firebird, Version=1.6.1524.24952, Culture=neutral, PublicKeyToken=e1b4f92304d7b12f" />
</assemblies>
where the version and PublicKeyToken is same compare in my C:\WINDOWS\assembly.. why ? Thks
regards,
weng
|
|
From: weng <cw...@tm...> - 2004-03-13 01:20:39
|
Hi, When I install the FirebirdNETProvider1.5-NET1.1 I have following problem:- The application has failed to start because MSVCR70.dll was not found. RE-installing the application may fix this problem. cannot register assembly FirebirdSql.Data.Firebird. I tried the solution of copying msvcr70.dll in C:\Windows\SYSTEM32\URTTemp to C:\Windows\Microsoft.NET\Framework\v1.0.3705 after that I tried re-install but still fail ... my msvcr70.dll is about 336kb on Xp platform. Anyone knows why? Or how to solve it ? Thks regards, Weng |
|
From: Dmitry A. <fd...@ua...> - 2004-03-12 15:14:07
|
Hello Carlos, Friday, March 12, 2004, 4:48:56 PM, you wrote: >> Some peoples doing lock with >> pk+timestamp+username_what_set_lock :) CGÁ> And another people will do this in another way ;) but i want to mantain CGÁ> the compatibility with other .NET providers ;) compatibility from this and does not damage if contribute new importance in CommandBehaivour, for activation use this field :-) CGÁ> For now i will do the implementation as i described in the other email. It's fine! :) -- Best regards, Dmitry mailto:fd...@ua... |
|
From: Dmitry A. <fd...@ua...> - 2004-03-12 15:10:11
|
Hello Carlos,
Friday, March 12, 2004, 4:45:09 PM, you wrote:
>> create table t1(
>> t1 timestamp,
>> t2 timestamp,
>> t3 timestamp
>> );
>> ??? :-)
>> why not? :)
CGÁ> Huummm but you mean to use 3 three fields for concurrency control ??
no, this gipoteticheski. for instance person have 2 importances
with stamp of time happened event :-) and one for concurrency...
:-)
--
Best regards,
Dmitry mailto:fd...@ua...
|
|
From:
<car...@te...> - 2004-03-12 14:59:46
|
Hello: > Some peoples doing lock with pk+timestamp+username_what_set_lock :) And another people will do this in another way ;) but i want to mantain the compatibility with other .NET providers ;) For now i will do the implementation as i described in the other email. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-03-12 14:56:10
|
Hello: > create table t1( > t1 timestamp, > t2 timestamp, > t3 timestamp > ); > ??? :-) > why not? :) Huummm but you mean to use 3 three fields for concurrency control ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Dmitry A. <fd...@ua...> - 2004-03-12 14:13:22
|
Hello Carlos,
Friday, March 12, 2004, 3:44:53 PM, you wrote:
>>>4. Key and timestamp ( That if i'm not worng works only for Sql Sever)
>> Not wrong, but some-time peoples can use this method and in Firebird
>> too... for example if on timestamp field creates trigger...
CGÁ> I do that, checking a field in a before update trigger ;)
Logistical :) But way "Key and timestamp" shall leave :-) :-)
>> I'm don't like fixed things too... but TIMESTAMP fields can be more
>> than 1,
CGÁ> Don't see why use more than one for this ¿?¿? ;)
create table t1(
t1 timestamp,
t2 timestamp,
t3 timestamp
);
??? :-)
why not? :)
the sense itself do not see (but review beside who what
problems) :) in principle if field will be chosen -- fine. if
will first/last in table -- too live very possible... :-)
--
Best regards,
Dmitry mailto:fd...@ua...
|
|
From: Dmitry A. <fd...@ua...> - 2004-03-12 14:07:11
|
Hello Carlos, Friday, March 12, 2004, 3:41:52 PM, you wrote: >> builder.FieldsToCheck = "myprimarykey,mytimestamp"; CGÁ> Huummm i don't see this as needed ... Some peoples doing lock with pk+timestamp+username_what_set_lock :) I consider that this it is enough exclusive event, and real need in him presently no. Yes, this was not bad -- universal generation of the field where even for undefined behaivor ;). But I consider that presently this possible not to do. :) -- Best regards, Dmitry mailto:fd...@ua... |
|
From: JS.staff <jsp...@ec...> - 2004-03-12 14:06:51
|
Well, just thought instead of fixing people to using pk, or = pk+timestamp, or all, you could allow them to choose which fields to = check - for whatever reason they choose. Maybe someone would want to use a integer 'generation' value instead of = a timestamp to control concurrency, for example. So the trigger would = have something like Before update trigger: genfield =3D gen_id(gennumber,1); And they you'd do: Update mytable set xxxx where pk =3D @mypk and genfield =3D @genfield John -----Original Message----- From: Carlos Guzm=E1n =C1lvarez [mailto:car...@te...]=20 Sent: 12 March 2004 13:42 To: JS.staff Cc: firebird-net-provider Subject: Re: [Firebird-net-provider] FbCommandBuilder - where's clause = rule[Scanned] Hello: > That sounds great - how about a collection of field names in the=20 > FbCommandBuilder specifying the fields to check?? That way we could=20 > choose to use a generator instead of a timestamp. >=20 > builder.FieldsToCheck =3D "myprimarykey,mytimestamp"; Huummm i don't see this as needed ... -- Best regards Carlos Guzm=E1n =C1lvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-03-12 13:59:51
|
Hello:
> 3. <assemblies>
> <add assembly="FirebirdSql.Data.Firebird"/>
> </assemblies>
> - not work on both example
> where my samples are on C:\Program
> Files\FirebirdNETProvider1.5\examples\ASP.NET\bin, that bin have file
> FirebirdSql.Data.Firebird.dll
> [Err: File or assembly name FirebirdSql.Data.Firebird, or one of its
> dependencies, was not found ]
Well seems that you have anything bad but i don't know what, i have this
in my web.config file:
<compilation>
<assemblies>
<add assembly="FirebirdSql.Data.Firebird" />
</assemblies>
</compilation>
The ASP.NET samples directory has the VB.NET and C# samples, the
web.config file and a bin directory with the .NET provider assembly and
runs fine.
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
|
|
From:
<car...@te...> - 2004-03-12 13:55:47
|
Hello: >>4. Key and timestamp ( That if i'm not worng works only for Sql Sever) > > Not wrong, but some-time peoples can use this method and in Firebird > too... for example if on timestamp field creates trigger... I do that, checking a field in a before update trigger ;) > I'm don't like fixed things too... but TIMESTAMP fields can be more > than 1, Don't see why use more than one for this ¿?¿? ;) -- Best regards Carlos Gyuzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-03-12 13:52:45
|
Hello: > That sounds great - how about a collection of field names in the > FbCommandBuilder specifying the fields to check?? That way we could > choose to use a generator instead of a timestamp. > > builder.FieldsToCheck = "myprimarykey,mytimestamp"; Huummm i don't see this as needed ... -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Dmitry A. <fd...@do...> - 2004-03-12 13:39:41
|
"JS.staff" wrote:
> That sounds great - how about a collection of field names in the
> FbCommandBuilder specifying the fields to check?? That way we could
> choose to use a generator instead of a timestamp.
>
> builder.FieldsToCheck =3D "myprimarykey,mytimestamp";
I thinking about this too, but current we have mode with automatic
primary key selecting... :-)
In best case, my opinion:
if FieldsToCheck empty -- use Behaivor (AllFields or no...)
or
to FbCommandBehaivor add new mode -- ListFields or similar... :)
|
|
From: Dmitry A. <fd...@do...> - 2004-03-12 13:35:59
|
Carlos Guzmán Álvarez wrote: > Default > AllFields > KeyFields > KeyAndTimeStampFields Yes :-) > 4. Key and timestamp ( That if i'm not worng works only for Sql Sever) Not wrong, but some-time peoples can use this method and in Firebird too... for example if on timestamp field creates trigger... in this case it's will work as AllFields, with that difference that request will have a more good plan for execution. :) > > The fourth variant -- WHERE is generated on primary key fields > > > and > field with fixed-name (for example "TIMESTAMP" or > > "LAST_MODIFIED"). > As i don't like fixed things ;) if i do this i will add a property > for this ( aand provide a default value for it, of course ) I'm don't like fixed things too... but TIMESTAMP fields can be more than 1, and may be selects this uniquely impossible. My opinion -- add a property, that have dafault value (empty?) -- auto search TIMESTAMP field?! ;-) Opinions ???? |
|
From: JS.staff <jsp...@ec...> - 2004-03-12 13:24:11
|
That sounds great - how about a collection of field names in the FbCommandBuilder specifying the fields to check?? That way we could choose to use a generator instead of a timestamp. builder.FieldsToCheck =3D "myprimarykey,mytimestamp"; John -----Original Message----- > Opinions ??? The fourth variant -- WHERE is generated on primary key fields and field with fixed-name (for example "TIMESTAMP" or "LAST_MODIFIED"). =20 ------------------------------------------------------- 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=3D1470&alloc_id=3D3638&op=3Dcli= ck _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
211 messages has been excluded from this view by a project administrator.
