Re: [Firebird-net-provider] StackOverflowException in (possibly) FbDataAdapter
On 10/8/07, Victor Zajac [EMAIL PROTECTED] wrote:
Hi,
The test case is the simplest one: starting from a blank WinForm, I just
dropped a FbDataAdapter component, which launched the wizard. After
Design time support for this has been removed from codebase. You
should use new ADO.NET classes like BindingSource etc. in .NET 2. Or
create underlayer objects and bind to it.
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now http://get.splunk.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] Problem with connection strig using Report Manager
Tanks for your answer.In database connection panel I have Database Driver - I
chose Dot Net 2 Connection and in Dot net driver combobox I have :
System.Data.Odbc
System.Data.Oledb
System.Data.OracleClient
System.Data.SqlClient
so,no Firebird (I have Firebird clint 2.5 alpha 1 installed.)
I opended machine.config, and under configSections I added line :
section name=firebirdsql.data.firebirdclient
type=System.Data.Common.DbProviderConfigurationHandler,
System.Data,
Version=2.5.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089 /
under DbProviderFactories I added
add name=FirebirdClient Data Provider
invariant=FirebirdSql.Data.FirebirdClient
description=.Net Framework Data Provider for
Firebird
type=FirebirdSql.Data.FirebirdClient.FirebirdClientFactory,
FirebirdSql.Data.FirebirdClient,
Version=2.5.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089 /
I'm not sure about Version and PublicKeyToken.
Then in Dot net driver combo I found also
FirebirdSql.Data.FirebirdClient,but I got an error :
Failed to find or load the registered .NET Framework Data Provider
How can I solve this.Thanks.
- Original Message
From: Jiri Cincura [EMAIL PROTECTED]
To: For users and developers of the Firebird .NET providers
firebird-net-provider@lists.sourceforge.net
Sent: Saturday, October 6, 2007 9:22:28 PM
Subject: Re: [Firebird-net-provider] Problem with connection strig using Report
Manager
On 10/6/07, Mr. John [EMAIL PROTECTED] wrote:
Thanks for answer.I don't know how to make it work.Report manager came with
these 2 files :
C:\Program Files\Report
Manager\net\FirebirdSql.Data.Firebird.dll
C:\Program Files\Report Manager\net\fbembed.dll
This is probably some internal stuff. You need to connect to *your* DB
(and probably not via FB Embedded).
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now http://get.splunk.com/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Tonight's top picks. What will you watch tonight? Preview the hottest shows on
Yahoo! TV.
http://tv.yahoo.com/
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now http://get.splunk.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] Problem with connection strig using Report Manager
Hello: type=FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=2.5..0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 / I'm not sure about Version and PublicKeyToken. You should put the ones the assembly has in the GAC -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.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] Problem with connection strig using Report Manager
Thanks Carlos. With your suggestion I used gacutil.exe and now It works fine.Thanks a lot. - Original Message From: Carlos [EMAIL PROTECTED] To: For users and developers of the Firebird .NET providers firebird-net-provider@lists.sourceforge.net Sent: Monday, October 8, 2007 6:00:44 PM Subject: Re: [Firebird-net-provider] Problem with connection strig using Report Manager Hello: type=FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=2.5..0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 / I'm not sure about Version and PublicKeyToken. You should put the ones the assembly has in the GAC -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient: http://www.firebirdsql.org/ XMPP Client: http://code.google.com/p/xmppclient/ - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider Yahoo! oneSearch: Finally, mobile search that gives answers, not web links. http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.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] Problem with connection strig using Report Manager
On 10/8/07, Mr. John [EMAIL PROTECTED] wrote:
section name=firebirdsql.data.firebirdclient
type=System.Data.Common.DbProviderConfigurationHandler,
System.Data,
Version=2.5.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089 /
And there should be 2.0.0.0 etc., 'cause you're adding record for
type=System.Data.Common.DbProviderConfigurationHandler... and not
for FB.
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now http://get.splunk.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] Problem with connection strig using Report Manager
thanks
now it seems to work this way
section name=firebirdsql.data.firebirdclient
type=System.Data.Common.DbProviderConfigurationHandler,
System.Data,
Version=2.5.0.0, Culture=neutral,
PublicKeyToken=3750abcc3150b00c /
and
add name=FirebirdClient Data Provider
invariant=FirebirdSql.Data.FirebirdClient
description=.Net Framework Data Provider for
Firebird
type=FirebirdSql.Data.FirebirdClient.FirebirdClientFactory,
FirebirdSql.Data.FirebirdClient,
Version=2.5.0.0, Culture=neutral,
PublicKeyToken=3750abcc3150b00c /
thanks
- Original Message
From: Jiri Cincura [EMAIL PROTECTED]
To: For users and developers of the Firebird .NET providers
firebird-net-provider@lists.sourceforge.net
Sent: Monday, October 8, 2007 6:29:22 PM
Subject: Re: [Firebird-net-provider] Problem with connection strig using Report
Manager
On 10/8/07, Mr. John [EMAIL PROTECTED] wrote:
section name=firebirdsql.data.firebirdclient
type=System.Data.Common.DbProviderConfigurationHandler,
System.Data,
Version=2.5.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089 /
And there should be 2.0.0.0 etc., 'cause you're adding record for
type=System.Data.Common..DbProviderConfigurationHandler... and not
for FB.
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now http://get.splunk.com/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news,
photos more.
http://mobile.yahoo.com/go?refer=1GNXIC-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now http://get.splunk.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] Problem with connection strig using Report Manager
I have I silly question : do I have to make this configuration on every
computer that I install my application ?
Thanks.
- Original Message
From: Mr. John [EMAIL PROTECTED]
To: For users and developers of the Firebird .NET providers
firebird-net-provider@lists.sourceforge.net
Sent: Monday, October 8, 2007 6:35:05 PM
Subject: Re: [Firebird-net-provider] Problem with connection strig using Report
Manager
thanks
now it seems to work this way
section name=firebirdsql.data.firebirdclient
type=System.Data.Common.DbProviderConfigurationHandler,
System.Data,
Version=2.5.0.0, Culture=neutral,
PublicKeyToken=3750abcc3150b00c /
and
add name=FirebirdClient Data Provider
invariant=FirebirdSql.Data.FirebirdClient
description=.Net Framework Data Provider for
Firebird
type=FirebirdSql.Data.FirebirdClient.FirebirdClientFactory,
FirebirdSql.Data..FirebirdClient,
Version=2.5.0.0, Culture=neutral,
PublicKeyToken=3750abcc3150b00c /
thanks
- Original Message
From: Jiri Cincura [EMAIL PROTECTED]
To: For users and developers of the Firebird .NET providers
firebird-net-provider@lists.sourceforge.net
Sent: Monday, October 8, 2007 6:29:22 PM
Subject: Re: [Firebird-net-provider] Problem with connection strig using Report
Manager
On 10/8/07, Mr. John [EMAIL PROTECTED] wrote:
section name=firebirdsql.data.firebirdclient
type=System.Data.Common.DbProviderConfigurationHandler,
System.Data,
Version=2.5.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089 /
And there should be 2.0.0.0 etc., 'cause you're adding record
for
type=System.Data.Common.DbProviderConfigurationHandler... and not
for FB.
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now http://get.splunk.com/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Moody friends. Drama queens. Your life? Nope! - their life, your story.
Play Sims Stories at Yahoo! Games.
Check out the hottest 2008 models today at Yahoo! Autos.
http://autos.yahoo.com/new_cars.html-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now http://get.splunk.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] Problem with connection strig using Report Manager
Hello: I have I silly question : do I have to make this configuration on every computer that I install my application ? DDES is for devel only but anyway you can put it on your App.config file -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.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] Enlisting transaction
Hello:
Is this something like what you are doing ??
using (TransactionScope scope = new TransactionScope())
{
using (FbConnection connection = new
FbConnection(@DataSource=localhost;Database=C:\Program Files
(x86)\Firebird\Firebird_2_1\examples\empbuild\employee.fdb;UserID=SYSDBA;Password=masterkey;Enlist=true))
{
DataSet ds1 = new DataSet();
DataSet ds2 = new DataSet();
using (FbDataAdapter adapter1 = new FbDataAdapter(SELECT * FROM
Customer, connection))
{
adapter1.Fill(ds1);
}
using (FbDataAdapter adapter2 = new FbDataAdapter(SELECT * FROM
Employee, connection))
{
adapter2.Fill(ds1);
}
}
}
--
Carlos Guzmán Álvarez
Vigo-Spain
Blog: http://carlosga.wordpress.com/
FirebirdClient : http://www.firebirdsql.org/
XMPP Client : http://code.google.com/p/xmppclient/
ohloh : http://www.ohloh.net/accounts/4138
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now http://get.splunk.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] Enlisting transaction
On 10/8/07, Carlos Guzmán Álvarez [EMAIL PROTECTED] wrote:
Hello:
Is this something like what you are doing ??
I have generated DataSet and TableAdapter from DataSet Designer. But
yes. In basic this is what I'm doing. Two TableAdapters in one
TransactionScope.
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now http://get.splunk.com/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Firebird and Threads
I am using the Firebird .Net driver for database io in Visual Studio 2005 .Net 2.0 C#. I have three different threads accessing data. I keep getting Dynamic SQL Error Exceptions. The error is fairly random but usually involves an odd character out of place for a field or table name, resulting in an error. I have tried using a separate connections for each thread, and I have tried putting all database IO inside Monitor.Enter()/Monitor.Exit blocks, but the error still occurs. If I put all my code into one thread and run things sequentially the errors go away. I get these errors using a server or embedded. As far as I can tell, this type of access should be safe as long as I use a unique connection in each thread. I have tried the some thing with SQL Server 2005 but could not duplicate the error. Is there a thread-safe way to access data using Firebird .Net? - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.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] Firebird and Threads
Peter Gissel wrote: I am using the Firebird .Net driver for database io in Visual Studio 2005 .Net 2.0 C#. I have three different threads accessing data. I keep getting Dynamic SQL Error Exceptions. The error is fairly random but usually involves an odd character out of place for a field or table name, resulting in an error. I have tried using a separate connections for each thread, and I have tried putting all database IO inside Monitor.Enter()/Monitor.Exit blocks, but the error still occurs. If I put all my code into one thread and run things sequentially the errors go away. I get these errors using a server or embedded. As far as I can tell, this type of access should be safe as long as I use a unique connection in each thread. I have tried the some thing with SQL Server 2005 but could not duplicate the error. Is there a thread-safe way to access data using Firebird .Net? Each connection can only have one command executing at once, but you should be using connection pooling anyway (i.e. open connection; execute command; close connection) so that shouldn't ever be a problem. What is the code you're using to generate the commands? and when you get the error, what does the statement look like? Dean. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
