"Specified server type is not correct" when attempting to use the embedded server

------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second 
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev

_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: "Specified server type is not correct" when attempting to use the embedded server

First try it with latest version of provider.

--

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second 
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev

Re: ADO.NET Entity Relationship with Stored Procedures

I created DNET-424, to keep track of it for later.

--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second 
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev

[FB-Tracker] Created: (DNET-424) ADO.NET Entity Relationship with Stored Procedures

ADO.NET Entity Relationship with Stored Procedures
--------------------------------------------------

                 Key: DNET-424
                 URL: http://tracker.firebirdsql.org/browse/DNET-424
             Project: .NET Data provider
          Issue Type: Bug
          Components: Entity Framework support
    Affects Versions: 2.6.5
         Environment: Visual Studio 2010, Firebird 2.5, and ADO.NET Provider 2.6.5
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura

=== from thread "ADO.NET Entity Relationship with Stored Procedures" [meubanks] ===
I imported a few Stored Procedures into an ADO.NET Entity Modal that insert
 data but it does not seem to be committing to the database. What am i
 missing here:

            FbDb db = new FbDb();
            db.ADDUSER(UserName.Text, Password.Text, Email.Text);
            db.ADDSITELOGIN(UserName.Text, 123);

            db.SaveChanges();

 These store procedures work fine when executed using my DBManager.

1. Create a stored procedure in any Firebird database. 
2. Have the SP insert values into your database using a couple of parameters you pass to your SP. 
3. The prototype would look something like this: Execute Procedure MySP(value1, value2); 
4. From a web project in Visual Studio 2010 add a "New Item..." to your project. Select "Data" from
"Installed Templates" and choose "ADO.NET Entity Data Model" 
5. On the Data Model work area right click in the white area and select "Update Model from Database..." 
6. From the "Update Wizard" dialog box "Add" tab, select "Stored Procedures" and select the stored
procedure created in steps 1 & 2 and press Finished 
7. Click "View" then "Other Windows" then "Entity Data Model Browser" 
8. In the "Model Browser" tree, select "Stored Procedures" under your database .Store branch (See Capture
1)  
9. Right Click on your stored procedure and select "Add Function Import...." 
10. None of the options in the "Returns a Collection of" or "Get Column Information" sections works but that
is another issue... 
11. Click OK 
12. In your code create an instance of you entity modal object. 
13. Notice that the modal object has a method for you stored procedure with the input parameters. At
run-time the method executes successfully but the database remains unchanged. I did not make any changes
to the modal's underlying code.

--

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

------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second 
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev

Re: Deadlock problem (possible: DNET-382)

AFAIR this is fixed since 2.7 [1] [2]. Can you confirm you're not
experiencing the issue?

[1] http://tracker.firebirdsql.org/browse/DNET-316?page=com.atlassian.jira.plugin.ext.subversion%3Asubversion-commits-tabpanel
[2] http://firebird.svn.sourceforge.net/viewvc/firebird/NETProvider/trunk/NETProvider/source/FirebirdSql/Data/Client/Managed/Version10/GdsTransaction.cs?pathrev=53640&view=diff&r1=53640&r2=53639&diff_format=h

--

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second 
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev

[FB-Tracker] Created: (DNET-425) Single quoted connection string not properly read

Single quoted connection string not properly read
-------------------------------------------------

                 Key: DNET-425
                 URL: http://tracker.firebirdsql.org/browse/DNET-425
             Project: .NET Data provider
          Issue Type: Bug
    Affects Versions: 2.7.5
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Minor

Connection string quoted with single quotes isn't correctly parsed by FbConnectionString class.

--

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

------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second 
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev

Re: "Specified server type is not correct" when attempting to use the embedded server

Thanks Jiri, using the latest NetProvider2.7.5 resolved this.

-----Original Message-----
From: Jiri Cincura [mailto:diskuze@...] 
Sent: 03 April 2012 08:51
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] "Specified server type is not correct"
when attempting to use the embedded server

First try it with latest version of provider.

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

----------------------------------------------------------------------------
--
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second 
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second 
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev

Re: Deadlock problem (possible: DNET-382)

On 03/04/12 10:14, Jiri Cincura wrote:
>  AFAIR this is fixed since 2.7. Can you confirm you're not
>  experiencing the issue?

The changes seem right. Running a test now, seems okay so far.

Scott

------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second 
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev

[FB-Tracker] Created: (DNET-426) WaitTimeout on transaction options using TimeSpan datatype

WaitTimeout on transaction options using TimeSpan datatype
----------------------------------------------------------

                 Key: DNET-426
                 URL: http://tracker.firebirdsql.org/browse/DNET-426
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Minor

WaitTimeout on transaction options using TimeSpan datatype

--

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

------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second 
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev

CheckMaxPoolSize error

Hello,

I get this error messages when the connections pool is full:

System.SystemException: Timeout exceeded.
at FirebirdSql.Data.Firebird.FbConnectionPool.CheckMaxPoolSize()
at FirebirdSql.Data.Firebird.FbConnectionPool.CheckOut()
at FirebirdSql.Data.Firebird.FbConnection.Open()

But i shouldn't get this error because ConnectionLifeTime=10 in connectionstring:

<add key="connecstring" value="charset=ISO8859_1;Connection LifeTime=10;database=/home/domains/db/websites.fdb;user=sysdba;password=masterkey;datasource=localhost"/>

I have tried to clear the pool when i add this line in the global.asax

void Session_End(object sender, EventArgs e) 
    {
        FirebirdSql.Data.FirebirdClient.FbConnection.ClearAllPools();

    }

But connections pool never dies, this action is ignored

I've done a test on a webform, i try to see the number of connections in the pool when is full or almost full

 Label1.Text = FirebirdSql.Data.FirebirdClient.FbConnection.ConnectionPoolsCount.ToString(); 

The result is 1 all the time..., i don't understand why

I get this issue on different OS (windows 2003 server and FreeBSD), i've tried all latest versions
 (ADO.Net Firebird, 2.5.2, 2.7.0,  2.7.5 too)

------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second 
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev