 | |
#1
 
| |||
| |||
|
Any data access standard ? -
12-22-2006
, 04:23 AM
#2
| |||
| |||
|
|
I was thinking, is there any open, common standard for database and data access ? I have been using proprietary standards until now to access data and send SQL commands to most database systems but I want to switch to open source and I think there should be an open standard. One intended to be implemented and to run on all or most systems. I think ODBC tries to be such a standard, although it is not used much now as far as I know. |
- especially in the area of DDL. Other than that I know no standard for
access but JDBC is pretty ubiquitous although not an open standard
AFAIK. But it should work on more systems than ODBC.
Kind regards
robert
#3
| |||
| |||
|
|
On 22.12.2006 11:23, Timothy Madden wrote: I was thinking, is there any open, common standard for database and data access ? I have been using proprietary standards until now to access data and send SQL commands to most database systems but I want to switch to open source and I think there should be an open standard. One intended to be implemented and to run on all or most systems. I think ODBC tries to be such a standard, although it is not used much now as far as I know. SQL is an ANSI standard, however most vendors have their own extensions - especially in the area of DDL. Other than that I know no standard for access but JDBC is pretty ubiquitous although not an open standard AFAIK. But it should work on more systems than ODBC. |
application programming interface (API) for sending SQL to the database
engine and getting results.
I thought JDBC is the Java version of ODBC and that it only works with Java
Thank you,
Timothy Madden
Romania
#4
| |||
| |||
|
|
Robert Klemme wrote: On 22.12.2006 11:23, Timothy Madden wrote: I was thinking, is there any open, common standard for database and data access ? I have been using proprietary standards until now to access data and send SQL commands to most database systems but I want to switch to open source and I think there should be an open standard. One intended to be implemented and to run on all or most systems. I think ODBC tries to be such a standard, although it is not used much now as far as I know. SQL is an ANSI standard, however most vendors have their own extensions - especially in the area of DDL. Other than that I know no standard for access but JDBC is pretty ubiquitous although not an open standard AFAIK. But it should work on more systems than ODBC. I guess I forgot to say I am a programmer and I am looking for an application programming interface (API) for sending SQL to the database engine and getting results. I thought JDBC is the Java version of ODBC and that it only works with Java |
programming languages require different API's. There can't be a single
standard that fits all.
Basically, what is your requirement?
robert
#5
| |||
| |||
|
|
If you need to change the language from C++ to Delphi then a Delphi related web site / mailing list / newsgroup is probably a good place to seek further information. A quick google revealed this page which might help you dive further into the matter: |
The Borland newsgroups are by far and away the best resource for this
kind of question - newsgroups.borland.com
Paul...
--
plinehan __at__ yahoo __dot__ __com__
XP Pro, SP 2,
Oracle, 10.2.0.1 (Express Edition)
Interbase 6.0.2.0;
When asking database related questions, please give other posters
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.
Furthermore, as a courtesy to those who spend
time analysing and attempting to help, please
do not top post.
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.