Hi
Using VS2005 C# and Firebird .Net provider 2.0.1.
I put on form FbConnection and I try to use from ApplicationSettings the
ConnectionString property to select my configured connection string and I
get this error:
Object of type
I installed Firebird .Net provider 2.1.0 Beta 1.
I get same error.
Mercea Paul wrote:
I put on form FbConnection and I try to use from ApplicationSettings the
Why don't you use .NET 2.0 objects to create connection?
I set connection string in Properties.Settings.Default.AppConnStr
(Settings
-provider] I get error when i try to assign
connectionstring setting to FBConnection
Mercea Paul wrote:
I don't mean FBTableAdapter. TableAdapter get his connection from
fbconnection1.
Try this.
In your project on Settings define new setting as ConnStr, type
(ConnectionString) and put your
Hi Carlos
I sended to Jiri address!
Thanks,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Carlos Guzmán Álvarez
Sent: Tuesday, January 09, 2007 4:22 PM
To: For users and developers of the Firebird .NET providers
Subject: Re:
Hi
I am using aleases for fb database like this:
Dboperation=D:\database\operation.fdb
I make conection like :
connectionString=data source=192.168.1.250;initial catalog=
Dboperation;user id=SYSDBA;password=masterkey
If I make backup like
fbbsvc.ConnectionString = connectionString;
the backup file I found in system32 folder.
You can insert here the absolute path...
I don't want to use absolute path, different system have different
partitions for data.Maybe one more parameter, as backup file, ...
There is a way to found database path on server from alias?
I don't
Hi
FB2 SS, Firebird .Net provider 2.1.0, VS2005 c#.
I have in database one procedure like this:
CREATE PROCEDURE SYS_GET_PARAM (
psubsystem char(3),
pcode varchar(30) character set iso8859_2)
returns (
pval varchar(30) character set iso8859_2)
as
begin
select pvalue from
Hi Carlos
I try putting @ before params and I get :
Additional information: arithmetic exception, numeric overflow, or string
truncation
I tested in dataset-Preview data, works ok, as procedure or sql.
It's not working from code!
-Original Message-
From: [EMAIL PROTECTED]
In tabel structure luook like
VARCHAR(30) CHARACTER SET ISO8859_2 COLLATE ISO8859_2.
This could be the problem?
I do I try to modify to none!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Carlos Guzmán Álvarez
Sent: Thursday, January 11, 2007
Carlos
I try putting @ before params and I get :
Additional information: arithmetic exception, numeric overflow, or
string
truncation
I tested in dataset-Preview data, works ok, as procedure or sql.
It's not working from code!
What is the character set you are using ??
I have
Mercea Paul wrote:
I have meet same problem.
SQL generated for update with designer generate error.
For Autonumber fields I modify allownull to true, and is autonumber
to true.
For update statement, I have deleted all where blab la bla, and let
only
where [EMAIL PROTECTED
Let's clarify this a little.
You have table with PK ID, the ID is generated by generator in trigger,
right?
If you insert the row into grid you get error because ID is null,
right?
Right!
-
Take Surveys. Earn Cash.
Sorry what is the one you are using in the connection string ??
Coonection string :
connectionString=data source=192.168.1.250;initial catalog=gestiny;user
id=SYSDBA;password=masterkey providerName=FirebirdSql.Data.FirebirdClient
/
Well, this is a problem by design.
The MS SQL has identity, which is in fact something like
autoincrement id.
This is a property of column. But FB has more powerfull (OK, little bit
PR)
generators. But bind between column and (trigger and) generator cannot
be
discovered easily.
So if
Verry usefull, thanks!
Mention that, it's working only if u are connected to database!
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Jiri Cincura
Sent: Saturday, January 13, 2007 2:34 PM
To: For users and developers of the Firebird
So Paul, if you need this, read FbDatabaseInfo DbId property. ;)
FbDatabaseInfo DbId works...if connection is open or zou get error
messageAdditional information: Connection must valid and open
Returned info looks strange:
CPTPAUL.cptpaul:C:\DATABASE\dev.FDB
And my connection looks like
data
Returned info looks strange:
CPTPAUL.cptpaul:C:\DATABASE\dev.FDB
And my connection looks like
data source=192.168.1.250;initial catalog=gestiny;user
id=SYSDBA;password=masterkey.
Seems like is some dns reverse and get my computer name...:D
Try ipconfig /all, there you will see
Hi
You cant think to have a function in your exe who verify if exist all
dependencies.
If user download your exe, if does not have all *.dll you can download that
file. If you make new version of your application, user download only exe ,
not 'all' files.
Regards,
Paul
From: [EMAIL
I was getting in same problem few months. It was something from registry!!!
I deleted all registry info for provider and after that reinstall the
provider!
Try to reinstall Firebird .Net data provider version 2.1.0 beta
http://prdownloads.sourceforge.net/firebird/FirebirdClient-2.1.0-Beta1.exe?d
This happens because it's bad registry settings. U need to relete these
settings, and reinstall the provider.
For me works.
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Alex PAJON
Sent: Friday, January 19, 2007 3:38 PM
To: 'For
Connection string should looks like:
connectionString=data source=server_name_or_ip;initial
catalog=database_name;user id=SYSDBA;password=masterkey
providerName=FirebirdSql.Data.FirebirdClient
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
Did you have modify machine.config?
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Félix González
Sent: Monday, February 05, 2007 8:49 PM
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider] Problems with DDEX
Hi,
I´ve VS2005 profesional,
For
am hitting an SP which contains 20 return parameters. for this particular
routine i only need to return data from 3 of the 20 return parameters. i can
achieve this by manually constructing an sql like this: SELECT ColumnA,
ColumnB, ColumnC FROM sp_1(?).
Yes, you can do this !
Command should
Please ignore
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT business topics through brief surveys-and earn cash
Firebird runs query like this:
select * from table where field is null
This is the case?
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Carlos Guzmán Álvarez
Sent: Tuesday, February 13, 2007 8:32 PM
To: For users and developers of
Just a hint...
Have you tested passing parameter?
Select *... where cc.id = @id_par
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Sylvain
Sent: Friday, February 16, 2007 1:27 PM
To: firebird-net-provider@lists.sourceforge.net
If I remember well for Windows is known the order of searching DLL file.
First step is to search application path, after that system library path
(system32) after that OS path (Windows or WINNT). You can deliver your
application with fbclient library you want/need in application path!
Correct me
value without knowing param name, only his position sql statement!
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Intelrullz
Sent: Thursday, March 01, 2007 6:34 PM
To: Mercea Paul
Subject: [Firebird-net-provider] Îòã: Running
Hi
Just a hint, I think you need to verify gds32.dll version from system32 .
If you made all operations on that machine, could you have the old gds32.dll
from previos IB6 instalation.
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of
I can't reproduce the error! Tested with FB1.5.4 and 2.0.1 and works!
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of sasha
Sent: Tuesday, March 06, 2007 1:31 PM
To: firebird-net-provider@lists.sourceforge.net
Subject: Re:
Hi
Scenario is this.VS2005 C# and FB2.0.
I have created an utility for backoffice management .This utility is for
administrators (application administrators) and intend to access some
operations unavailable from back office interface.Some operations are
directly on database (FB 2.0 SS) others
Hi sasha
You can see that screenshots at
http://article.gmane.org/gmane.comp.db.firebird.russian/17822
What tool did you use there?
Regards,
Paul
-
Take Surveys. Earn Cash. Influence the Future of IT
Join
No, you can't!
Deleted records space cannot be take back. Only back-up and restore can do
that.
From your example is not quite normal to have this difference between
database before backup and databse after restore.
Please take a look to your database statistic at:
Generation
I would create a upgrade script for new tables!
There's not to mouch table to modify applications in month...
With VS It could be made in minutes (upgrade from old to new tables)
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Jiri
Why you need to know generator value before insert?
Regards,
Paul
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Kai Bohli
Sent: Monday, May 07, 2007 9:17 PM
To: For users and developers of the Firebird .NET providers
Subject: [Firebird-net-provider] Issue with .net
]
[mailto:[EMAIL PROTECTED] On Behalf Of
Mercea Paul
Sent: 8. mai 2007 13:13
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Issue with .net provider to work with a
Firebird generator
Why you need to know generator value before insert?
Regards
How is your connection string?
Servername:databse or serverip:database?
Regards,
Paul
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
John Smith
Sent: Tuesday, May 08, 2007 6:35 PM
To: For users and developers of the Firebird .NET providers
Subject: [Firebird-net-provider]
Query cancelation will be in FB 2.1 as I know!
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Jan Bofinger
Sent: Thursday, May 10, 2007 5:00 PM
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider]
If u can't debug, put into a log file and write every step!
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of [EMAIL PROTECTED]
Sent: Monday, May 14, 2007 12:50 PM
To: For users and developers of the Firebird .NET providers
Try this:
Select Type from TableName
Type is reserved word as I remember.
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Dan Cooperstock
Sent: Thursday, May 31, 2007 10:27 PM
To: firebird-net-provider@lists.sourceforge.net
Subject:
Hi
I face with this situation:
Some customers want to have reports or export 'patterns' from fb database.
For that I have some possibilities as sql query or stored procedures. For
query I make all by code. For stored procedures I have 2 situation, first,
SP exist in database, second SP not
Thank you all for responses!
Anyway, 2 query is needed to get the results. 1 to see if SP exist 1 to run.
Best is to have a stored proc or function to give a true or false result for
me.
Thanks again,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Hi Carlos, Jiri
Could Fb.Net Provider have release number specific to Firebird server?
If Current provider support all facilities for FB 2.1 Beta 1, could have
same release number as fb server (2.1)? It's more easy to know what provider
is compatible with witch server!
Maybe I'm wrong...
Best
Oleg Deribas wrote:
Hello,
So, _unless_ there is coordinated release plan for the whole Firebird
Project _and_ the release dates will be met by all subproject under any
condition, tieing the driver release numbers to the Firebird RDBMS
release numbers is not reallistic.
Roman
I
Try rename fbembed.dll into fbclient.dll and try again!
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Bob K.
Sent: Thursday, July 19, 2007 7:34 PM
To: For users and developers of the Firebird .NET providers
Subject: Re:
-provider] [PHISH] Re: Visual
C#andFirebirdembeddeddatabase connection failure
Paul,
renaming didn't change anything.
- Original Message -
From: Mercea Paul [EMAIL PROTECTED]
To: 'For users and developers of the Firebird .NET providers'
firebird-net-provider@lists.sourceforge.net
Can't be made a 'copy' of sln file? Like
FirebirdSql.Data.FirebirdClient2008.sln!
Like that it can be open with both VS !!!
Best Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Carlos Guzmán Álvarez
Sent: Saturday, August 04, 2007
PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Jiri Cincura
Sent: Saturday, August 04, 2007 9:13 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Update of Visual Studio
solition/project files on svn trunk
On 8/4/07, Mercea Paul [EMAIL
Do you meen something like UDF\ib_udf.sql and fbudf.sql???
In FB2.1 in udf dir is ib_udf2.sql and fbudf.sql with new ones!
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Carlos Guzmán Álvarez
Sent: Saturday, August 04, 2007 5:00 PM
Hi
Why don't you use a stored procedure for this?
For FB2.X in doc section in README.returning.txt you can find this:
INSERT INTO T2 (F1, F2)
VALUES (1, 2)
RETURNING ID INTO :PK;
This return desired value, that you can insert in second table!
Regard's
Paul
-Original
Hi
If you use IBExpert,DBWorkbench,FlameRobin,ISQL or another tool can you run
without errors the select command on vpn network?
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Alex Castillo
Sent: Wednesday, February 06, 2008 4:21 AM
Hi all
A good start is here:
http://msdn2.microsoft.com/en-us/library/aa697428(VS.80).aspx
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Ramacher, Steve
Sent: Tuesday, February 19, 2008 6:53 PM
To:
Hi all
I have updated Firebird Client from svn and I try to build with VS2008 but
I get this errors:
Error 2
'FirebirdSql.Data.FirebirdClient.FbProviderServices.GetDbInformation(string,
System.Data.Common.DbConnection)': no suitable method found to override
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Aitor Gómez González
Sent: Thursday, February 28, 2008 1:51 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Why FbDataReader.HasRows returns
Hi Jiri
Cancelation of query in FirebirdClient makes sense only via API. And
for MON$xxx this must be done using another connection. And only on
FB2.1.
In fact, you can easily extend your class to do this. I don't think,
this is issue of FirebirdClient until it's not in API.
I have read
Hi all
Using VS2005, c#, FB1.5.4 and Fb.Net Provider 2.1!
I try to execute from a sql file a procedure ddl using FbScript and
FbBatchExecution, but I get errors in 2 situations!
1.Without FbTransaction:
An exception was thrown when executing command: CREATE OR ALTER PROCEDURE
REPORT_DATA (
Hi Jiri
Are you able to run the script via isql under same connection
(chraset, dialect, server, etc.)?
I have run successfully from IBExpert. The sql file is the DDL statement
from IBExpert.
I have try to execute another sql file with domain ddl definitions and I get
same error from
I have a procedure to verify if a SP exist in database, code looks
like:
Have you given a try using FbConnection.GetSchema ??
Yes, but its little complicated!I'll try to make this work with GetSchema!
Regards,
Paul
Hi Paul, it is not ExecuteScalar, that is guilty, but you ;) .
Look at this code
fbcommand.ExecuteScalar().ToString().Trim()
think about it - if there is no procedure with such name, null will be
returned. And now you try to call null.ToString(). Sure you get
exception.
You should check
I have tested with database creation...and surprise, it works:
I have added :
try
{
FirebirdSql.Data.FirebirdClient.FbConnection.DropDatabase(rtbConnection.Text
);
FirebirdSql.Data.FirebirdClient.FbConnection.CreateDatabase(rtbConnection.Te
xt, 8192, true, true);
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Jiri Cincura
Sent: Wednesday, March 05, 2008 11:20 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] I get error using FbScript and
FbBatchExecution
On 3/5/08, Mercea Paul [EMAIL PROTECTED
The results method is from FbScript class, has nothing to do with fb server.
The problem is about how is read the sql file and how is processed each
command!
SQL file, in my case, was generated by IBExpert, on windows! I have executed
Sql file with IBExpert,DBWorkbech, EMS SQL Manager, FlameRobin
I think, you have problem on both sides. AFAIR you're working in
dialect 1, so this gives you some problems. And you have also some
problems in your C# code, but I'm pretty sure, that's not provider's
issue. :)
I have found the problem!
In my code default dialect is not specified and I
Hi all
Using VS2005 c#, FB 2.1 embeded, Fb.Net 2.1.0 provider.
I try to port some off my old application from Delphi and dbf files to c#
and fbembeded.
I try to keep existing folders as they are and I have added new folder for
fbembeded files.
When I run application I get error because
: [Firebird-net-provider] I get Error when I specify
ClientLibrary for embeded FB2.1
On 3/12/08, Mercea Paul [EMAIL PROTECTED] wrote:
The code works ok for me to but only if I have fbembed.dll in the
same
folder as my application!
But then you're not using ClientLibrary property as you said
Eliminating '.dll' extension doesn't make any difference!
Strange is the fact that I can't get in debug mode the error, I get error
message before any code line to be executed!
Thanks all,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Jiri
Hi all
I have tested with latest version (2.5 alpha 2) and works ok!
Thanks,
Paul
On 3/12/08, Mercea Paul [EMAIL PROTECTED] wrote:
Strange is the fact that I can't get in debug mode the error, I get
error
message before any code line to be executed!
This looks like your assembly
Your SP I would change in something like this:
CREATE PROCEDURE KI_SUCHEPERSONEN_HELP2(
SUCHNAME1 VARCHAR(200) CHARACTER SET WIN1252,
BEREICH VARCHAR(10) CHARACTER SET WIN1252
) AS
DECLARE VARIABLE v_id as integer;
BEGIN
FOR select IDPerson from personen
where
Hi
FB server 1.5 - 2.1 RC2,FB .Net provider 2.5, VS C# 2005
I have SP declared in database as :
CREATE OR ALTER PROCEDURE Balance (
UID integer,
startdate date,
enddate date)
returns (
UID integer,
uname varchar(50),
date_start date,
value_start numeric(15,4),
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Dean Harding
Sent: Wednesday, March 26, 2008 1:28 PM
To: For users and developers of the Firebird .NET providers
Subject: suspect - [SPAM] Re: [Firebird-net-provider] Where from I get
so many decimals?
Mercea Paul wrote:
If I execute
Hi
Using FB 1.5.5 SS , FB.Net provider 2.5, VS C#2005.
Database created with FB 1.5.3, ODS 10.1, Dialect 1.
I have a SP which is running fine like execute procedure
balance(@p1,@p2,@p3);
The same database, but under FB 2.1 RC2 (17755), running same SP I get this
error:
base
Hi Jiri
First try 2.1 FirebirdClient. The 2.5 has still unfinished work on 2.1
protocol changes. This can cause problems.
Same FB Client (2.5) run ok on FB 1.5.5 server!
I thought is a problem from ODS structure ... but isn't!
Regards,
Paul
Hi Hellen,
In Firebird 2 and higher you will get this exception if you have an
AFTER trigger that attempts to update a column in the table that owns
the trigger.
That table have 5 triggers, 3 for Before Insert, 1 for Before Delete and 1
for Before Update.
If I deactivate trigger from
Then your Before Delete trigger probably has a reference to
NEW.something. It is invalid in a delete trigger.
Trigger ddl is:
CREATE OR ALTER TRIGGER RPL_doc_invoice_BDEL FOR doc_invoice
ACTIVE BEFORE DELETE POSITION 1000
as
declare variable v_repl char(1);
begin
v_repl='N';
select
Of course not. A deleted record is, well, DELETED. If you want to
modify the record, then use UPDATE, not DELETE! ;-)
The migration FB 2.X will be very difficult!
This thread has become totally off topic for the net-provider forum but
I must say I'm curious to know what you thought you
Hi
Is there a way to specify for Backup service to use nbackup and make
incremental backup?
Regards,
Paul
-
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's
On 4/20/08, Mercea Paul [EMAIL PROTECTED] wrote:
Is there a way to specify for Backup service to use nbackup and make
incremental backup?
No. AFAIK nbackup isn't available thru Service API.
Nether I can find any link to api for nbackup..hope you know more!
This is a bad news...back
21/04/2008, Mercea Paul wrote:
On 4/20/08, Mercea Paul [EMAIL PROTECTED] wrote:
Is there a way to specify for Backup service to use nbackup and
make
incremental backup?
No. AFAIK nbackup isn't available thru Service API.
Nether I can find any link to api for nbackup..hope you know
yes, after 20 May I get all messages twice!
Bernhard Fischer wrote:
Same here - I'm pretty sure that I suscribed only once, but I also get =
the messages twice. This seems to happen since end of May or so.
Bernhard
Hi
How can I get only 1 copy of news message and not 2 of them? The
Try to do something like this:
1. Populate your datatable dt and then
ReportDocument rpt = new Rpt.rptD ();
rpt.SetDataSource((DataTable)dt);
Form frm_rpt = new frmReport(rpt);
frm_rpt.ShowDialog();
Regards,
Paul
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Hi
How can I get only 1 copy of news message and not 2 of them? The list admin
can delete one subscription , if I have 2 with same e-mail???
I have unsubscribed and subscribed to ensure I'm just once registered.but
always I get a duplicate for each message on this news group!
Regards,
Paul
Hi Rakesh
Show us your connection string !
Regards,
Paul
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Kixzo Database Team
Sent: 02 June 2008 14:14
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider] crystal report problem
Hello All,
Hi
Your report try to connect and get data ..you don't need that, you have
already populated your table!
All you need to do is to pass the tables to your report!
Try to run your code after comment this lines
conninfo.ServerName = pc205;
conninfo.DatabaseName =
Have you declared strlen?
DECLARE EXTERNAL FUNCTION STRLEN
CSTRING(32767)
RETURNS INTEGER BY VALUE
ENTRY_POINT 'IB_UDF_strlen' MODULE_NAME 'ib_udf';
Regards,
Paul
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: 04 June 2008 08:29
To:
Hi Jiri
I found few errors :
1.In FbMembershipProvider2.0.sql:
There is one extra space in PK_USERS name
ALTER TABLE USERS ADD CONSTRAINT PK_ USERS PRIMARY KEY (PKID);
In procedure CREATE PROCEDURE MEMBERSHIP_DELETEUSER (
Comment line
DELETE FROM USERSINROLES WHERE USERS
There's no
Hi Jiri
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!
I have configured Membership provider and role provider but I get always
errors on execution!
TIA
Paul
] 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
-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
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
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
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/ |
Hi all
I have few propositions about SP for web provider
1. In ROLES_ISUSERINROLE and ROLES_ISEXISTS is :
SELECT first(1) 1 FROM table INTO :RES;
I propose to change this to :
IF (EXISTS(SELECT 1 FROM table)) then RES=1;
2 SQL Statement like :
select
Hi
I try to build manually FB provider from
NETProvider\build\win32\ado.net\build.bat
but I get error in build.log:
[csc]
d:\ProjectsCVS\FireBird\NETProvider\trunk\NETProvider\source\FirebirdSql\Dat
a\Common\Charset.cs(25,14): error CS0234: The type or namespace name 'Linq'
does not exist
There is no logic to do this in one SP..
Select * from DoSomething will return a dataset corresponding for your
output parameters!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Javier Lozano
Sent: Friday, August 01, 2008 8:10 AM
To:
As I remember you can set the event port in firebird.conf...at least in FB
2.1
#
# The TCP Port Number to be used for server Event Notification
# messages. The value of 0 (Zero) means that the server will choose
# a port number randomly.
#
# Type: integer
#
#RemoteAuxPort = 0
Best regards,
Paul
ON (d.InvoiceID = i.InvoiceID)
join InvoicePayment p ON (p.InvoiceID = i.InvoiceID)
where (i.InvoiceID = :InvoiceID)
group by i.SiteID, i.InvoiceID
order by i.SiteID, i.InvoiceID
Regards,
Paul
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Mercea Paul
Sent: Wednesday, August
I think you can try with FbDatabaseInfo.PageSize !!!
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Michael Möhle
Sent: Wednesday, September 03, 2008 5:51 PM
To: firebird-net-provider@lists.sourceforge.net
Subject:
Try with FirebirdDDEXProviderPackageLess32 if you don't have VS SDK
installed!
Regards,
Paul
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Christian Nylund
Sent: Thursday, September 04, 2008 11:44 AM
To: Firebird-net-provider@lists.sourceforge.net
Subject:
Hi
I'm using 2.5 all ready in several projects.
As I know, 2.5 will provide .net entity provider ...
Do you need something else?
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Tetram Corp
Sent: Thursday, September 04, 2008 3:16 PM
After install you'll find README.TXT in firebird client ddex folder !
If this not helpful enough ask more help here!
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Freddy Caballero
Sent: Saturday, September 06, 2008 4:49 AM
To:
1 - 100 of 170 matches
Mail list logo