[Firebird-net-provider] Order of parameters to stored procedure

2007-11-14 Thread Shreekar Joshi 
Hi

 

While passing parameters to a stored procedure in .Net code, why is it
important to pass them in the same order as defined in the stored
procedure? Cannot the driver determine the correct order based on the
schema and the parameter names supplied?

 

Also, any parameter name is accepted as a valid name. This behaviour
seems consistent with the driver expecting the order to be correct
rather than the parameter names to be correct.

 

My question is: Is there any way in which I can stop worrying about the
order in which the parameters are defined and simply add all the
parameters with the correct names as in the schema via the Firebird.Net
provider?

 

Of course, all the above information could be completely wrong as it is
based on my limited knowledge of the Firebird database and the
Firebird.Net provider. 

 

Shreekar Joshi 
KPIT Cummins Infosystems Ltd.| Ph: +91 020 6652 5000 extn. 2001 
http://www.kpitcummins.com http://www.kpitcummins.com 
Disclaimer: This message contains information that may be privileged or
confidential and is the property of KPIT Cummins. It is intended only
for the person to whom it is addressed. If you are not the intended
recipient, you are not authorized to read, print, retain copy,
disseminate, distribute, or use this message or any part thereof. If you
receive this message in error, please notify the sender immediately and
delete all copies of this message. KPIT Cummins does not accept any
liability for virus infected mails.

 

-
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] Order of parameters to stored procedure

2007-11-14 Thread Jiri Cincura 
If you will use select ... from SP ... and not
CommandType.StoredProcedure, you can use named parameters.

Getting parameters names from stored procedure is possible, but it's a
one roundtrip to database, which isn't good for performace.

-- 
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] Order of parameters to stored procedure

2007-11-14 Thread Carlos 
Hello:

 While passing parameters to a stored procedure in .Net code, why is it
 important to pass them in the same order as defined in the stored procedure?

Because there is no way to know the correct order based only on the
parameter name ( remember that Firebird *hasn't* support for named
parameters, that is something implemented in the provider )



-- 
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] FbDataAdapter = DataSet

2007-11-14 Thread VS-Polis 
Hi Steve,
I created a similar solution CreateTypedDataset using standard NET 
methods and Firebird-SELECTs.
My solution creates a DataSet, calls the table definitions of the 
database, saves the DataSet's contents as xsd file, and creates the 
MyDataSet.Designer.cs. Clearly, you have other aims. But perhaps you can 
use my source code for your own solution.
The solution is published in 
http://www.mycsharp.de/wbb2/thread.php?threadid=27421. Please download 
the source files CreateTypedDataset.zip via 
http://www.mycsharp.de/wbb2/attachment.php?attachmentid=1661 and read 
DatabaseFirebird.cs, especially the SELECT-Commands.
If you need English translation for the comments, please write direct to 
post(at)vs-polis(dot)de.
Hope it helps a little bit,
Juergen

Steve schrieb:
 Hi All,

 I'm new to C# so I'm not sure I'm asking the correct question.  Is it
 possible to generate an object of type DataSet from the
 FirebirdNETProvider FbDataAdapter?  I see in the source where there's
 a GenerateDataset method but the class is defined as internal.  I'm
 writing a DAL and I'd like the public members to be of type DataSet so
 that if I ever have to switch database engines, I don't have to
 rewrite my client code.

 Thanks for any enlightenment,
 Steve
   

-- 

*_Juergen Thomas_*
Verlags-Software

Samlaendische Str. 3
13189 Berlin

Germany

Tel. (030) 94 39 96 38
oder (0700) VS–POLIS
/d.h. (0700) 87 07 65 47
/Fax (030) 94 39 96 40

http://www.vs-polis.de


-
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] [FB-Tracker] Created: (DNET-132) New FbConnection assigned to an existing FbCommand throws exception when used

2007-11-14 Thread Edward Winkelman (JIRA) 
New FbConnection assigned to an existing FbCommand throws exception when used
-

 Key: DNET-132
 URL: http://tracker.firebirdsql.org/browse/DNET-132
 Project: .NET Data provider
  Issue Type: Bug
  Components: ADO.NET Provider
 Environment: Windows XP, C#, .Net 2.0, Visual Studio 2005
Reporter: Edward Winkelman
Assignee: Carlos Guzman Alvarez


