access violations with Zeos and MSDE2000
Posted: 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:
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
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);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