Re: [Firebird-net-provider] Switching to C# 5 compiler
Hi,just one question:
our applications targets to framework 3.5,this way are
using Firebird-net-provider 2.5.2.0 (date build: 14/02/2010) that is the last
version with target to framework 3.5, up to this is target to framework 4.
This way we can't update our provider as long we don't update Visual Studio
version .If we update our VS we need to update also controls
components,reporting components,etc so the question is : it is possible to
have Firebird-net-provider versions compatible also with framework,also up to
date?
Thanks !
From: Jiri Cincura
To: For users and developers of the Firebird .NET providers
Sent: Thursday, July 26, 2012 1:16 PM
Subject: [Firebird-net-provider] Switching to C# 5 compiler
HI *,
if there are no objections, next Monday I'll switch .NET provider's to
C# 5 compiler and VS2012.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Switching to C# 5 compiler
Jiri sent a mail titled "[Firebird-net-provider] Dropping (pure) .NET 2.0
support" so.. I searched
and I'found that is already done :
http://www.firebirdsql.org/en/net-provider/
Thanks !
________
From: Mr. John
To: For users and developers of the Firebird .NET providers
Sent: Thursday, July 26, 2012 1:33 PM
Subject: Re: [Firebird-net-provider] Switching to C# 5 compiler
Hi,just one question:
our applications targets to framework 3.5,this way are
using Firebird-net-provider 2.5.2.0 (date build: 14/02/2010) that is the last
version with target to framework 3.5, up to this is target to framework 4.
This way we can't update our provider as long we don't update Visual Studio
version .If we update our VS we need to update also controls
components,reporting components,etc so the question is : it is possible to
have Firebird-net-provider versions compatible also with framework,also up to
date?
Thanks !
From: Jiri Cincura
To: For users and developers of the Firebird .NET providers
Sent: Thursday, July 26, 2012 1:16 PM
Subject: [Firebird-net-provider] Switching to C# 5 compiler
HI *,
if there are no objections, next Monday I'll switch .NET provider's to
C# 5 compiler and VS2012.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Upgrade provider from 2.5 to 2.7 - show VS immediate windows all command used
Hi ! I just updated provider from version 2.5 to 2.7 but in Visual Basic immediate window I see all SQL command that provierder is working with during application run,I can see there lots of statements scrolling,that was not in previous version,can this be turned off ? here is a screenshot : http://img267.imageshack.us/img267/8185/screenshot001xa.jpg Thanks-- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Upgrade provider from 2.5 to 2.7 - show VS immediate windows all command used
Thanks a lot Mark,it is working ! From: Mark Rotteveel To: Mr. John ; For users and developers of the Firebird .NET providers Sent: Thursday, July 26, 2012 9:46 PM Subject: Re: [Firebird-net-provider] Upgrade provider from 2.5 to 2.7 - show VS immediate windows all command used On 26-7-2012 19:58, Mr. John wrote: > Hi ! > I just updated provider from version 2.5 to 2.7 but in Visual Basic > immediate window I see all SQL command that provierder is working with > during application run,I can see there lots of statements scrolling,that > was not in previous version,can this be turned off ? > here is a screenshot : > http://img267.imageshack.us/img267/8185/screenshot001xa.jpg See Jiri's blog: http://blog.cincura.net/232603-improved-command-logging-in-ado-net-provider-for-firebird-part-2/ -- Mark Rotteveel-- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Upgrade provider from 2.5 to 2.7 - show VS immediate windows all command used
Hi ! I've notice the solving solution : make all commands UPDATE/INSERT/etc running 6 TIMES SLOWER than before,that only when I run application by IDE/code,running from build exe it is working fine,also is working if I revert back to version 2.5 How to solve it with version 2.7? Thanks ! From: Mr. John To: "firebird-net-provider@lists.sourceforge.net" Sent: Friday, July 27, 2012 7:22 AM Subject: Re: [Firebird-net-provider] Upgrade provider from 2.5 to 2.7 - show VS immediate windows all command used Thanks a lot Mark,it is working ! From: Mark Rotteveel To: Mr. John ; For users and developers of the Firebird .NET providers Sent: Thursday, July 26, 2012 9:46 PM Subject: Re: [Firebird-net-provider] Upgrade provider from 2.5 to 2.7 - show VS immediate windows all command used On 26-7-2012 19:58, Mr. John wrote: > Hi ! > I just updated provider from version 2.5 to 2.7 but in Visual Basic > immediate window I see all SQL command that provierder is working with > during application run,I can see there lots of statements scrolling,that > was not in previous version,can this be turned off ? > here is a screenshot : > http://img267.imageshack.us/img267/8185/screenshot001xa.jpg See Jiri's blog: http://blog.cincura.net/232603-improved-command-logging-in-ado-net-provider-for-firebird-part-2/ -- Mark Rotteveel -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider-- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Upgrade provider from 2.5 to 2.7 - show VS immediate windows all command used
Thanks Jiri,my mistake,didn't read it all : turn it off completely,
using just the
now i added just this,and seems to work :
From: Jiri Cincura
To: Mr. John ; For users and developers of the Firebird
.NET providers
Sent: Saturday, July 28, 2012 8:03 AM
Subject: Re: [Firebird-net-provider] Upgrade provider from 2.5 to 2.7 - show VS
immediate windows all command used
Maybe you should read that blog post again (or think about the code), instead
of blindly copying first code you saw.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Help with retrieving/binding image from database
Hi !
I'm using VB.2008 with FB 2.5/,Net provider version 2.7.7.0
I want to save and retrieve/bind image from/to picture box control
image database field :
F_IMAG BLOB SUB_TYPE 1 SEGMENT SIZE 4096
saving to database :
Dim IMG As New Bitmap(PictureBox1.Image)
Dim stream As New IO.MemoryStream
IMG.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg)
.Add("@pimg", FbDbType.Binary).Value = stream.ToArray()
no error here
but I got this error :
Unable to cast object of type 'System.String' to type 'System.Byte[]'.
when I try to retrieving/binding image with this code :
Dim WithEvents bind As Binding
.
bind = New Binding("Image", bSource_, "F_IMAG")
Me.PictureBox1.DataBindings.Add(bind)
.
Private Sub Binding_Format(ByVal sender As System.Object, ByVal e As
ConvertEventArgs) Handles bind.Format
Dim img As Byte()
img = CType(e.Value, Byte()) 'Unable to cast object of type
'System.String' to type 'System.Byte[]'.
If (Not img Is Nothing) Then
e.Value = Image.FromStream(New System.IO.MemoryStream(img))
End If
End Sub
thanks for any help !
--
LogMeIn Central: Instant, anywhere, Remote PC access and management.
Stay in control, update software, and manage PCs from one command center
Diagnose problems and improve visibility into emerging IT issues
Automate, monitor and manage. Do more in less time with Central
http://p.sf.net/sfu/logmein12331_d2d___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Help with retrieving/binding image from database
Because yahoo put this email in Spam folder I've moved code into pastebin.com links and resend it : Hi ! I'm using VB.2008 with FB 2.5/,Net provider version 2.7.7.0 I want to save and retrieve/bind image from/to picture box control image database field : F_IMAG BLOB SUB_TYPE 1 SEGMENT SIZE 4096 saving to database : http://pastebin.com/CLC0GBP5 no error here but I got this error : Unable to cast object of type 'System.String' to type 'System.Byte[]'. when I try to retrieving/binding image with this code : http://pastebin.com/wdUHvR4x-- LogMeIn Central: Instant, anywhere, Remote PC access and management. Stay in control, update software, and manage PCs from one command center Diagnose problems and improve visibility into emerging IT issues Automate, monitor and manage. Do more in less time with Central http://p.sf.net/sfu/logmein12331_d2d___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Help with retrieving/binding image from database
Thanks ! Indeed that is the problem,thanks also to Mark and Jiri ! I have just one little problem:when I select no picture(there is no need for user to select always a picture) I got another error : Invalid cast from 'System.DBNull' to 'System.Drawing.Image'. when I call bindingsource : bSource_.EndEdit() Thanks ! From: Gerdus van Zyl To: Mr. John ; For users and developers of the Firebird .NET providers Sent: Friday, November 2, 2012 3:55 PM Subject: Re: [Firebird-net-provider] Help with retrieving/binding image from database Blob sub_type 1 is Text. sub_type 0 is binary. That is why you are getting a string from the database. see http://www.firebirdfaq.org/faq165/-- LogMeIn Central: Instant, anywhere, Remote PC access and management. Stay in control, update software, and manage PCs from one command center Diagnose problems and improve visibility into emerging IT issues Automate, monitor and manage. Do more in less time with Central http://p.sf.net/sfu/logmein12331_d2d___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Help with retrieving/binding image from database
Thanks !
indeed,to avoid this I'm setting default values for every field in
datatable,for numeric 0, for strings "" but for blob ???
From: Jiri Cincura
To: Mr. John ; For users and developers of the Firebird
.NET providers
Cc: Gerdus van Zyl
Sent: Saturday, November 3, 2012 3:09 PM
Subject: Re: [Firebird-net-provider] Help with retrieving/binding image from
database
On Sat, Nov 3, 2012 at 9:50 AM, Mr. John wrote:
> Invalid cast from 'System.DBNull' to 'System.Drawing.Image'.
Your code should check for NULLs, either in database and handle empty
result set or in result directly.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com--
LogMeIn Central: Instant, anywhere, Remote PC access and management.
Stay in control, update software, and manage PCs from one command center
Diagnose problems and improve visibility into emerging IT issues
Automate, monitor and manage. Do more in less time with Central
http://p.sf.net/sfu/logmein12331_d2d___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Detect current connection is local or network
Hi ! I'm using VB.NET 2008 with FB SS 2.5 and FirebirdClient 2.7.7.0 I need to detect if current FB connection is local or over a network. Thanks.-- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Detect current connection is local or network
Hi !
"local" = database is on the same machine as application is
thanks.
On Friday, December 13, 2013 3:10 PM, Jiri Cincura wrote:
>Depends on what you think "local" (your original question) is.
On Fri, Dec 13, 2013 at 12:40 PM, Mr. John wrote:
> solution is to search in connecton string for 'localhost' or '127.0.0.1'
> ?
On Friday, December 13, 2013 3:10 PM, Jiri Cincura wrote:
On Fri, Dec 13, 2013 at 12:40 PM, Mr. John wrote:
> solution is to search in connecton string for 'localhost' or '127.0.0.1'
> ?
Depends on what you think "local" (your original question) is.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com--
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Detect current connection is local or network
Hi,thanks Alexander,
I've put that condition:
If ",localhost,127.0.0.1,".Contains("," + My.Settings.Server_Name.Trim.ToLower
+ ",")
..
EndIf
I don't know if that is the best way
thanks
On Saturday, December 14, 2013 1:55 PM, Alexander Muylaert-Gelein
wrote:
Hi
This parses a firebird path and scans for "loopback" or computername. You just
need to add all possible IP's from you local PC and localhost.
good luck
a
private static void ReplaceLocalHost(ref string aServer)
{
s_OriginalDatabaseServer = aServer;
if (System.Environment.MachineName.Equals(aServer,
StringComparison.OrdinalIgnoreCase) || ("127.0.0.1".Equals(aServer,
StringComparison.Ordinal)))
{
aServer = "localhost";
}
}
private static char[] s_Splitter = new char[] { ':' };
private static bool SplitServerAndPort(string aPart, out string
aServer, out int aPort)
{
var p = aPart.IndexOf('/');
if (p >= 0)
{
aServer = aPart.Substring(0, p);
if (int.TryParse(aPart.Substring(p + 1), out aPort))
{
ReplaceLocalHost(ref aServer);
return true;
}
return false;
}
else
{
aServer = aPart;
ReplaceLocalHost(ref aServer);
aPort = 3050;
return true;
}
}
public static bool SplitDatabaseTarget(string aDatabaseTarget, out
string aServer, out int aPort,
out string aPath)
{
aServer = "localhost";
aPort = 3050;
aPath = null;
if (string.IsNullOrWhiteSpace(aDatabaseTarget))
{
return false;
}
var parts = aDatabaseTarget.Split(s_Splitter,
StringSplitOptions.RemoveEmptyEntries);
switch (parts.Length)
{
case 0:
return false;
case 1:
// "webdb"
aPath = parts[0];
return true;
case 2:
// "c:\fast.fdb"
// "fast-server:webdb
// "fast-server/3052:webdb"
if (parts[0].Length == 1 && parts[1].StartsWith("\\"))
{
aPath = parts[0] + ":" + parts[1];
}
else
{
if (!SplitServerAndPort(parts[0], out aServer, out
aPort))
{
return false;
}
aPath = parts[1];
}
return true;
case 3:
// "fast-server:c:\fast\fast.fdb
// "fast-server/3052:c:\fast\fast.fdb"
if (!SplitServerAndPort(parts[0], out aServer, out aPort))
{
return false;
}
if (parts[1].Length == 1 && parts[2].StartsWith("\\"))
{
aPath = parts[1] + ":" + parts[2];
return true;
}
return false;
default:
return false;
}
}
Date: Fri, 13 Dec 2013 23:27:55 -0800
From: mr_joh...@yahoo.com
To: firebird-net-provider@lists.sourceforge.net
Subject: Re: [Firebird-net-provider] Detect current connection is local or
network
Hi !
"local" = database is on the same machine as application is
thanks.
On Friday, December 13, 2013 3:10 PM, Jiri Cincura wrote:
>Depends on what you think "local" (your original question) is.
On Fri, Dec 13, 2013 at 12:40 PM, Mr. John wrote:
> solution is to search in connecton string for 'localhost' or '127.0.0.1'
> ?
On Friday, December 13, 2013 3:10 PM, Jiri Cincura wrote:
On Fri, Dec 13, 2013 at 12:40 PM, Mr. John wrote:
> solution is to search in connecton string for 'localhost' or '127.0.0.1'
> ?
Depends on what you think "local" (your original question) is.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Rapidly troubleshoot problems before they affect your business. Most IT
orga
Re: [Firebird-net-provider] Detect current connection is local or network
Hi When using my application over a network,only when it is update on the server machine,client applications must download also the update so I need to detect server or client state thanks On Sunday, December 15, 2013 11:01 AM, Mark Rotteveel wrote: On 13-12-2013 11:33, Mr. John wrote: > Hi ! > I'm using VB.NET 2008 with FB SS 2.5 and FirebirdClient 2.7.7.0 > I need to detect if current FB connection is local or over a network. Could you provide some detail on why you need to know this? Mark -- Mark Rotteveel-- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Detect current connection is local or network
That I also do, but I only apply database update scripts on server machine,also some users using default app installer installed also FB server on 'client' side. I also want to warn about that. thanks On Sunday, December 15, 2013 9:14 PM, Mercea Paul wrote: On 12/15/2013 12:21 PM, Mr. John wrote: Hi >When using my application over a network,only when it is update on the server machine,client applications must download also the update >so I need to detect server or client state >thanks > Hi If you separate the client and the server, even if you work on same machine the client must be updated if is an update on 'server' side. I think you can achieve this by using a table for versioning (id, workstation,version,updated), or something similar. Best regards, Paul MERCEA ___ E-mail: paul.mer...@almexa.ro ___ -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider-- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Detect current connection is local or network
Hi, but how to detect app is running on server side or on local,I used to search for firebird process but I found as I said, fb was installed also on client side,so the trusted point to get that info is from firbird connection thanks. On Monday, December 16, 2013 10:05 AM, Mercea Paul wrote: On 12/16/2013 08:34 AM, Mr. John wrote: >That I also do, but I only apply database update scripts on server machine,also some users using default app installer installed also FB server on 'client' side. >I also want to warn about that. >thanks > Increment application version on server side, as final step in installation process and check in your client startup if meet the correct version. Update if necessary . You dont need to know if client run locally or remote, you need to have compatibility between client app and server/database structure. -- Paul MERCEA ___ E-mail: paul.mer...@almexa.ro ___ -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider-- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Detect current connection is local or network
Hi,with that query select a.mon$remote_process, a.mon$remote_address from MON$ATTACHMENTS a I get all connections+ip,something I miss,sorry:how to identify my current connection? address 127.0.0.1 from the query means connection is on the server side? thanks On Monday, December 16, 2013 11:05 AM, Mercea Paul wrote: On 12/16/2013 10:15 AM, Mr. John wrote: Hi, but how to detect app is running on server side or on local,I used to search for firebird process but I found as I said, fb was installed also on client side,so the trusted point to get that info is from firbird connection > >thanks. > > > > Check table MON$ATTACHMENTS,like: select a.mon$remote_process, a.mon$remote_address from MON$ATTACHMENTS a Regards, -- Paul MERCEA ___ E-mail: paul.mer...@almexa.ro ___ -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider-- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Problem using embedded version:IDE is waiting to terminate a process up to 7 seconds
Hi,I use FB embedded version for a little local db,Firebird-2.5.4.26856-0_Win32_embed on W 8.1 x86 with Visual Basic 2012FirebirdClient 4.7 I run this simple code and when I close it,application closes but IDE still show "WindowsApplication1 Running" for up to 7 seconds,I think is waiting for some process to terminate Imports FirebirdSql.Data.FirebirdClientPublic Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim connectionString As String connectionString = "User=SYSDBA;" + _ "Password=mypass;" + _ "DataSource=localhost;" + _ "Dialect=3;" + _ "Charset=NONE;" + _ "Role=;" + _ "Connection lifetime=15;" + _ "Pooling=true;" + _ "Port=3050;" + _ "MinPoolSize=0;" + _ "MaxPoolSize=50;" + _ "Packet Size=8192;" + _ "ServerType=1;" + _ "Database=" + "mydb.FDB" Dim myConnection1 = New FbConnection(connectionString) myConnection1.Open() myConnection1.Close() End SubEnd Class I've disabled antivirus,firewall,tested on another machine:the same thing I tested with VB 2008 and FirebirdClient 2.7.7.0 - the same here If I change ServerType=1(embedded) to ServerType=0 (SS) all works fine,IDE ends running mode instantly How to fix that? I need embedded version (for a local db access) Also my application can be restarted for some maintenance,I used successfully that with SS for a long time but now with embedded application freezes after restart (I think is the same problem) Thanks for any help. -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Stored procedures not added to model
HiI'm using FB2.5,VS 2013,FirebirdClient 4.8.1.0,DDEXProvider 3.0.2.0 When I try to add a stored procedure to model from database using Update model from database.,I select/check the sp name in the list,but no procedure is added to model,also in Model Browser nothing added,in function import no SP name to selectsearching on google for that problem I found complaining about this problem but no solving clue thanks -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Stored procedures not added to model
Hi this is the simplest SP I have: CREATE OR ALTER PROCEDURE PR_GETCFNAME(id bigint)returns ( NAME varchar(100))asbegin select first 1 NAME from cf where id=:id into :NAME; suspend;end thanks From: Jiří Činčura To: firebird-net-provider@lists.sourceforge.net Sent: Wednesday, October 28, 2015 1:13 PM Subject: Re: [Firebird-net-provider] Stored procedures not added to model What's the signature of that SP? -- Mgr. Jiří Činčura Independent IT Specialist On Wed, Oct 28, 2015, at 09:53, Mr. John wrote: > HiI'm using FB2.5,VS 2013,FirebirdClient 4.8.1.0,DDEXProvider 3.0.2.0 > When I try to add a stored procedure to model from database using Update > model from database.,I select/check the sp name in the list,but no > procedure is added to model,also in Model Browser nothing added,in > function import no SP name to selectsearching on google for that problem > I found complaining about this problem but no solving clue > thanks > -- > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Stored procedures not added to model
any help on this problem,tested with VS 2015,the same thingalso this problem seems to be old with no solution:entity framework won't import my firebird stored procedure | | | | | | | | | | | entity framework won't import my firebird stored procedu... I am using EF for .NET 4 and the firebird .NET provider 3.0.2.0 with Firebird 2.5. I have created a stored procedure as follows (DDL from IBEXPERT):- SET TERM ^ ;... | | | | View on stackoverflow.com | Preview by Yahoo | | | | | orfirebird-net-provider - Entity Framework not importing stored procedures | | | | | | | | | | | firebird-net-provider - Entity Framework not importing s... Entity Framework not importing stored procedures. I previously created an Entity Framework model for a Firebird 2.5 database in Visual Studio 2012 Professional. At ... | | | | View on firebird | Preview by Yahoo | | | | | or .NET: entity framework won't import my firebird stored procedure - cNETion.com | | | | | | | | | .NET: entity framework won't import my firebird stored procedure - cNETion.com आप से संबंधित है असामान्य समस्याओं का सॉफ्टवेयर समाधान C# Linux .NET Arrays gcc Windows sockets asp.net vb.net सवाल पूछने के लिए और हमारे समुदाय से सबसे अच्छा जवाब मिलता है | | | | View on www.cnetion.com | Preview by Yahoo | | | | | thanks From: Jiří Činčura To: firebird-net-provider@lists.sourceforge.net Sent: Wednesday, October 28, 2015 1:13 PM Subject: Re: [Firebird-net-provider] Stored procedures not added to model What's the signature of that SP? -- Mgr. Jiří Činčura Independent IT Specialist On Wed, Oct 28, 2015, at 09:53, Mr. John wrote: > HiI'm using FB2.5,VS 2013,FirebirdClient 4.8.1.0,DDEXProvider 3.0.2.0 > When I try to add a stored procedure to model from database using Update > model from database.,I select/check the sp name in the list,but no > procedure is added to model,also in Model Browser nothing added,in > function import no SP name to selectsearching on google for that problem > I found complaining about this problem but no solving clue > thanks > -- > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Stored procedures not added to model
indeed it's ok for you,but for me not.I use automatic import,what options I have to make it works for methanks From: Jiří Činčura To: firebird-net-provider@lists.sourceforge.net Sent: Monday, November 2, 2015 11:58 AM Subject: Re: [Firebird-net-provider] Stored procedures not added to model On Wed, Oct 28, 2015, at 12:56, Mr. John wrote: > Hi > > this is the simplest SP I have: > > CREATE OR ALTER PROCEDURE PR_GETCFNAME(id bigint)returns ( NAME > varchar(100))asbegin select first 1 NAME from cf where id=:id into > :NAME; suspend;end > > > > thanks Works fine for me. It imported on a first try. Check http://snag.gy/N9svt.jpg . Because it's selectable in FIrebird it's composable in EF and I can see it dropdown when adding function import (I haven't used the automatic import - sometimes it fucks up). -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Stored procedures not added to model
and use for stored procedures classic ADO.NET From: Jiří Činčura To: firebird-net-provider@lists.sourceforge.net Sent: Monday, November 2, 2015 4:10 PM Subject: Re: [Firebird-net-provider] Stored procedures not added to model On Mon, Nov 2, 2015, at 13:51, Mr. John wrote: > indeed it's ok for you,but for me not.I use automatic import,what options > I have to make it works for methanks Just untick it? ... -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Stored procedures not added to model
there is no SP name in model even after using Update Model from Database,only names for tables thanks From: Jiří Činčura To: firebird-net-provider@lists.sourceforge.net Sent: Monday, November 2, 2015 9:51 PM Subject: Re: [Firebird-net-provider] Stored procedures not added to model On Mon, Nov 2, 2015, at 19:16, Mr. John wrote: > and use for stored procedures classic ADO.NET Why? You can still configure the SP in model manually. It's already there. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Problem with connection strig using Report Manager
Hi ! I've discovered Report Manager (http://reportman.sourceforge.net/ ),free
reporting solution and I've tried to connect using firebird and VB .Net 2005
Express.Connection manually works,but not using code.Has anyone used it?Thanks.
I've got this error,on last line :
"An OLE DB Provider was not specified in the ConnectionString. An
example would be, 'Provider=SQLOLEDB;'"
Dim rptRep As New Reportman.Reporting.Report
Dim rptData As Reportman.Reporting.DatabaseInfo
rptRep.LoadFromFile("C:\Program Files\Report Manager\sample5.rep")
rptRep.AsyncExecution = False
rptData = rptRep.DatabaseInfo.Item(0)
rptData.ConnectionString =
"Server=localhost;User=SYSDBA;Password=pass;Database=d:\data\test.fdb"
Dim prw As New Reportman.Drawing.Forms.PrintOutWinForms()
prw.Preview = True
prw.SystemPreview = False
prw.ShowPrintDialog = False
prw.Print(rptRep.MetaFile)
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news,
photos & more.
http://mobile.yahoo.com/go?refer=1GNXIC-
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 with connection strig using Report Manager
Thanks for answer.I don't know how to make it work.Report manager came with these 2 files : C:\Program Files\Report Manager\net\FirebirdSql.Data.Firebird.dll C:\Program Files\Report Manager\net\fbembed.dll - Original Message From: Carlos Guzmán Álvarez <[EMAIL PROTECTED]> To: For users and developers of the Firebird .NET providers Sent: Saturday, October 6, 2007 5:27:13 PM Subject: Re: [Firebird-net-provider] Problem with connection strig using Report Manager Hello: > Hi ! I've discovered Report Manager (http://reportman.sourceforge.net/ > ),free reporting solution and I've tried to connect using firebird > and VB .Net 2005 Express.Connection manually works,but not using > code.Has anyone used it?Thanks. > > I've got this error,on last line : > "An OLE DB Provider was not specified in the ConnectionString. An > example would be, 'Provider=SQLOLEDB;'" FirebirdClient is an ADO.NET Data Provider not and OleDb driver -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient: http://www.firebirdsql.org/ XMPP Client: http://code.google.com/p/xmppclient/ ohloh: http://www..ohloh.net/accounts/4138 - 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 Need a vacation? Get great deals to amazing places on Yahoo! Travel. http://travel.yahoo.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 with connection strig using Report Manager
Tanks for your answer.In database connection panel I have "Database Driver" - I
chose "Dot Net 2 Connection" and in "Dot net driver" combobox I have :
System.Data.Odbc
System.Data.Oledb
System.Data.OracleClient
System.Data.SqlClient
so,no Firebird (I have Firebird clint 2.5 alpha 1 installed.)
I opended machine.config, and under " " I added line :
under I added
I'm not sure about Version and PublicKeyToken.
Then in "Dot net driver" combo I found also
"FirebirdSql.Data.FirebirdClient",but I got an error :
"Failed to find or load the registered .NET Framework Data Provider "
How can I solve this.Thanks.
- Original Message
From: Jiri Cincura <[EMAIL PROTECTED]>
To: For users and developers of the Firebird .NET providers
Sent: Saturday, October 6, 2007 9:22:28 PM
Subject: Re: [Firebird-net-provider] Problem with connection strig using Report
Manager
On 10/6/07, Mr. John <[EMAIL PROTECTED]> wrote:
>
> Thanks for answer.I don't know how to make it work.Report manager came with
> these 2 files :
> C:\Program Files\Report
> Manager\net\FirebirdSql.Data.Firebird.dll
> C:\Program Files\Report Manager\net\fbembed.dll
This is probably some internal stuff. You need to connect to *your* DB
(and probably not via FB Embedded).
--
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
Tonight's top picks. What will you watch tonight? Preview the hottest shows on
Yahoo! TV.
http://tv.yahoo.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 with connection strig using Report Manager
Thanks Carlos. With your suggestion I used gacutil.exe and now It works fine.Thanks a lot. - Original Message From: Carlos <[EMAIL PROTECTED]> To: For users and developers of the Firebird .NET providers Sent: Monday, October 8, 2007 6:00:44 PM Subject: Re: [Firebird-net-provider] Problem with connection strig using Report Manager Hello: > type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, > FirebirdSql.Data.FirebirdClient, > Version=2.5..0.0, Culture=neutral, > PublicKeyToken=b77a5c561934e089" /> > I'm not sure about Version and PublicKeyToken. You should put the ones the assembly has in the GAC -- 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 Yahoo! oneSearch: Finally, mobile search that gives answers, not web links. http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC- 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 with connection strig using Report Manager
thanks
now it seems to work this way
and
thanks
- Original Message
From: Jiri Cincura <[EMAIL PROTECTED]>
To: For users and developers of the Firebird .NET providers
Sent: Monday, October 8, 2007 6:29:22 PM
Subject: Re: [Firebird-net-provider] Problem with connection strig using Report
Manager
On 10/8/07, Mr. John <[EMAIL PROTECTED]> wrote:
>
> type="System.Data.Common.DbProviderConfigurationHandler,
> System.Data,
> Version=2.5.0.0, Culture=neutral,
> PublicKeyToken=b77a5c561934e089" />
And there should be 2.0.0.0 etc., 'cause you're adding record for
"type="System.Data.Common..DbProviderConfigurationHandler..." and not
for FB.
--
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
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news,
photos & more.
http://mobile.yahoo.com/go?refer=1GNXIC-
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 with connection strig using Report Manager
I have I silly question : do I have to make this configuration on every
computer that I install my application ?
Thanks.
- Original Message
From: Mr. John <[EMAIL PROTECTED]>
To: For users and developers of the Firebird .NET providers
Sent: Monday, October 8, 2007 6:35:05 PM
Subject: Re: [Firebird-net-provider] Problem with connection strig using Report
Manager
thanks
now it seems to work this way
and
thanks
- Original Message
From: Jiri Cincura <[EMAIL PROTECTED]>
To: For users and developers of the Firebird .NET providers
Sent: Monday, October 8, 2007 6:29:22 PM
Subject: Re: [Firebird-net-provider] Problem with connection strig using Report
Manager
On 10/8/07, Mr. John <[EMAIL PROTECTED]> wrote:
>
> type="System.Data.Common.DbProviderConfigurationHandler,
> System.Data,
> Version=2.5.0.0, Culture=neutral,
> PublicKeyToken=b77a5c561934e089" />
And there should be 2.0.0.0 etc., 'cause you're adding record
for
"type="System.Data.Common.DbProviderConfigurationHandler..." and not
for FB.
--
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
Moody friends. Drama queens. Your life? Nope! - their life, your story.
Play Sims Stories at Yahoo! Games.
Check out the hottest 2008 models today at Yahoo! Autos.
http://autos.yahoo.com/new_cars.html-
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 with connection strig using Report Manager
Thanks.I edit app.config adding these lines,except the last,now application fail to start : . - Original Message From: Carlos Guzmán Álvarez <[EMAIL PROTECTED]> To: For users and developers of the Firebird .NET providers Sent: Monday, October 8, 2007 9:35:09 PM Subject: Re: [Firebird-net-provider] Problem with connection strig using Report Manager Hello: > I have I silly question : do I have to make this configuration on > every computer that I install my application ? DDES is for devel only but anyway you can put it on your App.config file -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient: http://www.firebirdsql.org/ XMPP Client: http://code.google.com/p/xmppclient/ ohloh: http://www.ohloh.net/accounts/4138 - 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 Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase. http://farechase.yahoo.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] Elegant way to detect Generator for Column
Hi ,I think this question should be asked in firebird-support list. As I know,generators are independent objects,stored in database.You better have to look for BEFORE INSERT triggers that use generators. - Original Message From: Michael Möhle <[EMAIL PROTECTED]> To: Firebird-net-provider@lists.sourceforge.net Sent: Friday, September 12, 2008 11:00:20 PM Subject: [Firebird-net-provider] Elegant way to detect Generator for Column Hello, can anyone tell me how I can detect that there is a Generator for a Column? Michael - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ ___ 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 the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] EF - last inserted ID is 0
HiI'm using FB 2.5,EF Firebird 5.9.1,Asp MVC 5 with VS 2017
on a table I have a trigger to generate ID:
CREATE OR ALTER TRIGGER TRIG_MYTABLE_BI FOR MYTABLE
ACTIVE BEFORE INSERT POSITION 0 AS
BEGIN IF ((NEW.ID IS NULL) OR (NEW.ID=0)) THEN
NEW.ID=NEXT VALUE FOR GEN_MYTABLE_ID; END
in my code I insert data like this:
myTableEnt newRec= new myTableEnt() {
NAME='MYNAME', };
db.myTableEnt.Add(newRec); db.SaveChanges();
return ToJson(new { msg = newRec.ID.ToString() });
newRec.ID is returned always 0,but in database value is generatedwhat I've
done wrongthanks
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] EF - last inserted ID is 0
Hi.Thanks Paul for your answerFor my first code I've followed this:
https://stackoverflow.com/questions/4068084/how-to-find-an-identity-of-the-last-inserted-row-in-entity-frameworkand
that seems not to apply to FB?I so I can insert ID without trigger,directly
from my code,something like this:
myTableEnt newRec= new myTableEnt() { ID=
GetNextSequenceValue(ref db, "SELECT NEXT VALUE FOR GEN_MYTABLE_ID FROM
RDB$DATABASE") NAME='MYNAME',
};
...public long GetNextSequenceValue(ref myEnt ctx, string sql) {
var rawQuery = ctx.Database.SqlQuery(sql); var task =
rawQuery.SingleAsync(); long nextVal = task.Result;
return nextVal; }
thanks
From: paul.mercea To: For users and developers of the
Firebird .NET providers Cc: Mr.
John Sent: Friday, August 25, 2017, 11:35:11 PM
GMT+3Subject: Re: [Firebird-net-provider] EF - last inserted ID is 0
The trigger from you database has nothing to do with your c# code.You can use a
stored procedure to insert data and returning latest id (also you can read
current sequence value but you can have wrong value if other inserts happening).
Sent from my Samsung Galaxy smartphone.
Original message From: "Mr. John via Firebird-net-provider"
Date: 8/25/17 20:28 (GMT+02:00)
To: "For Users and Developers of the Firebird .NET Providers"
Cc: "Mr. John"
Subject: [Firebird-net-provider] EF - last inserted ID is
0
HiI'm using FB 2.5,EF Firebird 5.9.1,Asp MVC 5 with VS 2017
on a table I have a trigger to generate ID:
CREATE OR ALTER TRIGGER TRIG_MYTABLE_BI FOR MYTABLE
ACTIVE BEFORE INSERT POSITION 0 AS
BEGIN IF ((NEW.ID IS NULL) OR (NEW.ID=0)) THEN
NEW.ID=NEXT VALUE FOR GEN_MYTABLE_ID; END
in my code I insert data like this:
myTableEnt newRec= new myTableEnt() {
NAME='MYNAME', };
db.myTableEnt.Add(newRec); db.SaveChanges();
return ToJson(new { msg = newRec.ID.ToString() });
newRec.ID is returned always 0,but in database value is generatedwhat I've
done wrongthanks
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] EF - last inserted ID is 0
HiI'm using DbFirst,if I set [DatabaseGenerated(DatabaseGeneratedOption.Identity)] attribute on the ID column after a model refresh it will be lostthanks From: Daniel Rail To: "firebird-net-provider@lists.sourceforge.net" Sent: Saturday, August 26, 2017, 4:37:44 PM GMT+3Subject: Re: [Firebird-net-provider] EF - last inserted ID is 0 Hi, At August 26, 2017, 1:38 AM, Mr. John via Firebird-net-provider wrote: | | Hi. Thanks Paul for your answer For my first code I've followed this: https://stackoverflow.com/questions/4068084/how-to-find-an-identity-of-the-last-inserted-row-in-entity-framework and that seems not to apply to FB? | That's how I do it. Just make certain that you are using the [DatabaseGenerated(DatabaseGeneratedOption.Identity)] attribute on the ID column in the myTableEnt entity. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com)-- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] EF - last inserted ID is 0
Hiit seems to work only if I go to edmx,on ID filed and set
StoreGeneratedPatern = Identitybut I use DbFirst and this could be replaced on
model update from dbI've tried using partial class with no success
in my model generated code I have something like this:namespace POSweb.Models
{
public partial class GS_POS_CO
{
.
public long ID { get; set; }
.
}
}I've added a new file to my project, Annotations.cs and inside a new partial
class with the same name for class and namespace:
namespace POSweb.Models
{
[MetadataType(typeof(GS_POS_CO.Annotations))]
public partial class GS_POS_CO
{
internal class Annotations
{
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public long ID { get; set; }
}
}
}
thanks for any help
From: Jiří Činčura To:
"firebird-net-provider@lists.sourceforge.net"
Sent: Sunday, August 27, 2017,
6:16:03 PM GMT+3Subject: Re: [Firebird-net-provider] EF - last inserted ID is 0
Your myTableEnt should have Id marked as DatabaseGen…Options.Identity. Then
it's fetched back automatically.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
On Fri, Aug 25, 2017, at 19:28, Mr. John via Firebird-net-provider wrote:
> HiI'm using FB 2.5,EF Firebird 5.9.1,Asp MVC 5 with VS 2017
> on a table I have a trigger to generate ID:
> CREATE OR ALTER TRIGGER TRIG_MYTABLE_BI FOR MYTABLE
> ACTIVE BEFORE INSERT POSITION 0 AS
> BEGIN IF ((NEW.ID IS NULL) OR (NEW.ID=0)) THEN
> NEW.ID=NEXT VALUE FOR GEN_MYTABLE_ID; END
>
> in my code I insert data like this:
> myTableEnt newRec= new myTableEnt() {
> NAME='MYNAME', };
>
> db.myTableEnt.Add(newRec); db.SaveChanges();
> return ToJson(new { msg = newRec.ID.ToString() });
> newRec.ID is returned always 0,but in database value is generatedwhat I've
> done wrongthanks
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org!
http://sdm.link/slashdot___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] EF - last inserted ID is 0
Hi.I'm using Db first and as I found that is about code firstIf I'm wrong please someone give me some tips about using thatthanks. From: Jiří Činčura To: "firebird-net-provider@lists.sourceforge.net" Sent: Monday, August 28, 2017, 2:48:44 PM GMT+3Subject: Re: [Firebird-net-provider] EF - last inserted ID is 0 Why so complex. Just use https://msdn.microsoft.com/en-us/library/system.data.entity.modelconfiguration.configuration.primitivepropertyconfiguration.hasdatabasegeneratedoption(v=vs.113).aspx and that's it. You should consider you entities store agnostic, in fact. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] EF - last inserted ID is 0
HiI've tried your second suggestion setting PK description to #PK_GEN# and not workingthanks From: Jiří Činčura To: "firebird-net-provider@lists.sourceforge.net" Sent: Tuesday, August 29, 2017, 10:40:52 AM GMT+3Subject: Re: [Firebird-net-provider] EF - last inserted ID is 0 With DB First you can set it up in Properties the same way. Or you can use https://www.tabsoverspaces.com/230841-generated-primary-key-in-entity-framework-model-from-firebird/. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Tue, Aug 29, 2017, at 08:44, Mr. John via Firebird-net-provider wrote: > Hi.I'm using Db first and as I found that is about code firstIf I'm wrong > please someone give me some tips about using thatthanks. > > From: Jiří Činčura To: > "firebird-net-provider@lists.sourceforge.net" > Sent: Monday, August 28, > 2017, 2:48:44 PM GMT+3Subject: Re: [Firebird-net-provider] EF - last > inserted ID is 0 > Why so complex. Just use > https://msdn.microsoft.com/en-us/library/system.data.entity.modelconfiguration.configuration.primitivepropertyconfiguration.hasdatabasegeneratedoption(v=vs.113).aspx > and that's it. You should consider you entities store agnostic, in fact. > > -- > Mgr. Jiří Činčura > https://www.tabsoverspaces.com/ > > > -- > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > -- > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
