View Single Post
  #4  
Old 10-21-2016, 09:52 AM
Norrit Norrit is offline
Moderator
 
Join Date: Aug 2001
Location: Landgraaf
Posts: 7,335
Default

And you've provided the AdoQuery connectionstring with this one as suggested?

Furthermore, naming a variable TQuery is also not a good idea. Since TQuery is also a class in DBTables.
I would refactor it to:
Code:
 query: TADOQuery;
 sql: String;
And if all this still doesn't work, what happens if you create a TAdoConnection and set it to Connected, does that work?
And if that works, instead of the ConnectionString assign the Connection with this new AdoConnection.

Just figuring out if it goes wrong in the connection or in some other part.
For example executing the query, but that would normally give an exception, as connection failure should do also. Therefor my refactoring remark (it's a real longshot though)