Create an FbCommand to insert/update a table with an open FbConnection object.  
Execute the FbCommand and then close the FbConnection and dispose of it.  Set 
the Connection property of the FbCommand to null.  Now create a new 
FbConnection, Open() it and then assign it to the FbCommand.  Attempt to run 
the FbCommand and you will receive the exception Command Connection is not 
equal to Transaction Connection. despite the fact that no transaction is being 
used other than the implicit transaction.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



-
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 integrating with VS 2005

2007-11-14 Thread Jiri Cincura 
What steps you've performed?

-- 
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] Problem integrating with VS 2005

2007-11-14 Thread Daniel Rail 
Hi,

I'm trying to integrate the DDEX in VS 2005, but I'm not being successful. 
I followed all the directions, even rebooted my computer, but no success.  I 
can use the ADO.Net components in a Windows Forms application without any 
problems.  But, I'm having difficulty trying to get it to work for ASP.Net 
and the DDEX integration.  The error that I'm getting when trying to add a 
connection is An unexpected error occurred in the .NET Framework Data 
Provider for Firebird.  Please contact the provider vendor to resolve this 
problem.  And, I don't see the connections dialog.  Also, I did install the 
VS 2005 SDK.

Any help would be appreciated.

Daniel Rail 



-
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 : Firebird integration with Visual Studio 2005

2007-11-14 Thread bilbey 

I have the same issue. My Regional Settings are Turkish, if I change it to
English, it works. 

I think is a string conversion issue related to CultureInfo in
Firebird.Data.FirebirdClient 2.0.1 or Firebird DDEX for .net2.0.


Muzaffer Bayramoglu wrote:
 
 
 Hi everyone ,
 
  I've vs2005 pro and .net framework 2.0 installed . Also i've
 installed vs2005 sdk ,
  firebird .net provider 2.0.1 and firebird ddex for .net2.0 .
 
  I can create adapters with only selects and query data within ide .
 But i cannot build insert , update , delete commands for tableadapter
 because it gives the error below .
 
 column 'is_system_table' does not belong to table Tables .
 
  Also when i want to browse my firebird db with server explorer ; it
 gives same the error .
 
  Any idea or suggestion ?
 
  Thanks,
 

 -
 Building a website is a piece of cake. 
 Yahoo! Small Business gives you all the tools to get online.
 -
 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
 
 

-- 
View this message in context: 
http://www.nabble.com/Problem-%3A-Firebird-integration-with-Visual-Studio-2005-tf4377554.html#a13754659
Sent from the firebird-net-provider mailing list archive at Nabble.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 integrating with VS 2005

2007-11-14 Thread Kevin Stanton 
Greetings,
This seems to be an on-going issue for many (including me! - still not quite
right w/ VS 2008).

Is there not a way this could be automated, like a full-blown install into
VS?

I would be glad to pitch in, but would need some assistance as I am a
newbie.

Cheers,
Kevin


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Jiri Cincura
Sent: Wednesday, November 14, 2007 2:35 PM
To: Daniel Rail; For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Problem integrating with VS 2005

What steps you've performed?

-- 
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


-
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 integrating with VS 2005

2007-11-14 Thread Kevin Stanton 
Was just an idea.  :)


I'm very close w/ my VS 2008 beta 2 FB 1.54 install.
The error I'm getting now when I try to select a table from the list of
database objects is:

APP_INFO
Could not get column information for database object named 'APP_INFO'

Here are the steps I've taken so far:

1. Installed the VS 2008 SDK.
2. Installed the Firebird Client (2.0.1)
3. Installed the Data Designer DDEX (2.0.1)
4. Modified the 2 .reg files, changing both sections - configSection and
system.data DBProviderFactories.  And installed them.
5. Modified the machine.config file to match the version and public token
key in GAC.



Any clues would be greatly appreciated! 

Best Regards,
Kevin





-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Jiri Cincura
Sent: Wednesday, November 14, 2007 3:45 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Problem integrating with VS 2005

On 11/15/07, Kevin Stanton [EMAIL PROTECTED] wrote:
 Is there not a way this could be automated, like a full-blown install into
 VS?

In easy way no. And we suppose, that DDEX provider is used by
developers, so that developer is able to read documentation and
perform some steps (and maybe troubleshooting, if required).

 I would be glad to pitch in, but would need some assistance as I am a
 newbie.

There's a lot of users in list, willing to help with almost any
problem. But you have to provide some hints and a lot of information
about problem, this is crucial to get some advice. That's more
important with DDEX, 'cause it's interaction with a lot of components
(VS, .NET FW, ...).

-- 
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


-
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