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

[Firebird-net-provider] uppercase names for tables?

[Wotan v. K. <von...@we...>]

Hello,
I'm a c# & firebird newbie. I tried to use:
 
..
custDA.SelectCommand = new FbCommand("SELECT * FROM Persons", conn,
txn);
custDA.Fill(personDS);
....
 
-> error:
Dynamic SQL Error
SQL error code = -204
Table unknown
PERSONS
At line 1, column 15.
 
 
 
The Name of the Table is "Persons".
 
Do I have to use uppercase names for tables?
 
 
Best regards,
 
Wotan von Klass
Germany
 

Re: [Firebird-net-provider] Re: Script Parsing Issues

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

Hello:

> We're not writing a parser for all of SQL. We only need to identify a very
> small number of tokens. Thus a full SQL parser is an over-kill.

Ok, ok was only a suggestion :)






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

RE: [Firebird-net-provider] Re: Script Parsing Issues

[Mike S. <mi...@mi...>]

Hi Carlos

We're not writing a parser for all of SQL. We only need to identify a very
small number of tokens. Thus a full SQL parser is an over-kill.

Mike.

-----Original Message-----
From: fir...@li...
[mailto:fir...@li...]On Behalf Of
Carlos Guzman Alvarez
Sent: 17 April 2003 12:33
To: Carlos Guzman Alvarez
Cc: mi...@mi...; Firebird .Net Provider
Subject: Re: [Firebird-net-provider] Re: Script Parsing Issues


HEllo:

> Ok, huummm, i recommend you to use csLex (
> http://www.cybercom.net/~zbrad/DotNet/Lex/ ) i have tested it, works
> really well and it's quite simple to use, you "only" need to make the
> grammar file and csLex will generate the parser for you.


A last question, here:

http://ostermiller.org/syntax/download.html

You can found a SQL grammar file that can be used with csLex ( i have
tested it some time ago and as i remember it works ) can be good to take
a look at it for see if it can be used for ISQL parsing ??


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Problems using the Provider in VS .NET / System.IO.FileNotFoundException

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

Hello:


> That´s right, CreateDatabse was the function I meant. The default PageSize
> for 
> Interbase 6.0 is 2048. Due to performance issues it is recommended that you
> increase
> the pagesize to 4096. Normally I used in C++ with the IB6 API these commands
> to create a database:
> 
>   isc_db_handle db = 0L;  // DB Handle
>   isc_tr_handle tr = 0L;  // Transaction Handle
>   ISC_STATUS status[20];
> 
>   t_string sql = (t_string)"CREATE DATABASE " + "'" + dbname + "' PAGE_SIZE
> 4096 USER '" + ownerid + "' PASSWORD '" + ownerpwd + "' DEFAULT CHARACTER SET
> ISO8859_1";
>   isc_dsql_execute_immediate(status, &db, &tr, 0, sql.Value(), 3, NULL);
> 
> Afterwards I connect to this database and create all the external functions
> which are defined in the ib_udf.dll. If not, you don´t have alle the
> functions liek upper, lower, abs, substr, strlen etc.



Done, now you can spcefy the page size and the character set ( i need to 
verify if this works i will try to see it later today ).




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] Re: Script Parsing Issues

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

HEllo:

> Ok, huummm, i recommend you to use csLex ( 
> http://www.cybercom.net/~zbrad/DotNet/Lex/ ) i have tested it, works 
> really well and it's quite simple to use, you "only" need to make the 
> grammar file and csLex will generate the parser for you.


A last question, here:

http://ostermiller.org/syntax/download.html

You can found a SQL grammar file that can be used with csLex ( i have 
tested it some time ago and as i remember it works ) can be good to take 
a look at it for see if it can be used for ISQL parsing ??


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] Re: Script Parsing Issues

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

Hello:

> I'd just hand code it - it's no big deal. I'd finish it faster than it would
> take to learn how to use ANTLR.


