Migrate Delphi 5 project to using SQL Server 2008

I'm migrating an old delphi 5 process from SQL Se开发者_如何学JAVArver 7 to SQL Server 2008.

One TQuery component not find all the fields of a table. Using "Add all fields" I only get 5 of 25 fields.

Any idea of how can I get all the fields?

---

If you're still using TQuery, you're using the BDE (Borland Database Engine). There have been dozens of changes to SQL Server since D5 was released, including Unicode support and lots of datatypes being added. It's highly unlikely that you'll be able to simply convert.

If you're using a higher version (SKU) than Professional, you should have ADO components, and can possibly replace the BDE with them. D5 Professional didn't include the ADO components; they were sold separately (and fairly expensive, considering the cost of the D5 Pro upgrade from D4) and probably are no longer available. You might be able to still find third-party ADO components that will support D5 and SQL Server 2008, though. Good luck!