PDA

View Full Version : How to access remote Database?



Qt_Kid
12th May 2011, 07:45
Dear All,
I've to access a Sqlite DB which is running at some other system. I've some doubt on this.

1. A database is created at a server end.
2. How to connect to that remote DB?
3. Do i need to pass IP along with datbase name And password to access that DB?

Thank you all.

wysota
12th May 2011, 08:11
SQLite doesn't have a notion of server thus you can't connect to a remote SQLite database unless you can access the database file directly (via a network share or remote filesystem).

Qt_Kid
12th May 2011, 09:23
SQLite doesn't have a notion of server thus you can't connect to a remote SQLite database unless you can access the database file directly (via a network share or remote filesystem).

Thank you very much wysota for this reply. Actually I'm new to DB and from my understanding...
In document it is mention taht QSqlDatabase represents a connection to a database. and in QSqlDatabase v can pass QSQLITE as an argument to interact an sqlite database QSqlDatabase::QSqlDatabase ( const QString & type ) http://doc.qt.nokia.com/latest/qsqldatabase.html#QSqlDatabase-2 (http://doc.qt.nokia.com/latest/qsqldatabase.html#QSqlDatabase-2) .

Cannt we use like mentioned in the Qt help manual?

wysota
12th May 2011, 11:17
SQLite is a local database engine operating directly on files. If you don't have access to the file, you can't access the database. With or without QSqlDatabase.