Re: [Firebird-net-provider] Dialect 1 issues?
1. You should not use the Firebird provider for connecting to Interbase. Use the appropriate Interbase .NET driver for connecting to Interbase. 2. Look for Interbase specific support on the Codegear newsgroups. /regards, Steve Faleiro --- On Tue, 5/12/09, Sam Carleton scarle...@miltonstreet.com wrote: From: Sam Carleton scarle...@miltonstreet.com Subject: [Firebird-net-provider] Dialect 1 issues? To: firebird-net-provider@lists.sourceforge.net Date: Tuesday, May 12, 2009, 9:25 PM The Interbase 7.5 database I am working with is in Dialect 1. When -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Dialect 1 issues?
Well, you should use a certain software for what it was specifically designed for. This driver is specifically designed for Firebird and should be used with Firebird. Further, support lists such as this are pretty specific as to what issues they respond to. This list is specific to the .NET driver for Firebird. If someone is using it with Interbase, and can help with your specific issue, then consider yourself lucky. --- On Tue, 5/12/09, Sam Carleton scarle...@gmail.com wrote: From: Sam Carleton scarle...@gmail.com Subject: Re: [Firebird-net-provider] Dialect 1 issues? To: For users and developers of the Firebird .NET providers firebird-net-provider@lists.sourceforge.net Date: Tuesday, May 12, 2009, 10:39 PM On Tue, May 12, 2009 at 12:08 PM, Steve Faleiro steve_...@yahoo.com wrote: 1. You should not use the Firebird provider for connecting to Interbase. Use the appropriate Interbase .NET driver for connecting to Interbase. 2. Look for Interbase specific support on the Codegear newsgroups. Steve, Are you saying that the Firebird provider won't work for Interbase or that it is bad form for me to use the open source software with the closed source database? Sam -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Dialect 1 issues?
Well, you should use a certain software for what it was specifically designed for. This driver is specifically designed for Firebird and should be used with Firebird. Further, support lists such as this are pretty specific as to what issues they respond to. This list is specific to the .NET driver for Firebird. If someone is using it with Interbase, and can help with your specific issue, then consider yourself lucky. --- On Tue, 5/12/09, Sam Carleton scarle...@gmail.com wrote: From: Sam Carleton scarle...@gmail.com Subject: Re: [Firebird-net-provider] Dialect 1 issues? To: For users and developers of the Firebird .NET providers firebird-net-provider@lists.sourceforge.net Date: Tuesday, May 12, 2009, 10:39 PM On Tue, May 12, 2009 at 12:08 PM, Steve Faleiro steve_...@yahoo.com wrote: 1. You should not use the Firebird provider for connecting to Interbase. Use the appropriate Interbase .NET driver for connecting to Interbase. 2. Look for Interbase specific support on the Codegear newsgroups. Steve, Are you saying that the Firebird provider won't work for Interbase or that it is bad form for me to use the open source software with the closed source database? Sam -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Backup/Restore
What operating system are you getting this Blue Screen? 98, 2000, XP,
Vista ?
Can you post your code so that I can try to replicate it?
-Steve Faleiro
--- Kixzo Team kixz...@4colordesign.com wrote:
Hello,
Thanks for your comment :).
But, I see serious problem with this.
I am getting the Blue screen (Memory dump problem). Is it any way that
process is taking memory resources and that is not getting freed.
I will provide my test result.
Regards,
Rakesh Singh.
http://www.4colordesign.com
-Original Message-
From: Jiri Cincura [mailto:disk...@cincura.net]
Sent: Thursday, December 18, 2008 6:24 PM
To: kixz...@4colordesign.com; For users and developers of the Firebird
.NET
providers
Subject: Re: [Firebird-net-provider] Backup/Restore
On Thu, Dec 18, 2008 at 12:51, Kixzo Team kixz...@4colordesign.com
wrote:
When I am doing restore, continuously on the same database backup
file
.FBK
file my system get restarted. I am using Windows XP Professional
SP2.
It would be nice to have such power in provider ;), but I have doubts,
that code in .NET provider is able to restart your system.
My advice is to test the code and file on other machine and/or test
same steps with gbak.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
--
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas,
Nevada.
The future of the web can't happen without you. Join us at MIX09 to
help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] .NET provider v1.7.2 release
Hi Jiri,
The date needs to be updated on the download page - it still shows 29th
Mar 2006.
Cheers,
Steve Faleiro
--- Jiri Cincura disk...@cincura.net wrote:
Hello *,
the firebird-net-provider subproject of Firebird project is proud to
announce release of version 1.7.2 of .NET Data Provider for .NET 1.1.
This release is only maintenance release. Contains only backported fix
for connecting to Firebird 2.1 server. No new features or other
bugfixes etc. were added.
You can download it from
http://www.firebirdsql.org/index.php?op=filesid=netprovider.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
--
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas,
Nevada.
The future of the web can't happen without you. Join us at MIX09 to
help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Using a Hashtable between reader.Read() kills performance
while( reader.Read() )
{
for( int j = 0; j reader.FieldCount; ++j )
val=reader[j];
// table.Add(count, val);
++count;
}
while( reader.Read() )
{
for( int j = 0; j reader.FieldCount; ++j )
{
val=reader[j];
table.Add(count, val);
}
++count;
}
Perhaps you meant to do this?
--- [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi there,
Here I'm trying to save some miliseconds with the Firebird provider
(using embedded database!)
Well, I've a weird problem and I'd like you to take a look into it.
Well, I'm using the following code to read data from a Firebird
database:
object val;
while( reader.Read() )
{
for( int j = 0; j reader.FieldCount; ++j )
val=reader[j];
// table.Add(count, val);
++count;
}
I'm reading 416310 records.
Well, in my poor-slow laptop it takes 50 seconds to read all data.
The funny thing is: did you see the commented out code? Well, it
just
adds the last read field from the record to a hash table. It doesn't
make any sense, it is just a test case extracted from real code, so
don't try to find any logic.
Well, the point is: if I uncomment the line - it takes 158 seconds to
read the 416310 records!!!
Ok, now you're thinking: yes, that's because adding to the hashtable
is
slow. Check the following code:
Hashtable table = new Hashtable();
int ini = Environment.TickCount;
for( int i = 0; i 416310; ++i )
table.Add(i, new object());
Console.WriteLine(
Time to add {0} objects = {1} ms,
table.Count,
Environment.TickCount - ini);
It takes 250 ms (miliseconds!) to add the same number of dumb objects
to
the Hashtable!!
So, somehow, adding records to the Hashtable breaks reader
performance!!! I'm going crazy, and yes, I've repeated the results on
a
different computer with different OS and I get the same relative
results!
If you change the Hashtable by an ArrayList... performance hit goes
away!!
Ideas???
Thanks
pablo
-
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK win great
prizes
Grand prize is a trip for two to an Open Source event anywhere in the
world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] (no subject)
Is something wrong with the list? It is repeating the same emails two, three or more times. Steve - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ExecuteReader is slow
IMHO, 0.028 seconds seems to be pretty quick. That is 3/10ths of a second. What were you expecting? --- giorgi giorgi [EMAIL PROTECTED] wrote: Hello, I am using 2.1 version of firebird. Fb.NEt provider version is 2.0.1.0Connection string looks like this: User=SYSDBA;Password=masterkey;Datasource=xxx;Database=name.gdb; (xxx is just symbolic here) Command looks like this: SELECT SUM(nsum), card FROM op WHERE smth = @from AND smth= @to AND bal = @code group by card from, to and code parameters are added during runtime. When I call ExecuteReader it takes too much time, about 0.028 seconds. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Provider with ASP.NET
The firebird.msg file should be put in the same directory as the fbclient.dll or fbembed.dll and the other Firebird dll files. -Steve Faleiro --- Tetram Corp [EMAIL PROTECTED] wrote: Hi, I'm using the provider to build a website with ASP.NET All works fine except when I've got an FB error, the message is not resolved with firebird.msg. I tried to put the file in C:\Windows\System32, the provider directory, my website directory, or IIS bin directory no change Where does the provider look for firebird.msg ? or, a little out of topic, is there someone who kowns where to put the file when using FB for an ASP.NET website? Thierry - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird ado.Net 2.0 Data
--- Mercea Paul [EMAIL PROTECTED] wrote:
On http://firebirdsql.org/index.php?op=filesid=netprovider you'll
find all
you need!
By the way... my fbconnection.connection string property has no ...
button ,
but I don't use this visual component, I have declared in my db class
and
build the connection string ... I think this is the most used
scenario!
Regards,
Paul
I agree that this is the best method. I am posting code from one of my
applications to demonstrate how this can be implemented in C#:
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Common;
using FirebirdSql.Data.FirebirdClient;
namespace MED
{
class DataLayer
{
private string connStr;
private FbConnection fbc;
public DataLayer()
{
connStr = Dialect=3; ServerType=1; User=SYSDBA;
Password=masterkey; Database=c:\\temp\\MED\\database\\MEDDB.FDB;
fbc = new FbConnection(connStr);
fbc.Open();
}
public DataSet getPatientList(string patLastName)
{
FbCommand cmd = new FbCommand(MDPTNT01_SEL_L, fbc);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(@PLASTNAME, patLastName);
DataSet ds = new DataSet();
FbDataAdapter da = new FbDataAdapter(cmd);
da.Fill(ds);
return ds;
}
public DataSet getPatientDetails(string patNo)
{
FbCommand cmd = new FbCommand(MDPTNT01_SEL, fbc);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(@PATNO, patNo);
DataSet ds = new DataSet();
FbDataAdapter da = new FbDataAdapter(cmd);
da.Fill(ds);
return ds;
}
}
}
To use it, the following code:
dataLayer = new DataLayer();
DataSet ds = dataLayer.getPatientDetails(patNo);
Regards,
Steve Faleiro
-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Help with SQL
--- Steve Harp [EMAIL PROTECTED] wrote: HI All, I'm trying to get invoice totals to show item totals and payments. I have 3 tables; Invoice, InvoiceDetail, and InvoicePayment. I first tried a join like this. [..] I haven't tried it in NET, but am venturing a guess that this has to do with parameters. Can you try to remove the parameters from the SQL statement and see if it works. -Steve - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Enterprise Library for Firebird
There is an old project written by Andrea Sansottera available at: http://www.firebirdsql.org/dotnetfirebird/blog/2005/04/enterprise-library-data-access.html#2731204806947739001 However, it isn't compatible with the latest Enterprise Library 4.0 / .NET framework 3.5 (and possibly Firebird 2.1) and trying to compile it in Visual Studio .Net 2008 results in errors caused by deprecated class members. Anyone interested in resurrecting this project? I am thinking of starting a new project with the same name on SourceForge. Regards, Steve Faleiro - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Enterprise Library for Firebird
I have started a new project in SourceForge with the same name. Regards, Steve - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird DDEX provider for Visual Studio
After digging through these groups I finally found a post that helps to get it working: http://www.mail-archive.com/firebird-net-provider@lists.sourceforge.net/msg05378.html - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
