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

Re: [Firebird-net-provider] Strange character problem with beta4? (v.1.5.1410.16587)

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

Hello:

> When I insert this string: string t = "@123";  in my database,
> only a "?" is appear in the database.

Thew @ is used inside the command text for denote a named parameter, 
named parameters detection is made using regular expressions: at this 
moment this the regex used:

(@{1}\w+)

in beta 2 it was:

(@([a-zA-Z-$][a-zA-Z0-9_$]*))


But it's not handling ok the @ wen it appears inside '', if anybody
knows how to modify it for handle ok this case i will be more than
happy of modify it :)



You can use parametrized querys for solve the problem.


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Strange character problem with beta4? (v.1.5.1410.16587)

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

Thomas wrote:
> When I insert this string: string t = "@123";  in my database,
> only a "?" is appear in the database.

Hello Thomas,

This is just an educated guess, but the Firebird ADO.NET provider
uses @xxx to denote a parameter (FbParameter) in an FbCommand
object.

I guess you should get an exception telling you that 123 is not
a valid parameter attached to the FbCommand object.

Maybe Carlos will comment on this ?

Kind regards.

    Pierre

[Firebird-net-provider] Strange character problem with beta4? (v.1.5.1410.16587)

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

When I insert this string: string t =3D "@123";  in my database,=20
only a "?" is appear in the database.

When I retrive the value,  I altso get a "?".

Why are the "@" convertet to a "?"......
And why are everything after the "@" erased......


This problem only arise when I use Beta4 (v. 1.5.1410.16587).

When I use beta2 (1.5.1356.23155) the whole string is insertet correct =
in the database ("@123").


My code:

.......

string t =3D "@123";=20
FB.insert("INSERT INTO TABLE1 (COL1) VALUES ( " + "'" + t + "'" + ")");
......


.........
private string myConnectionString =3D "Database=3D" + "c:\\TEST.GDB" + =
";User=3D" + "SYSDBA" + ";Password=3D" + "masterkey" + ";Dialect=3D" + 1 =
+ ";Charset=3D" + "NONE" + ";Server=3D" + "localhost";
...............


..........
public bool insert(string myInsertQuery)

{

try

{

transaction =3D myConnection.BeginTransaction();

myCommandOne =3D new FbCommand(myInsertQuery, myConnection, =
transaction);=20

myCommandOne.ExecuteNonQuery();


transaction.Commit();

myCommandOne.Dispose();=20

}

catch(Exception ea)

{

ea =3D ea;

throw new Exception(ea.Message);

}//try/catch

return true;

}
.....................



my table:
CREATE TABLE TABLE1
(
  COL1              VARCHAR(    55)
);



I use:
WinXP PRO SP1
.NET 1.1
Firebird-1.5.0.4027-RC7 as SuperServer



Regards
Thomas

Re: [Firebird-net-provider] FB backup gives error Server: WIN XP Home Edition

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

Hello:

>FB .NEt Prov 1.5 for .NET 1.1 Beta 4
>RC6 installed as classic server.
>
>Cant figure out problem :(
>  
>

I have made a test using RC7 installed as CS and it works for me, the 
only difference is that i'm using the sources from CVS of the .NET data 
Provider





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FB backup gives error Server: WIN XP Home Edition

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

Hello:

> RC6 installed as classic server.

I have tested it only with Super Server ;) i'm not sure what is the 
exact status of the services API in Classic Server ( i'm going to try to 
reinstall firebird as CS and give a try to the services api 
implementation in the .net provider using the nunit test suite)




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] FB backup gives error Server: WIN XP Home Edition

[Samrat G. <sg...@he...>]

Hi Carlos,

FB .NEt Prov 1.5 for .NET 1.1 Beta 4
RC6 installed as classic server.

