Re: [Firebird-net-provider] web application sample

2008-06-18 Thread Mercea Paul
Hi all

I have solved this problem!
In web.config my settings was wrong!Correct values are:

roleManager enabled=true defaultProvider=AlmWebrp
providers
add name=AlmWebrp
type=FirebirdSql.Web.Providers.FbRoleProvider,
   FirebirdSql.Web.Providers,
   Version=2.1.0.0, Culture=neutral,
   PublicKeyToken=3d06a02581b682f8
connectionStringName=AlmexaWebcs/
  /providers
/roleManager
authentication mode=Forms
/authentication
membership defaultProvider=AlmWebms
userIsOnlineTimeWindow=20
providers
add name=AlmWebms
type=FirebirdSql.Web.Providers.FbMembershipProvider,
 FirebirdSql.Web.Providers, 
 Version=2.1.0.0, Culture=neutral,
 PublicKeyToken=3d06a02581b682f8 
 connectionStringName=AlmexaWebcs 
 enablePasswordRetrieval=false 
 enablePasswordReset=true 
 requiresQuestionAndAnswer=false 
 applicationName=/ requiresUniqueEmail=false 
 passwordFormat=Hashed maxInvalidPasswordAttempts=5 
 minRequiredPasswordLength=5 
 minRequiredNonalphanumericCharacters=0 
 passwordAttemptWindow=10 passwordStrengthRegularExpression=
/
/providers
/membership


Best regards,
Paul


 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf
 Of Mercea Paul
 Sent: 17 June 2008 21:27
 To: [EMAIL PROTECTED]; 'For users and developers of the Firebird .NET
 providers'
 Subject: Re: [Firebird-net-provider] web application sample
 
 Hi Arnaud
 
 Something is wrong with my web.config...pointing to sqlserver
 somehow...
 I'll generate new one, tomorrow !
 
 If I can't make this work I'll be back with questions...
 
 Thank you all!
 
 Best Regards,
 Paul
 
  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED] On
 Behalf
  Of le roy arnaud
  Sent: 17 June 2008 17:29
  To: firebird-net-provider@lists.sourceforge.net
  Subject: Re: [Firebird-net-provider] web application sample
 
  Jiri Cincura wrote:
 
   On Tue, Jun 17, 2008 at 3:58 PM, Mercea Paul
 [EMAIL PROTECTED]
   wrote:
   Do you have some sample project about how can I use
 CreateUserWizard
  and
   all other components from Login Tab from Tools in VS 2005/2008!
  
   Sorry I don't. I have only one ASP.NET project using membership
 etc.
   stuff ant this is using the old one version of WebProviders (before
   rewritten by Le Roy Arnaud). :(
  
   I have configured Membership provider and role provider but I get
  always
   errors on execution!
  
   Look at Event Log, errors from WebProviders are written there.
  
 
 
  i use it in a lot of projects , what are yours errors ?
 
  --
  Le Roy Arnaud
  Menlog informatique (www.menlog.com)
 
  -
 --
  --
  Check out the new SourceForge.net Marketplace.
  It's the best place to buy or sell services for
  just about anything Open Source.
  http://sourceforge.net/services/buy/index.php
  ___
  Firebird-net-provider mailing list
  Firebird-net-provider@lists.sourceforge.net
  https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
 
 
 
 ---
 --
 Check out the new SourceForge.net Marketplace.
 It's the best place to buy or sell services for
 just about anything Open Source.
 http://sourceforge.net/services/buy/index.php
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider



-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


[Firebird-net-provider] Firebird web provider - session table

2008-06-18 Thread Mercea Paul
Hi

In session table LOCKED field is BOOL type (domain bool)?

Can be made domains for all fields?Can I provide a script for this?

Best regards,
Paul
-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php___
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 web provider - session table

2008-06-18 Thread Jiri Cincura
On Wed, Jun 18, 2008 at 4:00 PM, Mercea Paul [EMAIL PROTECTED] wrote:
 Can be made domains for all fields?Can I provide a script for this?

Yes, of course.

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
___
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 web provider - session table

2008-06-18 Thread Mercea Paul
Hi Jiri

All fields will get a domain, but with PK will be a little problem (is used
in several SP)...for that I'll try to get a solution later!
I'll send e-mail with the script file!

Best regards,
Paul

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf
 Of Jiri Cincura
 Sent: 18 June 2008 17:09
 To: For users and developers of the Firebird .NET providers
 Subject: Re: [Firebird-net-provider] Firebird web provider - session
 table
 
 On Wed, Jun 18, 2008 at 4:00 PM, Mercea Paul [EMAIL PROTECTED]
 wrote:
  Can be made domains for all fields?Can I provide a script for this?
 
 Yes, of course.
 
 --
 Jiri {x2} Cincura (CTO x2develop.com)
 http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
 
 ---
 --
 Check out the new SourceForge.net Marketplace.
 It's the best place to buy or sell services for
 just about anything Open Source.
 http://sourceforge.net/services/buy/index.php
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider



-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
___
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 web provider - session table

2008-06-18 Thread Jiri Cincura
On Wed, Jun 18, 2008 at 4:13 PM, Mercea Paul [EMAIL PROTECTED] wrote:
 Hi Jiri

 All fields will get a domain, but with PK will be a little problem (is used
 in several SP)...for that I'll try to get a solution later!

You can create script for FB2.1 where you can use domains in SPs.
-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
___
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 web provider - session table

2008-06-18 Thread Mercea Paul
 You can create script for FB2.1 where you can use domains in SPs.

[PM] 
Isn't more simple if I extract metadata for an empty database?
This way every one can create a database with all domain, tables, SP!


 Jiri {x2} Cincura (CTO x2develop.com)
 http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
 
 ---
 --
 Check out the new SourceForge.net Marketplace.
 It's the best place to buy or sell services for
 just about anything Open Source.
 http://sourceforge.net/services/buy/index.php
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider



-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
___
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 web provider - session table

2008-06-18 Thread Jiri Cincura
On Wed, Jun 18, 2008 at 4:22 PM, Mercea Paul [EMAIL PROTECTED] wrote:
 Isn't more simple if I extract metadata for an empty database?
 This way every one can create a database with all domain, tables, SP!

If the current structure of files will be kept (because not everybody
is using complete set of providers), I don't see any problem with
this.

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


[Firebird-net-provider] Transsactionscope NoWait

2008-06-18 Thread Félix González
I´m using FirebirdClient - ADO.NET 2.0 Data Provider.

How can create a transactionscope with NaWait?. I´m using
TransactionOption.timeout with Timeout= 5 seg. But if I update the same
record with other program (IBExpert). The .NET application wait until the
Ibexpert transaction are committed and change the record again.

I want that .Net application raise an exception.

 

I know that I cand do it using a FBtransaction with
FBTransactionOption.NoWait, but can I do it with transactionscope?

 

Thanks

 

-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Error Messages

2008-06-18 Thread Jiri Cincura
On Wed, Jun 18, 2008 at 7:51 PM, Giovanni Costa Rosa
[EMAIL PROTECTED] wrote:
 Ok, i got the source from the SVN, installed Microsoft Entity framework Beta
 3 and tryed to compile, but i'm getting the following error:

 Error9The type or namespace name 'DbFunctionCommandTree' could not
 be found (are you missing a using directive or an assembly reference?)
 C:\FirebirdNETProvider\NETProvider\source\FirebirdSql\Data\Entity\SqlGenerator.cs
 54444FirebirdSql.Data.FirebirdClient

 Any references that i should add?

You don't need EF. Just remove ENTITY_FRAMEWORK symbol.

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Transsactionscope NoWait

2008-06-18 Thread Jiri Cincura
On Wed, Jun 18, 2008 at 7:46 PM, Félix González
[EMAIL PROTECTED] wrote:
 How can create a transactionscope with NaWait?. I´m using
 TransactionOption.timeout with Timeout= 5 seg. But if I update the same
 record with other program (IBExpert). The .NET application wait until the
 Ibexpert transaction are committed and change the record again.

AFAIK you cannot use timeout for command, 'cause FB doesn' support it.

But for TransactionScope you can use overloaded ctor
http://msdn.microsoft.com/en-us/library/ms149851.aspx and pass as
param transaction created with FB options.

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


[Firebird-net-provider] Regarding connection speed with .Net

2008-06-18 Thread Kixzo Database Team
Hello all,

 

I have installed Firebird 2.0 (server) in a system. Now, I am trying to
connect it via .Net Provider using FBConnection.Open() from the same system.

 

What should be the reason of the connection established with server is so
time consuming (approximately 3 to 4 seconds)?

 

Following are some information that can be helpful to solve the problem.

 

Server is on 192.168.0.8 and client application is on the same machine. 

Firebird Server Version : 2.0.1.12855
FirebirdSql.Data.FirebirdClient.dll : 2.0.1.0

Ping result.

Pinging 192.168.0.8 with 32 bytes of data:

Reply from 192.168.0.8: bytes=32 time1ms TTL=128
Reply from 192.168.0.8: bytes=32 time1ms TTL=128
Reply from 192.168.0.8: bytes=32 time1ms TTL=128
Reply from 192.168.0.8: bytes=32 time1ms TTL=128

Ping statistics for 192.168.0.8:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),

