Re: [Firebird-net-provider] SQL scripts for ASP.NET stuff

2006-10-13 Thread Steve Ramacher
>ok i will correct the script with your modification, and i modify the >membership_createuser to add the passwordanswer because i forget this >param. >> All of my previous complaints have now been resolved, except the web >> parts profile provider which I will investigate tomorrow as I have not

Re: [Firebird-net-provider] slow connection

2006-10-13 Thread Carlos Guzmán Álvarez
Hello: > > This seems to load ALL of the rows of each table since when I comment > out the largest table (orderitems = 1+ million rows) the load time > becomes much quicker. > If you are using a SELECT * FROM TABLE_NAME that is what is should be doing you will need to parametrize the query

Re: [Firebird-net-provider] slow connection

2006-10-13 Thread marzena
> Subject: [Firebird-net-provider] slow connection > I have the relationships set between the tables and the > controls display the > correct information, however VERY slowly. The form takes > several minutes to > open and is several seconds to change customers. > > I do a TableAdapter.Fill for

Re: [Firebird-net-provider] slow connection

2006-10-13 Thread Rick Roen
I realize that I don’t need that many rows.   I want to narrow down the rows I query to ONLY the ones for the current order.   I thought I was doing this by setting the relationship between the two tables, but no.   The question is how do I go about getting only these rows.  Do I have

Re: [Firebird-net-provider] slow connection

2006-10-13 Thread paul.mercea
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 RoenSent: Friday, October 13, 2006 5:04 PMTo: firebird-net-provider@lists.sourceforge.ne

[Firebird-net-provider] slow connection

2006-10-13 Thread Rick Roen
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

Re: [Firebird-net-provider] FirebirdClientFactory Problem

2006-10-13 Thread paha
>Strange, did you have a single version of the provider installed and >configured in the machine.config right ?? Usually i get only dlls from http://netprovider.cincura.net/, last time i got full installation of 2.0.1rc2, so i uninstalled previous version, and installed the new one. Registry and

Re: [Firebird-net-provider] Still problems with Firebird 2.0 and .NET 1.1

2006-10-13 Thread pablosantosluac
Hi again Carlos, As Rubén said earlier today, we can't make the provider work with Firebird 2.0. We can now compile, but no way to run it correctly? Is there anything missing from the CVS? Is it really a fixed problem? Thanks, pablo - Original Message - From: "Carlos Guzmán Álvarez" <

Re: [Firebird-net-provider] NETProvider_20\build\win32\ado.net cleanup

2006-10-13 Thread Jiri Cincura
Carlos Guzmán Álvarez wrote: > Looks as working i have committed the changes into CVS OK. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Using Tomcat but need to do more? Need to support we

Re: [Firebird-net-provider] NETProvider_20\build\win32\ado.net cleanup

2006-10-13 Thread Carlos Guzmán Álvarez
Hello: > Hi, here's a little changes build config. There's no change in > functionality. I've only moved build-tests to the higher level (for > easier night builds) and I've renamed 'build' to 'build-provider' (to > reflect semantics). > > Test it, if it's OK for you and if so, upload it to CVS.

Re: [Firebird-net-provider] FirebirdClientFactory Problem

2006-10-13 Thread Carlos Guzmán Álvarez
Hello: > And yes, i use FbProvider ver 2.0.1 RC2 Strange, did you have a single version of the provider installed and configured in the machine.config right ?? -- Carlos Guzmán Álvarez Vigo-Spain - Using Tomcat but need

Re: [Firebird-net-provider] SQL scripts for ASP.NET stuff

2006-10-13 Thread Le roy Arnaud
> As a solution we can provide a script with the full database, and separate > scripts for each provider( without create database statement ) > I think is a good solution. - Using Tomcat but need to do more? Need to support

Re: [Firebird-net-provider] SQL scripts for ASP.NET stuff

2006-10-13 Thread Carlos Guzmán Álvarez
Hello: > Well, maybe there should be at least comment for people, who not want to > create all tables (don't thinking why). As a solution we can provide a script with the full database, and separate scripts for each provider( without create database statement ) -- Carlos Guzmán Álvarez Vigo-Sp

Re: [Firebird-net-provider] SQL scripts for ASP.NET stuff

2006-10-13 Thread Jiri Cincura
Le roy Arnaud wrote: >> Why all together? When user would create only tables and procedures for >> RoleProvider, he will just run RoleProvider.sql (for example). >> >> If everything will be in one file, he will have to comment some parts and >> it'S not good, IMHO. > > because there are some dep

Re: [Firebird-net-provider] SQL scripts for ASP.NET stuff

2006-10-13 Thread Le roy Arnaud
> Why all together? When user would create only tables and procedures for > RoleProvider, he will just run RoleProvider.sql (for example). > > If everything will be in one file, he will have to comment some parts and > it'S not good, IMHO. because there are some dependance between the diferent p

Re: [Firebird-net-provider] Exception when running a query

2006-10-13 Thread Julien Ferraro
Carlos Guzmán Álvarez a écrit : > Hello: >> Carlos, I=92ve sent you a test project some time ago to show you a = > >> strange bug I=92ve found. >> >> I=92ve sent it to your address at mundo-r. Can you confirm that you = > >> received it and tell me if you where able to reproduce ? >> > I think i

Re: [Firebird-net-provider] SQL scripts for ASP.NET stuff

2006-10-13 Thread Jiri Cincura
Le roy Arnaud wrote: > I think that should be better to make a simple file that create all the > tables and all stored proc ! Why all together? When user would create only tables and procedures for RoleProvider, he will just run RoleProvider.sql (for example). If everything will be in one file,

Re: [Firebird-net-provider] Still problems with Firebird 2.0 and

2006-10-13 Thread Rub�n de Alba
We have donwloaded again the code and now we can compile, but we get the same exception: System.IndexOutOfRangeException: Índice fuera de los límites de la matriz. at FirebirdSql.Data.Common.IscHelper.VaxInteger(Byte[] buffer, Int32 index, Int32 length) at FirebirdSql.Data.Common.IscHelp

Re: [Firebird-net-provider] SQL scripts for ASP.NET stuff

2006-10-13 Thread Le roy Arnaud
I think that should be better to make a simple file that create all the tables and all stored proc ! - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated tec

Re: [Firebird-net-provider] Membership Provider

2006-10-13 Thread Le roy Arnaud
> I have finally had time to dig in and figure out what is going on with > the membership provider. There is nothing wrong with the provider, and > it seems to be in the database scripts. I found that when the > MEMBERSHIP_CREATEUSER sp was being called, it was accepting the > parameters for PASSWO