EAccessViolation - 'dbodbc11.dll

[yar]

Hi,

I use through ODBC and DB SQLAnywhere
When I run procedure
I get a crash:

EAccessViolation - Access violation at address 04C2E870 in module 'dbodbc11.dll'. Write of address 00,000,008

[Microsoft] [ODBC Driver Manager] Function sequence error

[AlexP]

Hello,

Please send the script for creating the procedure, and also specify the exact versions of IDE, UniDAC and SQLAnywhere client and server.

[yar]

delphi 7 , SQLAnywhere v11

[AlexP]

Please send the script for creating the procedure.

[yar]

alter procedure DBA.WEBXMLDataEdit( @sp_Action smallint,@sp_pknRecID integer,@sp_WorkingCompany integer,@sp_XMLInfo timestamp,@sp_XMLType varchar(15),@sp_XMLData long varchar,@sp_DateReplication timestamp,@sp_DateImportAsakim timestamp,@sp_XMLID integer,@sp_nPopulationCardNumber integer,@sp_IDWEBSettings integer,@sp_TableName integer,@sp_ReturnedPknRecID integer output )

add @sp_TableName integer
add @sp_nPopulationCardNumber integer @sp_IDWEBSettings integer
add @sp_XMLID integer
add @sp_Action = 8
add DateImportAsakim
add DateReplication
created for project WEB

as
begin
declare @sp_Shrek integer
if(@sp_Action = 3)
begin
insert into WEBXMLData( WorkingCompany,
XMLInfo,XMLType,XMLData,DateReplication,
DateImportAsakim,XMLID,nPopulationCardNumber,
IDWEBSettings,TableName )
values( @sp_WorkingCompany,@sp_XMLInfo,@sp_XMLType,
@sp_XMLData,@sp_DateReplication,@sp_DateImportAsakim,
@sp_XMLID,@sp_nPopulationCardNumber,@sp_IDWEBSettings,@sp_TableName )
select @sp_ReturnedPknRecID = @@identity
end
else
if(@sp_Action = 2)
begin
update WEBXMLData
set WorkingCompany = @sp_WorkingCompany,XMLInfo = @sp_XMLInfo,XMLType = @sp_XMLType,
XMLData = @sp_XMLData,DateReplication = @sp_DateReplication,DateImportAsakim = @sp_DateImportAsakim,
XMLID = @sp_XMLID,nPopulationCardNumber = @sp_nPopulationCardNumber,IDWEBSettings = @sp_IDWEBSettings,
TableName = @sp_TableName where pknRecID = @sp_pknRecID
end
else
if(@sp_Action = 6)
begin
update WEBXMLData set XMLID = @sp_XMLID where pknRecID = @sp_pknRecID
end
else
if(@sp_Action = 7)
begin
update WEBXMLData set DateImportAsakim = @sp_DateImportAsakim where pknRecID = @sp_pknRecID
end
else
if(@sp_Action =
begin
update WEBXMLData set XMLData = @sp_XMLData where pknRecID = @sp_pknRecID
end
else
if(@sp_Action = 12)
begin
delete from WEBXMLData where pknRecID = @sp_pknRecID
end
end

[AlexP]

Please provide the code causing the error and the scripts to create used objects, or send a small sample demonstrating the problem to alexp*devart*com.