Hi,
I am trying to modify win32 application to work on Oracle server with minimum code replacement. Aplication was designed for MySql in Delphi 2005.
I am using your dbx drivers for both connections to Database (dbxmysql and dbxpoda).
The problem with dbxpoda driver is that whenever i give the string parameter to query, open returns Error.
Example of the query:
qsql:=TSQLQuery.Create(application);
qsql.SQLConnection:= dbxpoda_connection;
qsql.sql.Add('SELECT * FROM INK_2008_PAYERS where OM=:OM');
qsql.Params.ParamByName('OM').AsString:='000000028';
try
qsql.Open;
except
on e:exception do MessageBox(0, pchar(e.Message), 'Error!', MB_ICONWARNING or MB_OK);
end;
The error is:
---------------------------
Debugger Fault Notification
---------------------------
Project C:\test\inkasso_oracle\inkasso.exe faulted with message: 'access violation at 0x028ec63d: write of address 0x00030f50'. Process Stopped. Use Step or Run to continue.
---------------------------
I would appreciate if you could help me.