MySQL Forums
Forum List  »  Serbian/Croatian/Bosnian

error -2147467259
Posted by: goran vojvodic
Date: June 01, 2009 07:18AM

Postovani,

imam ovakav slucaj.

Storana procedura :
DELIMITER $$

DROP PROCEDURE IF EXISTS `konspekt_sigurnost`.`SpremaADD`$$

CREATE PROCEDURE `SpremaADD`(IN cStrucnaSprema VARCHAR(100),IN cSkraceno VARCHAR(40))
BEGIN
DECLARE cSkraceno2 VARCHAR(3);
SET cSkraceno2 = LEFT(cStrucnaSprema,3);
INSERT INTO strucnespreme (strucnasprema,skraceno) VALUES (cStrucnaSprema,cSkraceno);
END$$

DELIMITER ;


U VB 6.0 pozivam storu :

Set cmd = Nothing
Set cmd = New ADODB.command
cmd.ActiveConnection = conn
cmd.ActiveConnection.CursorLocation = adUseClient
cmd.CommandTimeout = 0
cmd.CommandType = adCmdText

''''
If lDodaje = True Then
'construct MySQL call for stored procedure
cmd.CommandText = "call spremaADD('" & txtNaziv & "','" & txtSkraceno & "') ;"
cmd.Execute
Set cmd = Nothing
endif

I ovo sve radi kod mene na razvojnom PC-u.
Kad sam instalirao kod korisnika server, bazu, aplikaciju i sve sto treba, kod pozivanja storanih procedura javlja mi se greska :

err.Number
-2147467259

err.Description
[MySQL][ODBC 3.51 Driver][mysqld-5.0.18-nt]Data too long for column 'cStrucnaSprema' at row 1

To mi se javlja samo kad se upisuju nasi znakovi ( šđčćž )!!!!
Napominjem da je server i ODBC driveri isti kod mene i kod korisnika.

Ima li tko kakvu ideju?

Unaprijed zahvalan

g

Options: ReplyQuote


Subject
Views
Written By
Posted
error -2147467259
10028
June 01, 2009 07:18AM
4770
June 20, 2009 04:19AM
4385
July 16, 2009 05:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.