Solved

Delphi Soap Server and SQL Server

Posted on 2006-07-10
6
1,042 Views
Last Modified: 2010-04-05
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.

Gary
0
Comment
Question by:GaryBytes
  • 3
  • 3
6 Comments
 
LVL 12

Expert Comment

by:Ivanov_G
ID: 17074984
You can work with MIDAS (TClientDataSet and TDataSetProvider) or work with SOAP Server that return XML to the client. This way you can have client written for other platforms and with other languages.
0
 

Author Comment

by:GaryBytes
ID: 17075410
Thank you. Do you have any examples of working with MIDAS and SQL Server and a SOAP Server?

Thanks, Gary
0
 
LVL 12

Expert Comment

by:Ivanov_G
ID: 17075802
0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 

Author Comment

by:GaryBytes
ID: 17077332
Thank you. I appreciate your help. I had a look at these articles and unfortunately they do not deal with SQL Server from a SOAP Server. The first article deals with Kylix and SOAP Servers, but I am ok on creatig a basic SOAP Server. It is getting the SQL Server aspect of it working that I am stumbling on. I didn't see the full releveance of the second article dealing with XML and ClientDataSets, but maybe I'm missing something.

Gary
0
 
LVL 12

Accepted Solution

by:
Ivanov_G earned 500 total points
ID: 17078962
I got it ... you want to see how to make web service connected with the database (SQL Server).

http://www-128.ibm.com/developerworks/db2/library/techarticle/0212cantu/0212cantu.html

Here is an article by Marcu Cantu, who gives example for WebService and DB2 that return XML. You can see also the client part.
0
 

Author Comment

by:GaryBytes
ID: 17094233
Many thanks for all your help.

Gary
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Mydac connection data base issue 3 156
delphi prevent click fast 2 213
Simple Delphi Question 9 89
Working with hours 3 56
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

805 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question