I didn't set the Direction parameter to input.. Maybe the exception could be
a bit clearer about that?
On 5/14/07, Jon Ege Ronnenberg <[EMAIL PROTECTED]> wrote:
I did what you posted and it works on some sprocs but not all... sometimes
I get a Dynamic SQL Error
parameter mismatch for procedure
Not sure how this works, but if I set the Charset to NONE with a db with
Charset NONE I can insert/extract none ASCII characters. Possible the
provider translate all the characters.
On 5/13/07, Jon Ege Ronnenberg <[EMAIL PROTECTED]> wrote:
Probably yes, but I have to talk to the DBA. Also anoth
I did what you posted and it works on some sprocs but not all... sometimes I
get a Dynamic SQL Error
parameter mismatch for procedure BE_LOCATION_INFO_INSERT.
I'll look more into this tomorrow with the DBA and post some more info.
On 5/13/07, Jiri Cincura <[EMAIL PROTECTED]> wrote:
Yes, you're
Some extra info:
I use ASP.NET 2.0 on the server and my globalization configuration is set to
UTF-8 in requestEncoding, responseEncoding and fileEncoding. The FireBird
Data Provider is version 2.1.0.0
-
This SF.net email is sp
Probably yes, but I have to talk to the DBA. Also another problem was that
the data sent from the web server was in UTF-8 and the db wasn't. We changed
that by using IBExpert to copy everything to a new UNICODE_FSS database and
the connection string I changed to have Charset=UNICODE_FSS;.But now I
Carlos Guzmán Álvarez wrote:
> The First example you have sent has a valid syntax too, and should work
> fine too, the query should be changed by the provider adding the execute
> procedure before executing the query.
Looks like we have some woodoo in SPs. :)
--
Jiri {x2} Cincura
http://blog.v
Hello:
> Jiri you are probably one of the people of this list that knows the most
> about Firebird but I have to say (just for the record if anyone else see
> this post) that your answer is incorrect. The right statement is
> "execute procedure BE_BOOKING_INSERT(@BookingID, @UserID, @EventID,
Yes, you're right.
But if you want to use this statement as SP, use it like:
using (FbConnection conn = new FbConnection(cs))
{
conn.Open();
using (FbCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "test_insert"; // NO "test_insert(@id, ...)"
cmd.CommandTyp
Jiri you are probably one of the people of this list that knows the most
about Firebird but I have to say (just for the record if anyone else see
this post) that your answer is incorrect. The right statement is "execute
procedure BE_BOOKING_INSERT(@BookingID, @UserID, @EventID, @DateFrom,
@DateTo,
Jon Ege Ronnenberg wrote:
> The question is what is the right syntax and do I need to set anything
> else on Command object?
The first is right.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
--
10 matches
Mail list logo
