For several reasons, I don't have the opportunity to use BDE. More than that, the less i have to install extra (of database engines), the better. Some have told me that I could just connect directly to ODBC, and then use SQL queries there. I have made some attempts to that, and couldn't make it work.
My questions is:
How do I register a database with the ODBC and connect to it, using only code in delphi?
Since I will have MS-SQL on the server, how can all the clients connect to that? ODBC as well??
Will ODBC/MS-SQL mean something to the syntax I should use in my queries??
If you know the answers to some of these questions, i would be very grateful. Short examples of code would be appreciated as well :-)
Kim Nørby Andersen