Delphi Soap Server and SQL Server
Posted on 2006-07-10
Hi, I am new to web services, but I can see that it's pretty simple to create a basic soap server. But how to access an SQL server - does anyone have any examples. I have Delphi 7 Architect and BDS2006. My scenario is as follows:
- I have a SQL Server database on my website with one table, Customers.
- I want a soap server that has a simple function, "GetCustomer", that will query the DB for a customer id and return true or false if found.
- The client program connects to the internet and calls GetCustomer and passes a string and waits for the result.
If I had a sample to work from I would be off and running. I am used to local database development, but not web development. Any sample code, especially with regard to how to connect the database with authentication, would be greatly appreciated.