Yes using JDBC, but how does the other language able to call the Java API.
Main Topics
Browse All TopicsI have a requirement to develop an API for any language on any platform to connect MS SQL database. Can I use Java?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Missed the 'any language' bit when I first read your question.
Not sure how you could implement a protocol in ANY language that would allow any language to use it.
There are certainly ways using JNI to allow other languages to use your Java implementation of the protocol, but you would have to implement the interface for each individual language. As would be the case if you implemented your API in C, or VB, or perl, or whatever.
Another thing you could do would be to proviude a command line interface to you protocol implementation, or a simple socket interface. Then other languages could simply call your Java implementation as if it was another application.
Hi cwchaw
In the simplest terms, you can write a JAVA BASED SERVER PROGRAM running on some port on some machine.
This JAVA SERVER connects to the MS-SQL database thru the JDBC INTERFACE.
Then implement a client in any other LANGUAGE and pass queries from this client to the JAVA BASED SERVER.
Thus your client is effectively communicating with the MS-SQL database itself.
Let me add that i DONT NOT CALL this an API feature.Its just a type of 'client-server' communication.
But the good news is this that, YES you can use java to get the functionality you want.
Why dont you go for CORBA.Its just the right thing you need.Though i havent done enough programming thru IDL i can say that its DEFINITELY possible to use java as an API,just as you want.
rameshnut
Question(s) below appears to have been abandoned. Your options are:
1. Accept a Comment As Answer (use the button next to the Expert's name).
2. Close the question if the information was not useful to you. You must tell the participants why you wish to do this, and allow for Expert response.
3. Ask Community Support to help split points between participating experts, or just comment here with details and we'll respond with the process.
4. Delete the question. Again, please comment to advise the other participants why you wish to do this.
For special handling needs, please post a zero point question in the link below and include the question QID/link(s) that it regards.
http://www.experts-exchang
Please click the Help Desk link on the left for Member Guidelines, Member Agreement and the Question/Answer process. Click you Member Profile to view your question history and keep them all current with updates as the collaboration effort continues, in the event new items have been created since this listing was pulled.
http://www.experts-exchang
To view your open questions, please click the following link(s) and keep them all current with updates.
http://www.experts-exchang
http://www.experts-exchang
PLEASE DO NOT AWARD THE POINTS TO ME.
------------> EXPERTS: Please leave any comments regarding this question here on closing recommendations if this item remains inactive another three days.
Thank you everyone.
Moondancer
Moderator @ Experts Exchange
P.S. For any year 2000 questions, special attention is needed to ensure the first correct response is awarded, since they are not in the comment date order, but rather in Member ID order.
Business Accounts
Answer for Membership
by: objectsPosted on 2001-06-28 at 03:00:59ID: 6234605
In general terms, yes you can I've personally found Java to be an excellent language for developing protocols.
Specifically regarding a protocol for accessing MS SQL are you talking about building a specific protocol on top of JDBC or something different?