Ok, huummm, i recommend you to use csLex ( 
http://www.cybercom.net/~zbrad/DotNet/Lex/ ) i have tested it, works 
really well and it's quite simple to use, you "only" need to make the 
grammar file and csLex will generate the parser for you.






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-España

RE: [Firebird-net-provider] Re: Script Parsing Issues

[Mike S. <mi...@mi...>]

Hi Carlos

I'd just hand code it - it's no big deal. I'd finish it faster than it would
take to learn how to use ANTLR.

Mike.

-----Original Message-----
From: fir...@li...
[mailto:fir...@li...]On Behalf Of
Carlos Guzman Alvarez
Sent: 16 April 2003 15:57
To: Firebird .Net Provider
Subject: Re: [Firebird-net-provider] Re: Script Parsing Issues


Hello:

 > Like I said, I'm happy to write it.


It can be good, i'm thinking on see ANTLR for generate one (
http://www.antlr.org/ )






--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.




-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Problems using the Provider in VS .NET / System.IO.FileNotFoundException

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

Hello:

>I am pretty new to C# and the .NET Framework. At work
>we are using Interbase 6.0 Open Source and for my private
>issues I like to test Firebird using this .NET provider.
>
>My problem is the following: At first I downloaded the
>RC2 Version (the windows binary) and used the installer.
>Everything worked find and there was no error. Checking the
>GAC, the Firebird assembly is registered. So I started
>a little project to test the driver. The second step for
>me was to open the toolbox (Solution Explorer) and used "Add
>Reference" with the Browse button to include the DLL. I compiled
>the project and started it. Everything works fine as long as I dont 
>use anything from the provider. When I try to connect to a database,
>I get an System.IO.FileNotFoundException named
>
>"File or assembly name System, or one of its dependencies, was not 
>found."
>
>The output tells me the following stuff and I don´t have a clue what 
>  
>
>to do. I appreciate any help.
>

I think the problem can be in that RC2 binaries  was built using .net 
framework 1.1 and you are using the 1.0, if you can download RC2 sources 
and NAnt ( sourceforge.net/projects/nant ) and try to built it.




Best regards
Carlos Guzman Alvarez
Vigo-Spain

[Firebird-net-provider] Problems using the Provider in VS .NET / System.IO.FileNotFoundException

[Lensman <le...@gm...>]

Hallo!

I am pretty new to C# and the .NET Framework. At work
we are using Interbase 6.0 Open Source and for my private
issues I like to test Firebird using this .NET provider.

My problem is the following: At first I downloaded the
RC2 Version (the windows binary) and used the installer.
Everything worked find and there was no error. Checking the
GAC, the Firebird assembly is registered. So I started
a little project to test the driver. The second step for
me was to open the toolbox (Solution Explorer) and used "Add
Reference" with the Browse button to include the DLL. I compiled
the project and started it. Everything works fine as long as I dont 
use anything from the provider. When I try to connect to a database,
I get an System.IO.FileNotFoundException named

"File or assembly name System, or one of its dependencies, was not 
found."

The output tells me the following stuff and I don´t have a clue what 
to do. I appreciate any help.

Thx!

Christian

Output:
-------

'DefaultDomain': Loaded 'c:\windows\microsoft.net\framework\v1.0.3705
\mscorlib.dll', No symbols loaded.
'Firebird Administrator': Loaded 'D:\Christian\Entwicklung\C#\Firebird 
Administrator\bin\Debug\Firebird Administrator.exe', Symbols loaded.
'Firebird Administrator.exe': Loaded 'c:\windows\assembly\gac
\system.windows.forms\1.0.3300.0__b77a5c561934e089
\system.windows.forms.dll', No symbols loaded.
'Firebird Administrator.exe': Loaded 'c:\windows\assembly\gac\system
\1.0.3300.0__b77a5c561934e089\system.dll', No symbols loaded.
'Firebird Administrator.exe': Loaded 'c:\windows\assembly\gac
\system.drawing\1.0.3300.0__b03f5f7f11d50a3a\system.drawing.dll', No 
symbols loaded.
'Firebird Administrator.exe': Loaded 'c:\windows\assembly\gac
\accessibility\1.0.3300.0__b03f5f7f11d50a3a\accessibility.dll', No 
symbols loaded.
'Firebird Administrator.exe': Loaded 'c:\windows\assembly\gac
\firebirdsql.data.firebird\1.0.1200.17644__e1b4f92304d7b12f
\firebirdsql.data.firebird.dll', No symbols loaded.
The program '[1008] Firebird Administrator.exe' has exited with code 0 
(0x0).

Re: [Firebird-net-provider] Re: Script Parsing Issues

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

Hello:

 > Like I said, I'm happy to write it.


It can be good, i'm thinking on see ANTLR for generate one ( 
http://www.antlr.org/ )






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

RE: [Firebird-net-provider] Re: YATP (Yet Another Terminator Problem :-)

[Mike S. <mi...@mi...>]

Hi Carlos

If you like, I could see if I can find the time to write a proper tokeniser
that will avoid these problems.

Mike.

-----Original Message-----
From: fir...@li...
[mailto:fir...@li...]On Behalf Of
Carlos Guzman Alvarez
Sent: 16 April 2003 11:54
To: mi...@mi...
Cc: Firebird .Net Provider
Subject: [Firebird-net-provider] Re: YATP (Yet Another Terminator
Problem :-)


Hello:

> The way you're currently splitting commands (both in batch commands and in
> FbScript.cs) doesn't work properly. If there is a string containing a
> semi-colon, it will break.

