Re: [sqlite] SQLite Port/ODBC Driver Question

Hello Vishal, As far as I know the Java version of the Werner javasqlite driver does not use a port and the odbc may not also. I have use this Java driver, but a more current active driver project for Java is at GitHub: https://github.com/xerial/sqlite-jdbc/ As indicated SQLite is local file

Re: [sqlite] SQLite Port/ODBC Driver Question

On 7/10/17, Rob Willett wrote: > > A good rule of thumb is to avoid using SQLite in situations where the > same database will be accessed directly (without an intervening > application server) and simultaneously from many computers over a > network." > Another way

Re: [sqlite] SQLite Port/ODBC Driver Question

It depends on what you mean remotely. By itself SQLite doesn't have any networking library built in. It's an embedded database. You can put application wrappers around the database, I believe that wrappers exist to make SQLIte into a true client/server but thats additional code. Also there

Re: [sqlite] SQLite Port/ODBC Driver Question

Rob, On Mon, Jul 10, 2017 at 7:06 AM, Rob Willett wrote: > Vishal, > > SQLite isn't a traditional client/server relational database, therefore > there isn't a port to open up. It runs on a local machine. I believe SQLite can successfully be run remotely. Thank

Re: [sqlite] SQLite Port/ODBC Driver Question

Vishal, SQLite isn't a traditional client/server relational database, therefore there isn't a port to open up. It runs on a local machine. Now there are wrappers around SQLite to extend it, I assume this ODBC driver is one of them. I suspect people here *may* know the answer regarding any

[sqlite] SQLite Port/ODBC Driver Question

Hi, Am trying to open a firewall to the machine having sqlite database. Does the SQLite database use a specific port number ? If not, then does the ODBC connection to SQLite using ODBC driver use a port ? Any help will be greatly appreciated. SQLite ODBC Driver: