access violations with Zeos and MSDE2000

Forum related to MS SQL Server

Moderators: gto, cipto_kh, EgonHugeist

User avatar
ste_ba
Zeos Dev Team
Zeos Dev Team
Posts: 29
Joined: 15.02.2006, 20:26
Location: Lahntal
Contact:

access violations with Zeos and MSDE2000

Postby ste_ba » 22.02.2006, 11:29

Hi,

I keep getting error messages while trying to use Zeos with MS SQL server. The message (in German) is:

Im Projekt [MyProject].exe ist eine Exception der Klasse EAccessViolation aufgetreten. Meldung: 'Zugriffsverletzung bei Adresse 4FF7D956 in Modul 'sqloledb.dll'. Lesen von Adresse 06E10000'. Prozess wurde angehalten. Mit Einzelne Anweisung oder Start fortsetzen.

... which means there was an access violation in sqloledb.dll. The debugger stops within the procedure TZAdoPreparedStatement.SetInParam in Unit ZDbcAdoStatement in line 296:

Code: Select all

OleDBCmdParams.GetParameterInfo(OleDBPC, ParamInfo, NamesBuffer);


Any ideas that might help?

Apart from that, I notice that there are problems with negative of zero values in query parameters (such as SELECT * FROM atable WHERE id_col= :idparam). I haven't encountered such problems with other DBMS and Zeos, only MS. It's okay for me to keep an eye on the values not begin negative, but it's not meant to be this way, is it?

Regards,
Stefan

User avatar
ste_ba
Zeos Dev Team
Zeos Dev Team
Posts: 29
Joined: 15.02.2006, 20:26
Location: Lahntal
Contact:

Postby ste_ba » 22.02.2006, 12:17

PS: The error is caused by the line above, line 295. It calls a "Prepare(0)" method. Why it sometimes causes an access violation and sometimes it doesn't, I can't say. There seems to be something odd with parameter handling between Zeos and MS SQL.
Stefan


Return to “MS SQL Server”

Who is online

Users browsing this forum: No registered users and 1 guest