What "Database-Connector" to use under Linux?
 

Hi,

probably this topic doesnt fit exactly here - but I'll just try it.
What kind of "Database-Connector" may be used for platform- and vendor-independet Database-Access? I don't know much about ODBC. But using it under Linux and MacOS just doesn't "feel right". And what connector would be used, if the application solely is to be runable under Linux? Would JDBC be the right Solution?

Thanks

Thomas

Depends what database you want to use, what programming you want to use. JDBC of course good for Java, not for php. ODBC basically is universal connector, it can run in Windows & Linux. Please give more information than people can assist your easier. If you really confuse, go ahead to ODBC. It work for everything. But suitable driver for your database shall installed properly.

DB is Orcale, client Qt. I don't want to use OCI, because i have some troubles getting it running (although it is supported bei Qt) and the backend might change in the future. Isn't there something beside ODBC that meets those needs?

Other than Qt's built-in Oracle support (which is based on OCI,
as far as I know) and ODBC? No. And who'd want to maintain that?

Realistically it should be safe for you to use the Qt drivers.
I'm fairly that if/when Oracle changes the OCI interface, Trolltech
will follow. Why don't you build your app against *BOTH* of
those interfaces? If one starts failing (Oracle was faster than
trolltech) you could fall back to the still working but slower
ODBC. Just some food for thought.



Cheers,
Tink