Yes i know :) but for do this probably i will need to use
RegularExpresions or a specific method fot this task.


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Re: Script Parsing Issues

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

Hello:

>> The way FbScript.cs currently looks for specific ISQL commands is too
>> simplistic. It should work no matter how much white space is between
>> individual command identifiers. For example, SET TERM could be 
>> written SET
>> TERM (with 2 spaces) and should still work.
>

Yes but for this probably we need a lexer, and this is only an interface 
component not an administration tool,
and i want to do only a basic isql query parser.





Best regards
Carlos Guzman Alvarez
Vigo-Spain

[Firebird-net-provider] Re: Script Parsing Issues

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

Hello:


> The way FbScript.cs currently looks for specific ISQL commands is too
> simplistic. It should work no matter how much white space is between
> individual command identifiers. For example, SET TERM could be written SET
> TERM (with 2 spaces) and should still work.
> 
> The parser also has to be aware of lexical context such as strings and SQL
> comments so that statements like this don't confuse it:
> 
>   insert into aTable values ( 'SET TERM' ) ;
> 
> This is really the same as the "terminator-in-a-string" problem - the parser
> has to do more than just look for special patterns in the input stream.


I know this too, but at this moment i only want to do a basic isql parser.



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Re: YATP (Yet Another Terminator Problem :-)

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

Hello:

> The way you're currently splitting commands (both in batch commands and in
> FbScript.cs) doesn't work properly. If there is a string containing a
> semi-colon, it will break.

Yes i know :) but for do this probably i will need to use 
RegularExpresions or a specific method fot this task.


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

[Firebird-net-provider] Script Parsing Issues

[Mike S. <mi...@mi...>]

Hi Carlos

The way FbScript.cs currently looks for specific ISQL commands is too
simplistic. It should work no matter how much white space is between
individual command identifiers. For example, SET TERM could be written SET
TERM (with 2 spaces) and should still work.

The parser also has to be aware of lexical context such as strings and SQL
comments so that statements like this don't confuse it:

  insert into aTable values ( 'SET TERM' ) ;

This is really the same as the "terminator-in-a-string" problem - the parser
has to do more than just look for special patterns in the input stream.

Cheers,

Mike.

[Firebird-net-provider] YATP (Yet Another Terminator Problem :-)

[Mike S. <mi...@mi...>]

Hi Carlos

The way you're currently splitting commands (both in batch commands and in
FbScript.cs) doesn't work properly. If there is a string containing a
semi-colon, it will break.

Here's some sample code to illustrate:

const string connectionString =
        "User=SYSDBA;"          +
        "Password=masterkey;"      +
        "DataSource=localhost;"      +
        "Port=3050;"          +
        "Dialect=1;"          +
        "Charset=NONE;"          +
        "Role=;"            +
        "Connection lifetime=15;"    +
        "Pooling=true;"          +
        "Packet Size=8192;" +
        "Database=";

try
{
  string fileName = Path.GetTempPath() + "Temp.gdb" ;
  File.Delete( fileName ) ;
  Console.WriteLine( "Creating temporary DB '{0}'", fileName ) ;
  FbConnection.CreateDatabase( "localhost", 3050, fileName, "SYSDBA",
"masterkey", 1 ) ;
  using ( FbConnection connection = new FbConnection( connectionString +
fileName ) )
  {
    connection.Open();
    using( FbTransaction transaction = connection.BeginTransaction() )
    {
      using( FbCommand command = new FbCommand( "CREATE TABLE
TESTTABLE(STRINGFIELD VARCHAR(50))",
                connection, transaction ) )
      {
        command.ExecuteNonQuery() ;
        transaction.CommitRetaining() ;
        Console.WriteLine( "About to try to insert a string containing a
semi-colon - it will fail" ) ;
        command.CommandText = "INSERT INTO TESTTABLE VALUES ( 'This is a
semi-colon ;' );" +
          "INSERT INTO TESTTABLE VALUES ( 'This is not a semi-colon !' );" ;
        using ( FbDataReader reader = command.ExecuteReader() )
        {
          while ( reader.NextResult() )
          {
          }
        }
      }
      transaction.Commit();
    }
  }
}
catch ( Exception E )
{
  Console.WriteLine( "{0}: {1}", E.GetType().Name, E.Message ) ;
}
Console.Write( "Hit enter" ) ;
Console.ReadLine() ;

Cheers,

Mike.

Re: [Firebird-net-provider] help with arrays

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

Hello:

> I have found on the todo file that support for array datatype will not be
> implemented until version 1.0 is released, but I need to use arrays on my
> database.
> 
> Any idea how to insert and select data to/from an array type? Any example?

At this moment there are no support for array datatype in the .net 
provider, probably i will try to see this when i have finished the isql 
script parser.








-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] New developement branch for version 1.1

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

