error -2147467259
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
Subject
Views
Written By
Posted
error -2147467259
11699
June 01, 2009 07:18AM
5476
June 20, 2009 04:19AM
5062
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.