Need a help with DB connectivity

[damian]

Hi,
I am planning to start a project related to database system.Can anyone provide me with tools which are used for database connectivity. I am looking for something which would help me access (read and write) most of database systems-if not all. Any kind of suggestions are welcomed.

Regards damian.

[WingedPanther]

What database type? What programming language? Connecting to Oracle from C is completely different from connecting to MySQL in PHP.

[Jordan]

And there are many different tools and different for each type of database.
Posted via CodeCall Mobile

[WingedPanther]

True. JDBC vs ODBC vs ADO vs BDE vs ...

[chili5]

What language and what database server?

Connecting to MySQL with various languages.

[damian]

I have thought of Java as programming language. JDBC API would help me connect java with wide range of databases. SQL and oracle are database types. Presently I am at initial stages of literature survey.

The main idea is that the application should connect to popular databases and it should be platform independent (hence java).
Is it feasible to use java or should I look for some other programming language? Also Ill carry out more research on JDBC-ODBC connectivity.Thnx.

damian.

[chili5]

Sure it is feasible. Getting started with JDBC is quick and simple.

If you are thinking of using SQL server: Microsoft SQL Server JDBC Driver
Oracle: JDBC/UCP Download Page

So, you can use any database server you want with Java. I would go with MySQL though. Only, because I know that it is more independent of platforms (and free).

[damian]

Hey thanx buds.