Hello:


I have created a new developmente branch for the ner-provider v1.1:
	
	branch-release-1-1


I have commited yet the first changes for command plan, isql script 
execution, aren't complete yet but seems to work, i will try to add the 
NUNit test tomorrow.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Release candidate 2 build question

[Jim M. <jim...@co...>]

Same for me, no problems.

""Mike Scott"" <mi...@mi...> wrote in message
news:FDE...@mi......
> Hi Carlos
>
> I've been using .Net 1.1 since I started with the Firebird provider and
it's
> worked without a problem.
>
> Mike.
>
> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf Of
> Carlos Guzman Alvarez
> Sent: 14 April 2003 12:51
> To: Firebird .Net Provider
> Subject: [Firebird-net-provider] Release candidate 2 build question
>
>
> Hello:
>
>
> I have reinstalled w2k in my machine and i'm thinking in install .NET
> Framework 1.1 on it and build release candidate 2 binaries with it ( if
> all NUnit tests run well with it ), but i want to know how much people
> is using .NET Framework 1.1 before install it??
>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
>
> P.S.: Release candidate 2 will be released tomorrow :)
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

[Firebird-net-provider] help with arrays

[Jesus A. <ja...@er...>]

Hi all,

I have found on the todo file that support for array datatype will not be
implemented until version 1.0 is released, but I need to use arrays on my
database.

Any idea how to insert and select data to/from an array type? Any example?

Thank you,

jaire

[Firebird-net-provider] FbHelper class?

[Alessandro P. <pet...@in...>]

Hi everybody,
has anyone tried to convert the SqlHelper class (from the Microsoft Data
Access Application Block) to be used with the Firebird .NET Provider?
I think it could be useful...

--
Best regards,
Alessandro Petrelli.

[Firebird-net-provider] Firebird .Net provider Release Candidate 2 available for download.

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

Hello:

Firebird .Net provider Release Candidate 2 available for download.


You can view the changelog at:

http://sourceforge.net/project/shownotes.php?release_id=153066


You can download binarys at:

http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-RC2.exe?download

You can download sources at:

http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-RC2-Src.zip?download


You can download documentation at:

http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-RC2-Doc.zip?download


CVS Tag:

NP1_0_RC2




-- 
Best regards
Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Plan for Firebird .NET Data Provider v1.1

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

Hello:


After RC2 release I'm going to open a new branch for version 1.1, this 
will be a version with little improvements to be in sync
with .net framework 1.1. and add some little new features.


New in .net framework v1.1:

FbDataReader.

	- Add HasRows property.


FbConnection.

	- Add EnlistDistributedTransaction. ( I'm not sure about add 	this, i
need to see what i need to do )


New features:

FbCommand.

	- Add ExecuteScript method. For execution of ISQL scripts.

	- Add QueryPlan property. For return the plan used for the Firebird Server.

	


Suggestions are welcome.


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Interbase

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

HEllo:

> FirebirtNetProvider is 100% compatible with Interbase 6.0?
> 
> This exception are occurring:
> Exception Details: FirebirdSql.Data.INGDS.GDSException: Exception of type FirebirdSql.Data.INGDS.GDSException 
> was thrown.


Can you send a sample code to try to reproduce it ???



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] re: re: problem with column alias

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

Hello:

> I got it.
> 
> I compiled and tested it. Now it works fine for me. I tested the whole
> application and it's ok.
> 
> Thanks a lot for your support.


Thanks to you :)


-- 
Un saludo

Carlos Guzmán Álvarez
Vigo-España

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.