access violations with Zeos and MSDE2000

[ste_ba]

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

[ste_ba]

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