Approximate round trip times in mille-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

Tracer

Tracing route to pc8.mshome.net [192.168.0.8]

over a maximum of 30 hops:
1 1 ms 1 ms 1 ms 192.168.0.8 
Trace complete.


Network Analyzer:

Into network analyzer during con.open(), I am not getting any network
movement into the network analyzer.

I hope this can help us to resolve the issue.

 

Regards,

Jay

 http://www.4colordesign.com http://www.4colordesign.com

 

-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] [ Regarding connection speed with .Net

2008-06-18 Thread Nobuya Higuchi
Hi,

I had a similar problem before. In my case, it took more than 10 seconds to 
open a connection.
It was a network setting problem but it took me so long to find out the 
remedy. The chance is, probably we do not share the same cause, so I do not 
get into the detail at first. Instead, let me ask you a question:

Do you switch the network settings on the problematic client machine, say by 
using netsh commands, trying to use two separate networks?
I did, and in my case, the cause of the slow connection was neglecting to 
delete dns settings on the tail-side network with which I tried to connect 
to FB.

Nobuya 


-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Regarding connection speed with .Net

2008-06-18 Thread Jiri Cincura
On Wed, Jun 18, 2008 at 3:12 PM, Kixzo Database Team
[EMAIL PROTECTED] wrote:
 What should be the reason of the connection established with server is so
 time consuming (approximately 3 to 4 seconds)?

It's problem with your network configuration.

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider