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: Julien F. <jfk...@ne...> - 2004-05-18 04:13:50
|
On Mon, 17 May 2004 13:12:49 +0000 (UTC), Carlos Guzmán Álvarez wrote: > Hello: > Sorry seems that i understand bad. > > The Server Explrer works only with OleDb drivers. OK So do have to do EVERYTHING by code or is there a way to use components like Delphi's TDataSet ? Where can I find a good tutorial for ADO.Net (or, even better, for Firebird with ADO.Net) ? TIA Julien |
|
From:
<car...@te...> - 2004-05-17 13:33:30
|
Hello: >When i go to server explorer, I click on the "Connect to database button". >I get the window that will create a connection. In the first tab (i guess >in english the tab name shoulb de "Provider") there is a list of all >possible connection type (Microsoft OleDB Simple Provider, Microsoft Jet >4.0 OLE DB Provider, ...) but Firebird doesn't appear in that list. > >I tried what is said in the article you recommened to me but it doesn't do >anything better. > >Any idea ? > Sorry seems that i understand bad. The Server Explrer works only with OleDb drivers. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Julien F. <jfk...@ne...> - 2004-05-17 13:26:46
|
On Mon, 17 May 2004 08:36:16 +0000 (UTC), Carlos Guzmán Álvarez wrote: > Hello: > >>I'm new to Visual Studio, I come from Delphi. >>I downloaded and installed Firebird .Net Provider 1.6-Beta3 for .Net 1.1 >> >>When I run Visual Studio .Net 2003, I don't see Firebird when I try to >>create a new connection. >> >>What do I have to do ? >> > Review this: > > http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B306149 Carlos, When i go to server explorer, I click on the "Connect to database button". I get the window that will create a connection. In the first tab (i guess in english the tab name shoulb de "Provider") there is a list of all possible connection type (Microsoft OleDB Simple Provider, Microsoft Jet 4.0 OLE DB Provider, ...) but Firebird doesn't appear in that list. I tried what is said in the article you recommened to me but it doesn't do anything better. Any idea ? Julien |
|
From:
<car...@te...> - 2004-05-17 11:42:53
|
Hello:
I have committed today some changes:
* Added new Error codes (To resource file and IscCodes class)
* Fixed most of the Globalization isssues reported by FxCop.
* Simplified Numeric/Decimal handling.
The Nunit test suite is running fine for me and i will try to
make ore tests running the AS3AP benchmark and using the IssueTracker
with the CVS version.
I hope to release the 1.6 RC1 this weekend and more than probably
the Alpha 1 of the Borland Data Provider.
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
|
|
From:
<car...@te...> - 2004-05-17 09:03:26
|
Hello: >I'm new to Visual Studio, I come from Delphi. >I downloaded and installed Firebird .Net Provider 1.6-Beta3 for .Net 1.1 > >When I run Visual Studio .Net 2003, I don't see Firebird when I try to >create a new connection. > >What do I have to do ? > Review this: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B306149 -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-05-17 09:01:51
|
Hello: > After I tried to install the > FirebirdNETProvider1.6-Beta3-NET1.1.exe, I can't install back any of > the version other than this e.g. FirebirdNETProvider1.6-Beta2-NET1.1.exe > and FirebirdNETProvider1.6-Beta1-NET1.1.exe. > I always get this error: > > File or assembly name FirebirdSql.Data.Firebird, or one of its > dependencies, was not found > ..... > LOG: DisplayName = FirebirdSql.Data.Firebird, > Version=1.6.1587.18323, Culture=neutral, PublicKeyToken=e1b4f92304d7b12f > (Fully-specified) > regardless of the Version I install are actually 1.6.1573 or others ... Huumm have you uninstalled the existent version before install the new one ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Julien F. <jf...@ne...> - 2004-05-17 08:04:28
|
Hello I'm new to Visual Studio, I come from Delphi. I downloaded and installed Firebird .Net Provider 1.6-Beta3 for .Net 1.1 When I run Visual Studio .Net 2003, I don't see Firebird when I try to create a new connection. What do I have to do ? Julien |
|
From: benny <be...@ch...> - 2004-05-17 07:46:23
|
Hi, After I tried to install the FirebirdNETProvider1.6-Beta3-NET1.1.exe, = I can't install back any of the version other than this e.g. = FirebirdNETProvider1.6-Beta2-NET1.1.exe and FirebirdNETProvider1.6-Beta1-NET1.1.exe.=20 I always get this error: File or assembly name FirebirdSql.Data.Firebird, or one of its = dependencies, was not found ..... LOG: DisplayName =3D FirebirdSql.Data.Firebird, = Version=3D1.6.1587.18323, Culture=3Dneutral, = PublicKeyToken=3De1b4f92304d7b12f (Fully-specified) =20 regardless of the Version I install are actually 1.6.1573 or others = ... TIA regards, benny ;) |
|
From:
<car...@te...> - 2004-05-14 20:56:47
|
Hello: >Corrects the problem and also returns null if the user is not valid. > Fixed in CVS, thanks very much -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-05-14 20:55:54
|
Hello: >I've attached a new version of the function (with the original code >commented out) that fixes the problem and is also faster when there are >a lot of users defined on the system by replacing the array >reallocation and copy with a Queue. > Fixed in CVS, but in a different way than the exposed in your patch, it will be using an ArrayList now, i will apply the fix in the 1.5 sources as well. Thanks very much. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Todd <pal...@ya...> - 2004-05-14 20:18:52
|
The FbSecurity object (FbSecurity.cs) has a bug in the DisplayUser() function. The second last line of the function is: FbUserData userData = (FbUserData)info[0]; This throws and InvalidCastException because info[0] is an array of FbUserData objects, not an FbUserData object. Replacing the last two lines with: FbUserData[] users = (FbUserData[])info[0]; return users.Length > 0 ? (FbUserData)users[0] : null; Corrects the problem and also returns null if the user is not valid. Todd |
|
From: Maurita V. <crf...@ne...> - 2004-05-14 12:36:23
|
whinyard presume chancellor homophobic coleus allowed calvinist eroded intimal actinoid cascara occasionem |
|
From: Bess M. <tas...@mb...> - 2004-05-14 01:33:59
|
pholas stilton enlist navarch agitur anemometer lazzarone lakshmi orions brahimism exercise damon |
|
From:
<car...@te...> - 2004-05-13 21:49:20
|
Hello:
>When I attempt to run the code through the debugger,
>ExecuteNonQuery always returns -1. In addition, I get
>the following error in the CommandPlan property of the
>FbCommand:
>
ExecuteNonQuery will return anything different than -1 only for
insert, deletes and updates, you should be committing the transaction
without having that value into account (in this case, of course ;)).
>CommandPlan <error: an exception of type:
>{System.ArgumentOutOfRangeException} occurred>
>
I will review it.
>Is creating/altering tables not currently supported in
>the .NET provider?
>
Yes it's (for example, the NUnit test suite creates a database from scratch)
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
|
|
From:
<car...@te...> - 2004-05-13 21:03:36
|
Hello: >Anyone succesfully using the .Net provider to do batch / DDL execution? >I'd appreciate any tips / sample code. > >I tried the FbScript / FbBatchExecution route, which is workable after >I fixed about 5 bugs in the parsing. I'd rather not have to parse the >SQL client side (that's what the server does). > This needs to be done using that classes but the mantainer has some commits pending, i will try to contact him and if he can't commit the changes i will try to fix them. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Timothy S. <tim...@ya...> - 2004-05-13 20:51:20
|
Hi,
I cannot seem to use the NET provider to create and
alter tables. Here is the code:
string sqlstring = "create table testtable (testid int
not null primary key)"
FbTransaction txn = null;
try
{
FbConnection conn = new FbConnection(connString);
txn = conn.BeginTransaction();
cmd.Connection = conn;
cmd.CommandText = sqlstring;
cmd.Transaction = txn;
int records_affected = cmd.ExecuteNonQuery();
#if FB_DEBUG FbDbFactory.Log("Executing the
following Query: ");
FbDbFactory.Log(cmd.CommandText);
#endif
if(records_affected > 0) {
txn.Commit();
}
else
{
txn.Rollback();
}
return records_affected;
}
catch (Exception e)
{
FbDbFactory.LogException(e);
return -1;
}
finally
{
pconn.Available = true;
CleanupResources(ref cmd, ref txn);
}
When I attempt to run the code through the debugger,
ExecuteNonQuery always returns -1. In addition, I get
the following error in the CommandPlan property of the
FbCommand:
CommandPlan <error: an exception of type:
{System.ArgumentOutOfRangeException} occurred>
This also occurs when trying to execute the following
command on an existing table: "alter table testtable
add temp_no varchar(50)". Note that both of these sql
statements work through isql.
Is creating/altering tables not currently supported in
the .NET provider?
-Tim
__________________________________
Do you Yahoo!?
Yahoo! Movies - Buy advance tickets for 'Shrek 2'
http://movies.yahoo.com/showtimes/movie?mid=1808405861
|
|
From: Todd <pal...@ya...> - 2004-05-13 19:25:14
|
Anyone succesfully using the .Net provider to do batch / DDL execution? I'd appreciate any tips / sample code. I tried the FbScript / FbBatchExecution route, which is workable after I fixed about 5 bugs in the parsing. I'd rather not have to parse the SQL client side (that's what the server does). I tried multiple SQL statements in a FbCommand using ExecuteReader() and reader.NextResult(), which fails for stored procedures and triggers with "Error 104 unexpected end of command" w/o using the SET TERM syntax and fails with "unknown token" using the SET TERM syntax. FbCommand.ExecuteNonQuery() works for a single stored proc or trigger, but not a script. Thoughts? Todd |
|
From:
<car...@te...> - 2004-05-13 18:42:33
|
Hello: >What I must to do after install fb.net. >If a try to reference firebirdsql.... there is not in the list. > Visual Studio .NET doesn't show all the assemblies installed in the cache, huummm i have lost the link of the MS Knownledge base that explains this but you can seach the list for it (if anybody has it please post it here :)). -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-05-13 16:39:35
|
Hello:
>One solution would be to set the DataSourceSet = true if the Database
>connection string parameter is set, since parseConnectionInfo() is
>searching for this parameter also and Database is the only other
>required connection string option besides user and passord.
>
Thanks, it should be fixed now in CVS.
The problem is that the Database an have different formats:
dataSource/portNumber:databasePath
//dataSource:portNumber/databasePath
Maybe i will try to use RegEx here :)
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
|
|
From: Guillermo <gu...@wo...> - 2004-05-13 16:01:29
|
What I must to do after install fb.net. If a try to reference firebirdsql.... there is not in the list. Thank you in advance Guillermo |
|
From: Guillermo <gu...@wo...> - 2004-05-13 15:59:48
|
Well, Now I have install correctly .net data provider. First: I was reinstall framework 1.0 |
|
From: Todd <pal...@ya...> - 2004-05-13 15:42:12
|
There is a bug in the parsing of connection strings in AttachementParams.parseConnectionString() ( AttachmentParams.cs ). The problem is if you don't specify a DataSource in your connection string, which according to the docs is valid and should default to "localhost". parseConnectionString() will call parseConnectionInfo() if the DataSource is not set, returning invalid properties for the database connection. Example: // Datasource should default to 'localhost' string cs = "Database=C:\test.fdb;Password=masterkey;User=SYSDBA"; FbConnection conn = new FbConnection(cs); conn.Open(); Results in: FirebirdSql.Data.Firebird.FbException: Unable to complete network request to host "C". at FirebirdSql.Data.Firebird.FbDbConnection.Connect() at FirebirdSql.Data.Firebird.FbConnection.Open() One solution would be to set the DataSourceSet = true if the Database connection string parameter is set, since parseConnectionInfo() is searching for this parameter also and Database is the only other required connection string option besides user and passord. Todd |
|
From: Guillermo <gu...@wo...> - 2004-05-13 14:37:55
|
Hello Carlos, I have 1.0 (spanish). What can I do? Do you speak spanish? My english is not good > Huummm do you have .NET Framework 1.0 or 1.1 ?? (Sorry for the stupid > question, but if i remember well installers are correct) > > > > > > > -- > Best regards > > Carlos Guzm=C3=A1n =C3=81lvarez > Vigo-Spain |
|
From: Carlos G.A. <car...@te...> - 2004-05-13 14:23:31
|
Hello: > I can not install .net data provider becouse i get the next error: > "You need to have installed the microsoft .net framework 1.0 before insta= ll > the firebird .net data provider" > And I have installed a 1.0 (spanish) > How can I do to install? > Thank you in advance. Huummm do you have .NET Framework 1.0 or 1.1 ?? (Sorry for the stupid question, but if i remember well installers are correct) -- Best regards Carlos Guzm=C3=A1n =C3=81lvarez Vigo-Spain |
|
From: Guillermo <gu...@wo...> - 2004-05-13 14:19:00
|
I can not install .net data provider becouse i get the next error: "You need to have installed the microsoft .net framework 1.0 before install the firebird .net data provider" And I have installed a 1.0 (spanish) How can I do to install? Thank you in advance. Guillermo |
211 messages has been excluded from this view by a project administrator.
