Re: [Firebird-net-provider] ADO.NET provider 2.6.0 for Firebird released
Hi!
I've got a problem with the new version, and I don't know what it is.
Maybe it's not a problem with the version.
I've created a command:
String sqlStreams = INSERT INTO STATIONDETAILS_STREAMS
(STATIONDETAILSID, URL, FORMAT, BITRATE, PLAYLIST) VALUES (@param1,
@param2, @param3, @param4, @param5);;
...
FbCommand cmdSts = new FbCommand(sqlStreams, conn, trans);
cmdSts.Parameters.Add(param1, FbDbType.Integer);
cmdSts.Parameters.Add(param2, FbDbType.VarChar);
cmdSts.Parameters.Add(param3, FbDbType.VarChar);
cmdSts.Parameters.Add(param4, FbDbType.Integer);
cmdSts.Parameters.Add(param5, FbDbType.VarChar);
...
For(..) {
...
cmdSts.Parameters[param1].Value = station.Id;
cmdSts.Parameters[param2].Value = stream.Url;
cmdSts.Parameters[param3].Value = stream.Format;
cmdSts.Parameters[param4].Value = stream.Bitrate;
cmdSts.Parameters[param5].Value = Convert.ToString(stream.Playlist);
cmdSts.ExecuteNonQuery();
...
}
Well, if I run this code, first time it runs without problems, but
always in the next time it breaks with the following exception:
Eine Ausnahme (erste Chance) des Typs
FirebirdSql.Data.Common.IscException ist in
FirebirdSql.Data.FirebirdClient.dll aufgetreten.
Eine Ausnahme (erste Chance) des Typs
FirebirdSql.Data.FirebirdClient.FbException ist in
FirebirdSql.Data.FirebirdClient.dll aufgetreten.
- arithmetic exception, numeric overflow, or string truncation
string right truncation
-bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() in
C:\Users\Jiri\Desktop\NETProvider\source\FirebirdSql\Data\FirebirdClient
\FbCommand.cs:Zeile 513.
bei
BuryWebSuite.Database.FirebirdEmbedded.StoreStationDetailsListToDatabase
(List`1 stations) in
C:\Projekte\M0760_01\3040_Software-Engineering\304040_SW-Construction\30
4040_Source-Code\BURY Web Suite\BURY Web
Suite\Database\FirebirdEmbedded.cs:Zeile 728.
I use VS2010 and .NET 4 (in German, as you maybe see). I know that
Convert.ToString(stream.Playlist) is always true or false. The field in
the database is varchar(10), so that it usually can't be a string
truncation...
Can you help? And why the hell I get your path on my computer in the
exception??
Regards
Martin
--
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ADO.NET provider 2.6.0 for Firebird released
On Fri, Nov 19, 2010 at 09:15, Martin Turek tur...@bury.com wrote:
Can you help?
You're trying to insert longer field than it's in database. Either
provide proper value or specify size of param explicitly (and let DB
handle it).
And why the hell I get your path on my computer in the
exception??
Because you probably have there PDB file.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ADO.NET provider 2.6.0 for Firebird released
Hi!
Yes, there ist he pdb file.
I've changed the code to
...
cmdSts.Parameters.Add(param5, FbDbType.VarChar, 5);
...
But it's still the same problem. The field I in the database is
varchar(10) and the value is only true or false (as I wrote). They
CAN'T get longer than 5. So, where the problem?
Regards
Martin
-Ursprüngliche Nachricht-
Von: Jiri Cincura [mailto:disk...@cincura.net]
Gesendet: Freitag, 19. November 2010 09:22
An: For users and developers of the Firebird .NET providers
Betreff: Re: [Firebird-net-provider] ADO.NET provider 2.6.0 for Firebird
released
On Fri, Nov 19, 2010 at 09:15, Martin Turek tur...@bury.com wrote:
Can you help?
You're trying to insert longer field than it's in database. Either
provide proper value or specify size of param explicitly (and let DB
handle it).
And why the hell I get your path on my computer in the
exception??
Because you probably have there PDB file.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ADO.NET provider 2.6.0 for Firebird released
On Fri, Nov 19, 2010 at 10:07, Martin Turek tur...@bury.com wrote:
But it's still the same problem. The field I in the database is
varchar(10) and the value is only true or false (as I wrote). They
CAN'T get longer than 5. So, where the problem?
Who said, it's param5? What about param2 or param3?
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] R: ADO.NET provider 2.6.0 for Firebirdreleased
Could the problem be on param2 or param3?
Try to limit them, too.
Luigi.
-Messaggio originale-
Da: Martin Turek [mailto:tur...@bury.com]
Inviato: venerdì 19 novembre 2010 10.08
A: firebird-net-provider
Oggetto: Re: [Firebird-net-provider] ADO.NET provider 2.6.0 for
Firebirdreleased
Hi!
Yes, there ist he pdb file.
I've changed the code to
...
cmdSts.Parameters.Add(param5, FbDbType.VarChar, 5);
...
But it's still the same problem. The field I in the database is
varchar(10) and the value is only true or false (as I wrote). They
CAN'T get longer than 5. So, where the problem?
Regards
Martin
-Ursprüngliche Nachricht-
Von: Jiri Cincura [mailto:disk...@cincura.net]
Gesendet: Freitag, 19. November 2010 09:22
An: For users and developers of the Firebird .NET providers
Betreff: Re: [Firebird-net-provider] ADO.NET provider 2.6.0 for Firebird
released
On Fri, Nov 19, 2010 at 09:15, Martin Turek tur...@bury.com wrote:
Can you help?
You're trying to insert longer field than it's in database. Either
provide proper value or specify size of param explicitly (and let DB
handle it).
And why the hell I get your path on my computer in the
exception??
Because you probably have there PDB file.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
__ Information from ESET NOD32 Antivirus, version of virus
signature database 5631 (20101118) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__ Information from ESET NOD32 Antivirus, version of virus signature
database 5631 (20101118) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ADO.NET provider 2.6.0 for Firebird released
Well, when I comment out param5 it runs without problems!
Martin
-Ursprüngliche Nachricht-
Von: Jiri Cincura [mailto:disk...@cincura.net]
Gesendet: Freitag, 19. November 2010 10:16
An: For users and developers of the Firebird .NET providers
Betreff: Re: [Firebird-net-provider] ADO.NET provider 2.6.0 for Firebird
released
On Fri, Nov 19, 2010 at 10:07, Martin Turek tur...@bury.com wrote:
But it's still the same problem. The field I in the database is
varchar(10) and the value is only true or false (as I wrote). They
CAN'T get longer than 5. So, where the problem?
Who said, it's param5? What about param2 or param3?
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] R: ADO.NET provider 2.6.0 for Firebirdreleased
Ops, sorry.. I didn't see this answer :)
Luigi
-Messaggio originale-
Da: Jiri Cincura [mailto:disk...@cincura.net]
Inviato: venerdì 19 novembre 2010 10.16
A: For users and developers of the Firebird .NET providers
Oggetto: Re: [Firebird-net-provider] ADO.NET provider 2.6.0 for
Firebirdreleased
On Fri, Nov 19, 2010 at 10:07, Martin Turek tur...@bury.com wrote:
But it's still the same problem. The field I in the database is
varchar(10) and the value is only true or false (as I wrote). They
CAN'T get longer than 5. So, where the problem?
Who said, it's param5? What about param2 or param3?
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
__ Information from ESET NOD32 Antivirus, version of virus
signature database 5631 (20101118) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__ Information from ESET NOD32 Antivirus, version of virus signature
database 5631 (20101118) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ADO.NET provider 2.6.0 for Firebird released
On Fri, Nov 19, 2010 at 10:44, Martin Turek tur...@bury.com wrote:
Well, when I comment out param5 it runs without problems!
Looks like somewhere the parameter size or the value itself is longer.
The check there is:
string svalue = param.DbValue.GetString();
if ((param.Length % param.Charset.BytesPerCharacter) == 0
svalue.Length param.CharCount)
Try to put there string.Empty;
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ADO.NET provider 2.6.0 for Firebird released
Sorry, guys, you're right! I've limited the other params and it's ok!
Thanks!
Regards
Martin
-Ursprüngliche Nachricht-
Von: Jiri Cincura [mailto:disk...@cincura.net]
Gesendet: Freitag, 19. November 2010 11:03
An: For users and developers of the Firebird .NET providers
Betreff: Re: [Firebird-net-provider] ADO.NET provider 2.6.0 for Firebird
released
On Fri, Nov 19, 2010 at 10:44, Martin Turek tur...@bury.com wrote:
Well, when I comment out param5 it runs without problems!
Looks like somewhere the parameter size or the value itself is longer.
The check there is:
string svalue = param.DbValue.GetString();
if ((param.Length % param.Charset.BytesPerCharacter) == 0
svalue.Length param.CharCount)
Try to put there string.Empty;
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ADO.NET provider 2.6.0 for Firebird released
On Fri, Nov 19, 2010 at 12:24, Martin Turek tur...@bury.com wrote:
Sorry, guys, you're right! I've limited the other params and it's ok!
No problem. Sometimes I'm debugging wrong code too. :D
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] using Windows authentication
On Fri, Nov 12, 2010 at 16:17, Rick Roen r...@lakevalleyseed.com wrote:
and I get AccessViolationException with Attempt to read or write protected
memory…
If I do not set the UserId and Password at all, I get an
InitializeSecurityContext failed message.
I have a feeling it's 64bit related. Anyway can you provide a complete
stack trace?
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
