I've tried compression on a local and remote FB3 database and am not seeing
any difference using compression or Packet/Fetch size.
Do I have settings correct: On server: WireCompression = true
connection string: initial catalog=<>;compression=True;data source=<>;port
number=3051;role name=Office;
I'm using FB3 for a new commercial app now and I'm interested. For me,
there are many occasions where I have had to write something in an SP that
would have been much easier in .NET simply because I use it every day and
SQL less often.
Keep us informed on the progress.
Regards,
Rick
On Mon, Jun
Now that FB3 has been officially released, is there and ETA for the Net
Provider? I'm especially interested to have the new Boolean datatype
working.
Regards,
Rick
--
Find and fix application performance issues faster wit
I'm pretty sure this is a known problem, but I get a message "invalid data
type" exception when I ExecuteDataReader against a FB3 table with a boolean
field. I can provide the error stack if necessary.
Is there an ETA date to get this working?
Regards,
Rick
---
Thank you Paul,
That is helpful. I didn't realize this was possible outside of GSec.
Rick
-Original Message-
From: Mercea Paul [mailto:paul.mer...@almexa.ro]
Sent: Monday, January 10, 2011 2:42 PM
To: firebird-net-provider@lists.sourceforge.net
Subject: Re: [Firebird-net-provider] SPAM
y, January 09, 2011 11:21 AM
To: r...@lakevalleyseed.com; For users and developers of the Firebird .NET
providers
Subject: Re: [Firebird-net-provider] FBSecurity UserPassword
On Sun, Jan 9, 2011 at 12:54, Rick Roen wrote:
> Is there a way to get this using the FBSecurity class or other?
No.
FBClient 2.5.2
Firebird 2.5.0.26074
When I access FBSecurity.DisplayUsers, the UserPassword is always blank. I
guess this is not filled in when the structure is initialized. Is there a
way to get this using the FBSecurity class or other?
Rick
-
FBClient 2.5.2
Firebird 2.5.0.26074
I use this code to create a new user:
Dim security As New FirebirdSql.Data.Services.FbSecurity
security.ConnectionString = "User ID=Sysdba;Password=masterkey"
Dim ud As FirebirdSql.Data.Services.FbUserData = New
FirebirdSql.D
I'm wondering how to use Windows Authentication with FB server v 2.5 and
FirebirdClient.dll v 2.5.2, Win 7 Pro, 64 bit?
I have the same user name set up for Windows and FBServer.
I am trying:
Dim connstring As New
FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder()
Hi,
I am doing a fresh FirebirdSql.Data.FirebirdClient.dll install on a Win 7
x64 with VS 2010.
I have used the NetProvider 2.5.2.msi and installed the dll into the gac
using the x64 gacutil. The gacutil reported that it installed the dll, but
I cannot see it in the folder, although the GA
, 2010 1:11 PM
To: r...@lakevalleyseed.com; For users and developers of the Firebird .NET
providers
Subject: Re: [Firebird-net-provider] firebird.log error 10054
On Tue, Apr 6, 2010 at 19:03, Rick Roen wrote:
> What is the status?
This is resolved (except under some circumstances when killing eve
VS 2008v 9.0.30729.1 SP
FB server v2.1.1.17910
FirebirdClient.dll v2.5.0.0
My firebird.log fills with this entry hundreds of times per day. I asked
about this last year in January and Jiri was looking into the problem. I
looked at the tracker, but am unclear if it was resolved, but in any c
AFAIK this is a Firebird restriction.
I have quite a few like this and I ended up adding the list in code like:
String.Format(“Select * from Users where user_id in ({0})”, “4,6,93”).
If you have a known number of variables in your list you can do:
Select * from Users where user_id i
FB net provider v 2.5.0.0
FB server v 2.1.1.1790
I am wondering about pooling. I have WPF and Windows based .Net
applications that are run on Windows networks. Generally there are less than
30 users accessing the FB database via the programs at any one time. I
have had pooling = true, min
I'm certainly willing to put some time back in for all that I have received
on this and other FB ng's.
I know nothing about DocBook format so I hope that is not a requirement.
Rick
-Original Message-
From: Jiri Cincura [mailto:disk...@cincura.net]
Sent: Tuesday, March 31, 2009 1:58 PM
T
?
Rick
-Original Message-
From: Rick Roen [mailto:r...@lakevalleyseed.com]
Sent: Friday, March 13, 2009 11:17 AM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] No message for error code...
Maybe I miss something.
My typical clien
Maybe I miss something.
My typical client setup is to run all the programs from a UNC file path and
put all the associated DLL in the same pat.
If I just replace the FirebirdClient.dll with the updated version I think I
recall that the programs fill fail because they cannot find the version of
the
I installed 2.5.0 beta 1 and the problem is corrected. Thanks.
Wouldn't it be easier and clearer to have the FirebirdClient use the same
Firebird.msg file as the firebird server? That way when we update Firebird
server the message file for FirebirdClient would automatically get updated
also. Now
Thanks Helen,
I used Outlook 2007 text message interface because I thought I saw a posting
from you about not sending in HTML. Is this the case?
I will try the FirebirdClient 2.5.0 Beta 1 as Jiri suggested since the
messages are embedded in the FirebirdClient.dll.
Regards,
Rick
Firebird 2.1.1.17910
Firebird client 2.1.0.0
I am intentionally triggering a foreign key violation by deleting a parent
record.
When I do this from Database Workbench I get the message:
Violation of FOREIGN KEY constraint …
>>> Foreign key references are present for the record. <<<
Did you have a chance to look at this yet?
Rick
-Original Message-
From: Jiri Cincura [mailto:disk...@cincura.net]
Sent: Saturday, January 03, 2009 4:16 PM
To: r...@lakevalleyseed.com; For users and developers of the Firebird .NET
providers
Subject: Re: [Firebird-net-provider] log filled
Firebird server v 2.1.17910
FirebirdClient.dll v 2.1.0.0
Vista Pro
My firebird.log file is filled with hundreds entries like:
RICK2008 (Server)Sat Dec 27 13:21:07 2008
INET/inet_error: read errno = 10054
My connection string is:
initial catal
Is there some way to know if an FbBackup.Execute completes successfully, or
does it just throw an exception if not?
Regards,
Rick
--
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The f
What does the reg entry look like? I can't find the info.
Rick
>It's stored in registry. VS isn't listing GAC.
-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based
reference the FirebirdSqlData.FirebirdClient.dll.
The dll is listed in the Windows\assembly.
How do I get back the reference in the .NET tab? I didn't see any other
instructions in the installation folder.
Rick
On Thu, Dec 4, 2008 at 13:48, Rick Roen <[EMAIL PROTECTED]> wrote:
FB net provider v2.0.1.0
FB server v2.1.1
I believe there is support for TransactionScope, however the following does
not work, i.e. at the end of the function both updates were committed and
the row values were changed. The second "Using cmd." throws an exception so
the tr.Complete is never
I'm using FirebirdSql.Data.FirebirdClient v 2.0.1.0 and Vista.
Everything works fine when I use normal login, but I am having no luck with
Windows authentication.
Can someone point me to the documentation or give me instructions on how to
do this?
I have "Authentication = mixed" set in
I'm using FirebirdSql.Data.FirebirdClient v 2.0.1.0 and Vista.
Everything works fine when I use normal login, but I am having no luck with
Windows authentication.
Can someone point me to the documentation or give me instructions on how to
do this?
I have "Authentication = mixed" set in
Never mind. I had the alias specified incorrectly. Now it works.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Rick Roen
Sent: Thursday, July 31, 2008 1:07 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] new
I did not have .NET v2 installed on the server. When I installed it, then I
could drag the FirebirdSql.Data.FirebirdClient.dll into the GAC.
However the same error message still happens. Any suggestions?
Rick
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Rick Roen
I'm installing a new SBS 2003 server that hosts my Firebird server and
programs.
When I try to open a program that uses the net provider I get the following
exception. Can someone tell me what I have done wrong? Do I have to
install the FirebirdSql.Data.FirebirdClient in the Server GAC?
I
the Firebird .NET providers
Subject: Re: [Firebird-net-provider] access denied to Vista machine.config
Rick Roen wrote:
> I have just upgraded to a Vista Business laptop and have installed the
> .net provider. Now when I try to modify the machine.config to add the
> FB provided, I ca
I'm sure this is not a FB.net provider issue, but I thought I could get a
quick answer here.
I have just upgraded to a Vista Business laptop and have installed the .net
provider. Now when I try to modify the machine.config to add the FB
provided, I cannot save because access is denied. I have
Teymur,
I do not have v2 of Firebird, but I did not think it was possible to search
inside a BLOB field. You might confirm this in a FB newsgroup or in the FB
docs.
Regards,
Rick
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Teymur Hajiyev
Sent: Friday, April 11, 2
I'm not sure if this would entirely solve your problem, but can you use
"Starting with".
Apparently this is what the fb db engine maps "Like" to internally since
Starting with will use an available index and Like not.
Rick
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECT
Kai,
I have used this type of select in VB.Net 2005 and the query analyzer does
complain about the "$", however it does actually work and return the result.
I think I get something about a "problem near '$'.".
Have you tried to run the generator code?
If it does not even compile there i
I thought it was specific to FB.
I am trying to connect to the FBDataAdapter.RowUpdated event like this:
AddHandler POAdapter.rowupdated, New FbRowUpdatedEventHandler(AddressOf
PO_OnRowUpdated)
But the compiler complains about "POAdapter.rowupdated".
If I do this in VS 2005:
Dim sql As New Sql
Is there some event that I can use to get tableadapter update errors?
I am trying to use:
AddHandler POAdapter.rowupdated, New FbRowUpdatedEventHandler(AddressOf
PO_OnRowUpdated)
With
Private Sub PO_OnRowUpdated(ByVal sender As System.Object, ByVal e As
FbRowUpdatedEventArgs)
FB 1.5
VS 2005
I'm confused about the results I get from a DataRowView.IsEdit
Here is the scenario:
- Strongly typed datatable -> bindingsource -> textbox controls for editing
- The client edits a textbox connected to TableA.
- The client moves to another tab where they will do some op
So then basically, it has no use?
Rick Roen wrote:
> Is this something with VS.NET (2005) or with the fb provider?
It's a provider "feature". It's always true.
-
Take Surveys. Earn Cash. Influenc
VB 1.5
When I create an FbDataReader using the execute reader method that has no
returned rows from a query, the results of reader.hasrows is true.
This is not what I am expecting since 0 rows were returned from the command.
Is this something with VS.NET (2005) or with the fb provider?
Using VB.NET 2005 with FB 1.5.3
I am trying to execute two Selects in a single FbCommand.
I just wanted a confirmation that this does not work:
Dim cmd as new FbCommand("Select * from TableA;Select * from TableB", conn)
Dim reader as FbDataReader = cmd.ExecuteReader
Here it fails n
[mailto:[EMAIL PROTECTED] On Behalf Of
Jiri Cincura
Sent: Friday, January 19, 2007 5:01 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] use UPPER function in select
Rick Roen wrote:
> Select from CONTACTS where ("UPPER"(NAME) like @Name)
More info.
This happens when I am in the DataSet designer and enter the commandText.
With a FbDataAdapter I can fill a table with no problem using the same SQL.
I will also check on an ADO ng.
Rick
_
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Rick
VS.NET 2005
I'm trying to add a select command like this to an FBDataTable:
Select from CONTACTS where ("UPPER"(NAME) like @Name)
And I get this error:
Failed to update CommandText:
The schema of data returned by your new command
Thanks Carlos,
I have FirebirdSql.Data.FirebirdClient.dll installed to the GAC on the
server and I put it into the application folder as well.
Is this what you meant? If not, where is FirebirdSql.Data.Firebird.dll? I
don't think it came with my install files.
Rick
Hello:
>
> Do I need to ins
VB.net 2005
When I create a simple application in VB.NET and copy the
exe to my file server there is no problem running it from the remote location.
When I add a reference like “Imports FirebirdSql” and
copy the resulting exe to the file server, I cannot run it with an exception “Sy
ubject: Re: [Firebird-net-provider] Call tableadapter stored
Rick Roen wrote:
> Can I write this output from the fill method directly to a fileStream of
> some kind and skip the extra steps?
>
Use the DataAdapter to fill a DataSet, and then use the WriteXml Method
of the Dat
Thanks Erv for the explanation.
I am outputting an xml file from this stored procedure where each row of the
returned column is a line of xml.
I want to write this to a file so I have been taking the output from the
DataTable, iterating through it and using a streamWriter.WriteLine to write
each
to match yours.
Me.NewRecipientTableAdapter.Fill(Me.PremiumsDataSet.NewRecipient,@INVOICENUM
, @LOGOFOLDER, @DOCTYPE)
Erv
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Rick Roen
Sent: Friday, October 20, 2006 3:45 PM
To: 'For users and developers of the Firebird .NET pr
Well, hopefully I understood this correctly.
Before I had in my GetData method:
GetData(INVOICENUM, LOGOFOLDER, DOCTYPE)
And now I have
GetData(@INVOICENUM, @LOGOFOLDER, @DOCTYPE)
So now I call like this
Dim sdInfo As New
RGardenDataSetTableAdapters.P_XML_SALESDOCTable
VB.Net 2005
FB 1.5.3
I’m using a table adapter for access to a stored
procedure with three input parameters.
When I am in design view I can select “Preview Data”
by clicking on the TableAdapter, fill in the params and Preview to get the
results.
In code I am trying to call lik
lf Of
Jiri Cincura
Sent: Tuesday, October 17, 2006 12:13 PM
To: [EMAIL PROTECTED]; firebird-net-provider@lists.sourceforge.net
Subject: Re: [Firebird-net-provider] Params for stored procedure
Rick Roen wrote:
> Then I right click on the TableAdapter and select preview, fill in the
> params
I can't get this to post with the attachments since they are over the 40K
limit.
I can send the gifs to anyone who wants to see them.
Rick
-Original Message-
From: Rick Roen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 17, 2006 11:51 AM
To: 'For users and develop
al Message-
From: Jiri Cincura [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 17, 2006 5:36 AM
To: [EMAIL PROTECTED]; For users and developers of the Firebird .NET
providers
Subject: Re: [Firebird-net-provider] Params for stored procedure
Rick Roen wrote:
> But I don't think that co
Jiri and Carlos,
Thanks for your help so far.
The charset is ISO8859-1. This is set in the connection string.
No, the sp does not have any BLOB's.
But I don't think that could be the problem anyway since I get the same
error when I call an sp that has only two input params - both integers with
VB.Net 2005
FB 1.5
I have created a table adapter in a project for a stored
procedure in my database.
I used the connection xsd work space and right clicked + Add
to create the DataTable and TableAdapter components. The TableAdapter has
a Fill and GetData method like
GetData(I
Yes, thanks.
I can understand from the pictures how to do this.
I will try to start using the bindingSource + components since this is the
.Net 2 way.
Rick
Carlos Guzmán Álvarez wrote:
> Hello:
>> I was expecting to see components like FBConnection, FBCommand in the
>> toolbox. Then I could fi
I was expecting to see components like FBConnection, FBCommand in the
toolbox. Then I could fill out the properties in the property editor.
Here is what I do now to connect:
Dim connection As New FbConnection("connection string...")
Dim cmd As New FbCommand("P_XML_SALESDOC", connection)
...
Conne
VS 2005 pro
Firebird NET client 2.0.1-RC2
I have installed the Firebird client and can connect to an
FB DB from code, however I think the FB components should show up in the
toolbox – like the FBConnection.
I have made the changes to the machine.config like:
Re: [Firebird-net-provider] slow connection
iders'
Subject: Re:
[Firebird-net-provider] slow connection
First off allyou don't need 1 mill
records...try to get olny 100-1000 records.
Users don't need 1 mil records to view!
Regards
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Roen
Sent
VS.Net 2005 + Firebird 1.5
I’m just learning VB.net and playing with data
connection.
I have a FB database with typical customer->orders->orderitems
relationships
I am doing a test Windows form to display the customer and tables
for their orders and orderitems.
I have the re
THANKS ALL,
I've got it working now.
I think the basic problem
was with the Public Key Token, but after I followed all the steps from Kai I
discovered that the value in the GAC did not match the values that were put in
the machine.config during the install.
I'm not sure where th
I changed both of those entries for the Version, but I still have the same
problem.
>From what paha said in his answer there is a problem with the Public key
token.
Here is what I have now in the machine.config
I can see the "bae6c78ccb0fcdb3" as the public key token in my
Windows\A
I used DDEXProvider-2.0.1-RC2.exe
machine.config changes:
..
..
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Carlos Guzmán Álvarez
Sent: Wednesday, October 11, 2006 5:51 PM
To: For users and developers of the Firebird
65 matches
Mail list logo
