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

RE: [sqlite] SQLite and ODBC

improving the engine, rather than wasting their time re-inventing the wheel on things I CAN do... Steve -Original Message- From: Raymond Irving [mailto:[EMAIL PROTECTED] Sent: 17 May 2004 21:08 To: [EMAIL PROTECTED] Subject: RE: [sqlite] SQLite and ODBC Hi, I've download the version

RE: [sqlite] SQLite and ODBC

Hi, I've download the version at http://www.ch-werner.de/sqliteodbc/ and it works just fine. I was only making a suggestion that such a cool database should come bundled with an ODBC driver (meaning it's part of the development). SQLite is very cool but it does not make any sense if it

RE: [sqlite] SQLite and ODBC

Regarding: "I was more think of ways to get an SQLite Database connected to every day database objects and controls." A good point! This may be a naive comment of mine, but if you just forgot about the vanilla sqlite download page, and instead considered page:

Re: [sqlite] SQLite and ODBC

At 12:29 PM -0700 5/17/04, Raymond Irving wrote: Thanks for the feedback but I was not thinking about network connections to the database. I was more think of ways to get an SQLite Database connected to every day database objects and controls. Most of todays database tools use ODBC. One

Re: [sqlite] SQLite and ODBC

Well put, Darren. Raymond, I would say that if you need ODBC then you need to use a different database (server) all together. SQLite fills the embedded database niche perfectly but it is not a replacement for MS-SQL, MySQl, PostgreSQl, Oracle or other database *servers*. If you need a RDBMS

Re: [sqlite] SQLite and ODBC

Darren Duncan wrote: At 7:25 AM -0700 5/17/04, Raymond Irving wrote: I think SQLite should come standard with an odbc driver since ODBC is an "open standard" I disagree. .. Finally, while ODBC is very common, it isn't the only protocol for networking databases, and some people may prefer an

Re: [sqlite] SQLite and ODBC

At 7:25 AM -0700 5/17/04, Raymond Irving wrote: I think SQLite should come standard with an odbc driver since ODBC is an "open standard" I disagree. Partly this is because D. Richard Hipp would then have to start certifying it like his own code and ensuring that it is always up to date with the

RE: [sqlite] SQLite and ODBC/JDBC driver

> -Original Message- > From: Jean-Eric Cuendet [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 6:06 AM > To: [EMAIL PROTECTED] > Subject: [sqlite] SQLite and ODBC/JDBC driver > > There is an ODBC driver here: http://www.ch-werner.de/sqliteodbc/ > But there is no