Cant figure out problem :(

sguha


------------------------


From: <carlosga@te...>
 Re: FB backup gives error Server: WIN XP Home Edition
2003-11-18 00:00
 Hello:

 > Same problem on XP Home with Backup !!!!

 I'm in XP too.

 > Config: FB1.5 RC6 / .NET Prov 1.1 Beta 4
 > ServerOS: WINXP Home

 Installed as Classic Server or as Super Server ??

  > .NET Prov 1.1 Beta 4

 1.5 Beta 4 ??



 --
 Best regards

 Carlos Guzmán Ávarez
 Vigo-Spain


------------------
Hi Carlos,

 Same problem on XP Home with Backup !!!!

 Config: FB1.5 RC6 / .NET Prov 1.1 Beta 4
 ServerOS: WINXP Home

 Code:

 Dim bkup as FbBackup
 bkUp = New FbBackup()
 bkUp.UserName = "sysdba"
 bkUp.UserPassword = "masterkey"
 bkUp.Database = "x:\fb\test.fdb"
 bkUp.BackupFiles.Add(New FbBackupFile("x:\fb\backups\test.fbk")
 bkUp.ServerName = "localhost"
 bkUp.Options = FbBackupFlags.IgnoreLimbo

 bkUp.Start()   ********** generates error  "No message for code 472
found.No
 message for code 243 found."
 bkUp.Close()


 Surprisingly changing SERVER OS to "Win 2000" Pro eliminates the problem.
 Is there something wrong using "WIN XP home" as the server OS?


 Regards,
 sguha.

Re: [Firebird-net-provider] VBNETExample.aspx

[Norbert S. G. <No...@Te...>]

sorry
it is necessary to use version 1.1.1266.28704 and then that functions

Norbert

-- 
Le Delphinaute

Le groupe de .be pour Delphi sur .net
news://news.delphinaute.be

[Firebird-net-provider] VBNETExample.aspx

[Norbert S. G. <No...@Te...>]

Hello,

Always on is server 2k3, the name ambiguous in the space of name?

An idea?

Norbert


--------------------------------------------------------------------------------

Erreur de compilation

Message d'erreur du compilateur: BC30560: 'FBConnection' est ambigu 
dans l'espace de noms 'FirebirdSql.Data.Firebird'.

Erreur source:



Ligne 11 :
Ligne 12 :     Dim public shared myConnectionString As String
Ligne 13 :     Dim public shared myConnection As FBConnection
Ligne 14 :     Dim public shared myTxn As FbTransaction
Ligne 15 :     Dim public shared selectCmd As String


Fichier source: c:\inetpub\wwwroot\VBNETExample.aspx    Ligne: 13


--------------------------------------------------------------------------------
Informations sur la version : Version Microsoft .NET Framework 
:1.1.4322.573; Version ASP.NET :1.1.4322.573

-- 
Message généré par MesNews

Re: [Firebird-net-provider] Error message ?

[Norbert S. G. <No...@Te...>]

Après mure réflexion, "Carlos Guzmán Álvarez" a écrit :
> The Version and the PublicKeyToken are the same as you get if you review the 
> assembly in the GAC ?? ( if not you need to modify them )

Exact, it was that the problem
Thank you

-- 
Message généré par MesNews

Re: [Firebird-net-provider] Character set troubles

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

Hello:

> Disclaimer paragraph: (If reading disclaimers is boring for you, please
> skip). 1. I must re-state that my exposure to .net is rather limited
> (only writing small test programs, only using mono, speed-reading tons
> of articles on MSDN. 2. I'll have a busy week with my day job, and
> if time is left for FB, I'll have to look into the "index key too big
> (174)" issue, as I'm more competent there.

No problem.

> In theory, C should be some flavour of Unicode,
> but as your tests seem to indicate, this doesn't
> work allways.

Yes, this seems to be not an option .




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Error message ?

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

Hello:

> Ligne 22 :         <compilation>
> Ligne 23 :             <assemblies>
> Ligne 24 :                 <add assembly="FirebirdSql.Data.Firebird, 
> Version=1.5.1334.34352, Culture=neutral, 
> PublicKeyToken=e1b4f92304d7b12f" />
> Ligne 25 :             </assemblies>
> Ligne 26 :         </compilation>

The Version and the PublicKeyToken are the same as you get if you review 
the assembly in the GAC ?? ( if not you need to modify them )





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Error message ?

[Norbert S. G. <No...@Te...>]

Hello,

I have the same problem on w2k3 Fr and xp pro Fr + webmatrix, simply  
with the examples provided with the rc4
what do I have to make?

<
Erreur de configuration
Description : Une erreur s'est produite lors du traitement d'un fichier 
de configuration requis pour répondre à cette demande. Veuillez 
consulter ci-dessous les détails relatifs à l'erreur en question, puis 
modifier votre fichier de configuration de manière appropriée.

Message d'erreur de l'analyseur: La définition trouvée du manifeste de 
l'assembly qui porte le nom 'FirebirdSql.Data.Firebird' ne correspond 
pas à la référence de l'assembly.

Erreur source:


Ligne 22 :         <compilation>
Ligne 23 :             <assemblies>
Ligne 24 :                 <add assembly="FirebirdSql.Data.Firebird, 
Version=1.5.1334.34352, Culture=neutral, 
PublicKeyToken=e1b4f92304d7b12f" />
Ligne 25 :             </assemblies>
Ligne 26 :         </compilation>


Fichier source : c:\inetpub\wwwroot\web.config    Ligne : 24

Suivi du chargement de l'assembly: Les informations suivantes peuvent 
permettre de déterminer la raison pour laquelle l'assembly 
'FirebirdSql.Data.Firebird' n'a pas pu être chargé.


=== Pre-bind state information ===
LOG: DisplayName = FirebirdSql.Data.Firebird, Version=1.5.1334.34352, 
Culture=neutral, PublicKeyToken=e1b4f92304d7b12f
 (Fully-specified)
LOG: Appbase = file:///c:/inetpub/wwwroot
LOG: Initial PrivatePath = bin
Calling assembly : (Unknown).
===

LOG: Publisher policy file is not found.
LOG: No redirect found in host configuration file 
(C:\W2K3FR\Microsoft.NET\Framework\v1.1.4322\aspnet.config).
LOG: Using machine configuration file from 
C:\W2K3FR\Microsoft.NET\Framework\v1.1.4322\config\machine.config.
LOG: Post-policy reference: FirebirdSql.Data.Firebird, 
Version=1.5.1334.34352, Culture=neutral, 
PublicKeyToken=e1b4f92304d7b12f
LOG: Attempting download of new URL 
file:///C:/W2K3FR/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET 
Files/root/2135a508/8d69a834/FirebirdSql.Data.Firebird.DLL.
LOG: Attempting download of new URL 
file:///C:/W2K3FR/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET 
Files/root/2135a508/8d69a834/FirebirdSql.Data.Firebird/FirebirdSql.Data.Firebird.DLL.
LOG: Attempting download of new URL 
file:///c:/inetpub/wwwroot/bin/FirebirdSql.Data.Firebird.DLL.
WRN: Comparing the assembly name resulted in the mismatch: Minor 
Version




--------------------------------------------------------------------------------
Informations sur la version : Version Microsoft .NET Framework 
:1.1.4322.573; Version ASP.NET :1.1.4322.573

>

Norbert

-- 
Message généré par MesNews

Re: [Firebird-net-provider] FB backup gives error Server: WIN XP Home Edition

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

Hello:

> Same problem on XP Home with Backup !!!!

I'm in XP too.

> Config: FB1.5 RC6 / .NET Prov 1.1 Beta 4
> ServerOS: WINXP Home

Installed as Classic Server or as Super Server ??

 > .NET Prov 1.1 Beta 4

1.5 Beta 4 ??



--
Best regards

Carlos Guzmán Ávarez
Vigo-Spain

[Firebird-net-provider] FB backup gives error Server: WIN XP Home Edition

[Samrat G. <sg...@he...>]

Hi Carlos,

Same problem on XP Home with Backup !!!!

Config: FB1.5 RC6 / .NET Prov 1.1 Beta 4
ServerOS: WINXP Home

Code:

Dim bkup as FbBackup
bkUp = New FbBackup()
bkUp.UserName = "sysdba"
bkUp.UserPassword = "masterkey"
bkUp.Database = "x:\fb\test.fdb"
bkUp.BackupFiles.Add(New FbBackupFile("x:\fb\backups\test.fbk")
bkUp.ServerName = "localhost"
bkUp.Options = FbBackupFlags.IgnoreLimbo

bkUp.Start()   ********** generates error  "No message for code 472 found.No
message for code 243 found."
bkUp.Close()


Surprisingly changing SERVER OS to "Win 2000" Pro eliminates the problem.
Is there something wrong using "WIN XP home" as the server OS?


Regards,
sguha.

[Firebird-net-provider] Re: FbConfigurationManager Class

[Samrat G. <sg...@he...>]

Hi again,

I was concerned with the OS, XP fails (  conf.Open();) but win 2000 works
fine.

Regards
sguha.



--------------------
Hi Carlos,

 I am using FB 1.5 RC6 with WIN 2000 Pro.
 I have used FbConfiguration Class (Firebird.NET 1.1 Beta 3) in my .NET
 application.

 Private conf As FbConfiguration
 conf = New FbConfiguration()
 conf.Database = "x:\xx\xx.fdb"
 conf.UserName = "sysdba"
 conf.UserPassword = "masterkey"
 conf.ServerName = "som.e.i.p"


 Problem is with this line of code:

 "If Not conf.State = FbServiceState.Open Then conf.Open()"
 .....
 .....
 conf.DatabaseShutdown(FbShutdownMode.Forced, 5)

 The strangeness is that in Win 2000 Pro with FB 1.5 rc6 and (Firebird.NET
 1.1 Beta 3)
 there is no error.

 But the moment I change my OS to Win XP Home Edition - rest configs same,
 this error appears.

 "No message for code 472 found.No message for code 243 found."

 Can you help me why this error is occurring in WIN XP home edition?

 Regards,
 sguha.






From: <carlosga@te...>
 Re: FbConfigurationManager Class
2003-11-17 00:30
 Hello:

 > I am using FB 1.5 RC6 with WIN 2000 Pro.
 > I have used FbConfiguration Class (Firebird.NET 1.1 Beta 3) in my .NET
 > application.
 >
 > Private conf As FbConfiguration
 > conf = New FbConfiguration()
 > conf.Database = "x:\xx\xx.fdb"
 > conf.UserName = "sysdba"
 > conf.UserPassword = "masterkey"
 > conf.ServerName = "som.e.i.p"


 I have made a little test and seems to work ( version 1.5 from CVS
 against Firebird 1.5 RC7 ), the code ( tell to me if it's correct ):

             FbConfiguration conf = new FbConfiguration();

             conf.Database = @"TESTDB.GDB";
             conf.ServerName = "localhost";
             conf.UserName = "sysdba";
             conf.UserPassword = "masterkey";

             if (conf.State != FbServiceState.Open)
             {
                 conf.Open();
             }

             conf.DatabaseShutdown(FbShutdownMode.Forced, 5);




 --
 Best regards

 Carlos Guzmán Álvarez
 Vigo-España

[Firebird-net-provider] Character set troubles

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

Hi Carlos, Oleg,

I've subscribed from my primary email now, to better keep up
with the discussions.

Disclaimer paragraph: (If reading disclaimers is boring for you, please
skip). 1. I must re-state that my exposure to .net is rather limited
(only writing small test programs, only using mono, speed-reading tons
of articles on MSDN. 2. I'll have a busy week with my day job, and
if time is left for FB, I'll have to look into the "index key too big 
(174)" issue, as I'm more competent there.

Carlos wrote:
> the supported character sets are "hardcoded" 
> into the .net data provider, if you have a custom 
> character set and it's supported by .net you need 
> to modify the .net provider source for add
> the character set definition and build the sources,
[following long list of supported charsets}

O.K. I don't know how to say it diplomatically, but I very much
assume that all the effort for client side charset conversion is
wasted in the long run (and maybe dangerous for the few cases,
where FB and CLR disagree about conversion. It may be a necessary
evil for now, if always connecting using Unicode can not be made
working with FB1.5.

I wrote:
>> (a) why should the user be given the option to connect with different
>> character sets, as it in effect this will only gives multiple code
>> paths in
>> the data provider, without benefit for the user.

Carlos wrote:
> I'm not sure if i understand well this, sorry, at this moment 
> you can give one character set on the connection string for 
> make the connection, field character set are handled internally.

Why specifying connection charsets from the user is a
strange approach:

The field character sets are (hopefully) choosen by the 
person designing the database to match his business
requirements: 
1. Character repertoire needed
2. Efficency
3. Availability of collation
4. Compatibility with legacy app or data.

The character set used in the .NET app is fixed, it's
always UTF-16 - correct me if I got this wrong. Is there
any valid reason, to manipulate the data inside the
.NET app in any other representation?

So given the field charset F, the connection charset C,
there will be transformation
F => C => UTF-16
and 
UTF-16 => C => F

So using different Cs, doesn't buy you anything.

In theory, C should be some flavour of Unicode,
but as your tests seem to indicate, this doesn't
work allways.

The only other reasonble alternative, would be 
C == F, but then you have the client side transcoding.
And it won't work with different F's.

So at this time, I cannot offer a truly optimistic perspective.

In the long term it must become possible to connect
using UTF-16, and then the .NET data provider
can be significantly streamlined.

What you can do in the meantime, I'm not competent
to comment.

Regards,
Peter Jacobi

Re: [Firebird-net-provider] Parameter size error

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

Hello:

Uh, this is bad :) :

> I can tell that, 

it should be:

I can't tell that .......





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Tools for Firebird

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

Hello:

> What do you use for tools whan manage a firbird database?

See here:

http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_admin_tools




--
Best regards

Carlos Guzmán álvarez
Vigo-Spain

[Firebird-net-provider] Tools for Firebird

[<mic...@fr...>]

What do you use for tools whan manage a firbird database?

Is there a good tool for querrybuilding?

Today i have:

IBAccess 1.17
http://www.ibaccess.org/


IBUtils - Interbase/Firebird Database Utilities
http://www.alikiwi.com/ibutils/ibutils.htm


For querry building i use Visual Studio with SIBPROvider OLE DB
http://www.sibprovider.com


But non of these tools seem to work any good :(


Any other tips?

Regards

Michael H=E5kansson

Re: [Firebird-net-provider] Parameter size error

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

Hello:

> So, you can't fix it?? It's firebird bug?


I can tell that, can be a problem in how the .net provider is handling 
character sets ;).

i have made a test for the point 1 by sending the complete set of bytes 
encoded with the connection character set and it raises an exception 
(operation was cancelled).

Can be good to known opinion of Peter Jacobi on this case and probably 
can be good too, to post this case in the firebird-devel list.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Parameter size error

[olegmad <ol...@ya...>]

> I know this, i have the smae problem this weekend ;) it's changed
> already in the CVS for make the comparsion over the character count
> instead of the byte count.
>
> But with an example like there are problems too:
>
> 1. If i send the data encoded using the connection character set ( in
> this case UNICODE_FSS ) the win1251 value is going to give more bytes
> than the sqllen sent by the server for this field.
>
> 2. If i send the data using the field character set ( that is how it's
> in the CVS ) we are going to get te "Cannot transliterate characters
> between character sets".

So, you can't fix it?? It's firebird bug?

Re: [Firebird-net-provider] FbCommandBuilder.DeriveParameters not

[olegmad <ol...@ya...>]

> Thanks very much. :)

Thank you :)

Re: [Firebird-net-provider] FbCommandBuilder.DeriveParameters not

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

Hello:

> A am too.
>
> But sp_command.Parameter[0].Size - equal 0.


Committed into CVS, i was filling only the needed data for execution, 
now i 'm filling to the Size, Precision and Scale of
sp parameters.



Thanks very much. :)


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FbCommandBuilder.DeriveParameters not

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

Hello:

> A am too.
>
> But sp_command.Parameter[0].Size - equal 0.

Ahhh ok, mi fault i understand that you mean the parameters count, sorry.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FbCommandBuilder.DeriveParameters not

[olegmad <ol...@ya...>]

> Using this i get 2 params for sp_command:

A am too.

But sp_command.Parameter[0].Size - equal 0.