Link to home
Create AccountLog in
Delphi

Delphi

--

Questions

--

Followers

Top Experts

Avatar of Ann_Van_Eyken
Ann_Van_Eyken

TQuery.Close causes Access Violation in idodbc32.dll
I have a Delphi 4 application that uses a TQuery (placed at design time on a datamodule) to get information from a MS SQL Server 7.0 database.

After the user has entered an ID that is used as a parameter for the query, I open the query and use it to show/edit some information in a form.
When that form is closed, I also close the query.

Then the user can enter another ID, etc ...

This works fine for several times, but then suddenly I got an "access violation in idodbc32.dll" when closing the query.  
Since this error always occurs on another ID (sometimes it occurs the 3th time I enter an ID; sometimes it occurs the 10th time I enter an ID, ...), I don't think there 's something wrong with the data in my database.
I checked the following properties of the query before it is closed:
Active = true
Database.Databasename : stil valid
State = dsEdit

Any ideas what is going wrong or what I do wrong ?


P.S:  My idodbc32.dll was last modified on the 10th of may 2001, 19:00

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


ASKER CERTIFIED SOLUTION
Avatar of geobulgeobul

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Delphi

Delphi

--

Questions

--

Followers

Top Experts

Delphi is the most powerful Object Pascal IDE and component library for cross-platform Native App Development with flexible Cloud services and broad IoT connectivity. It provides powerful VCL controls for Windows 10 and enables FMX development for Windows, Mac and Mobile. Delphi is your choice for ultrafast Enterprise Strong Development™. Look for increased memory for large projects, extended multi-monitor support, improved Object Inspector and much more. Delphi is 5x faster for development and deployment across multiple desktop, mobile, cloud and database platforms including 32-bit and 64-bit Windows 10.