>I have found out that using UNC paths vs a mapped drive to a server, is
>much slower. Specially if you are going to use a database shared amoungst
>other folks. I would suggest a test on both scenario (UNC path and mapped
>drive) and place some times on the same calls and you'll see the differe
"Steve Rogers" wrote...
On 9/23/2014 10:57 PM, Joe Mistachkin wrote:
Steve Rogers wrote:
Reading in order, it says that:
SQLiteDb.LDb3.PrepareCommand threw an exception with the message
'unable to open database file'
Is the database file name a UNC path? If so, the number of leading
backsl
On 9/23/2014 10:57 PM, Joe Mistachkin wrote:
Steve Rogers wrote:
Reading in order, it says that:
SQLiteDb.LDb3.PrepareCommand threw an exception with the message
'unable to open database file'
Is the database file name a UNC path? If so, the number of leading
backslashes must be doubled (i.e.
Steve Rogers wrote:
>
> Reading in order, it says that:
> SQLiteDb.LDb3.PrepareCommand threw an exception with the message
> 'unable to open database file'
>
Is the database file name a UNC path? If so, the number of leading
backslashes must be doubled (i.e. four leading backslashes are now
req
Am 16.05.2011 07:56, schrieb Christoph P.U. Kukulies:
> Am 15.05.2011 16:04, schrieb Christoph P.U. Kukulies:
>> I keep getting an SQL error
>> "unable to open database file"
I solved it: The problem is netbeans (7.0 in this case). When I run the
application outside
netbeans from the DOS prompt
C
Am 15.05.2011 16:04, schrieb Christoph P.U. Kukulies:
> I keep getting an SQL error
> "unable to open database file"
>
> after doing some 20 inserts into two tables of my database in a loop
> in a java function.
>
> In the main code I have
> String sql="INSERT INTO part(name,md5sum,size,pfad) VALUE
On Thu, Oct 7, 2010 at 1:03 PM, Serena Lien wrote:
>
> If you find any vista OS patches that solve this problem, please let
> me know, we are looking ourselves in the hopes that microsoft has
> resolved this issue..
>
>
Serena,
How about this patch :
http://support.microsoft.com/kb/935366/en-us(
Hi,
Just wanted to say we have the same issue, using sqlite v3.6.15 (not
java) running on *some* windows vista machines accessing databases on
*some* networked drives. I don't think this is an sqlite problem,
because vista is obviously randomly locking files and this can be seen
when using microso
Timo wrote:
> OperationalError: unable to open database file
Note that there is a group specifically for using Python with SQLite:
http://groups.google.com/group/python-sqlite
Unfortunately SQLite's error reporting isn't particularly detailed when
opening databases. There are a lot of things
D. Richard Hipp wrote:
>
> (2) Formal and detail requirements that define precisely what SQLite
> does.
>
> http://www.sqlite.org/draft/tokenreq.html
> http://www.sqlite.org/draft/syntax.html
>
These look great. I noticed a few typos, but on the whole they are very
good.
I noti
On Aug 12, 2008, at 2:32 PM, Dennis Cote wrote:
> What kind of fish are you frying now, or is it top secret?
(1) Improvements to memory allocation performance, measurement, and
control and documentation of the memory allocation subsystem.
http://www.sqlite.org/draft/malloc.html
(2) Form
D. Richard Hipp wrote:
>
> Adding new result codes is complicated. There exist applications that
> only check for the current set of result codes. So if new result
> codes are added, those applications might fail. Hence adding new
> result codes can lead to compatibility problems in legac
On Aug 12, 2008, at 1:37 PM, Dennis Cote wrote:
> Igor Tandetnik wrote:
>> "Robert Latest" <[EMAIL PROTECTED]>
>> wrote in message
>> news:[EMAIL PROTECTED]
>>> $ sqlite3 /cygdrive/d/cl_hist_dat/clhist.sqlite
>>> SQLite version 3.5.1
>>> Enter ".help" for instructions
>>> sqlite> create view y as
Igor Tandetnik wrote:
> "Robert Latest" <[EMAIL PROTECTED]>
> wrote in message
> news:[EMAIL PROTECTED]
>> $ sqlite3 /cygdrive/d/cl_hist_dat/clhist.sqlite
>> SQLite version 3.5.1
>> Enter ".help" for instructions
>> sqlite> create view y as select * from tools;
>> sqlite> create temporary view z as
Thanks, that was it. I don't know exactly how the errors were
interrelated, but once I told sqlite (via the PRAGMA thing) to use
memory for tmp stuff, all was fine.
I'm working under a cygwin environment which seems to be a bit shaky
when it comes to system-specific stuff like permissions.
robert
"Robert Latest" <[EMAIL PROTECTED]>
wrote in message
news:[EMAIL PROTECTED]
> $ sqlite3 /cygdrive/d/cl_hist_dat/clhist.sqlite
> SQLite version 3.5.1
> Enter ".help" for instructions
> sqlite> create view y as select * from tools;
> sqlite> create temporary view z as select * from modules;
> SQL err
On Mon, Aug 11, 2008 at 1:42 PM, P Kishor <[EMAIL PROTECTED]> wrote:
> ahhh... I did misread the question. Yes, the above explanation seems
> logical. Your app is probably tying up the db, so you can't drop the
> table from the command line.
No it ain't. That's of course the first thing I checked.
On 8/11/08, Mihai Limbasan <[EMAIL PROTECTED]> wrote:
> Robert Latest wrote:
>
> > Hello people,
> >
> > why is it that I can look at the ".schema" of a db with the sqlite3
> > command line tool, but can't drop a table or view? After all, if the
> > db file weren't open, I couldn't even see the sch
Robert Latest wrote:
Hello people,
why is it that I can look at the ".schema" of a db with the sqlite3
command line tool, but can't drop a table or view? After all, if the
db file weren't open, I couldn't even see the schema.
My problem is that I've written an app that uses views to access data
On 8/11/08, Robert Latest <[EMAIL PROTECTED]> wrote:
> Hello people,
>
> why is it that I can look at the ".schema" of a db with the sqlite3
> command line tool, but can't drop a table or view? After all, if the
> db file weren't open, I couldn't even see the schema.
I have no idea what you are
"Francesco Andrisani" <[EMAIL PROTECTED]> wrote:
> Hi comunity,
> i'm writing CGI pages (writeen in ANSI C) with SQLITE3 support, all work fine
> using "SELECT" statement, but when i try to exec "UPDATE" or "INSERT"
> statement i've the follow error:
>
> unable to open database file
>
> I've se
rsday, January 27, 2005 9:42 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Unable to open database file
Drew, Stephen said:
> Yet Starteam (version control system) is still interfering with the
> file
> - causing unexpected errors while the application is running. Is this
> becau
Drew, Stephen said:
> Yet Starteam (version control system) is still interfering with the file
> - causing unexpected errors while the application is running. Is this
> because the locking in Windows is below-par in comparison with the Unix
> locking? The thing is that Starteam is not even inter
t: Monday, November 22, 2004 11:49 AM
Subject: Re: [sqlite] unable to open database
--- Steven Lloyd <[EMAIL PROTECTED]> wrote:
I have been using SQLite successfully for quite some
time. I recently installed it on a friends server in
order to use it there.
While I am able to access the db file
using the full path to the
> file and still get the same error.
>
> Any other ideas?
>
> Steve
> - Original Message -
> From: "Clay Dowling" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, November 21, 2004 7:38 AM
> Subject: Re
--- Steven Lloyd <[EMAIL PROTECTED]> wrote:
> I have been using SQLite successfully for quite some
> time. I recently installed it on a friends server in
> order to use it there.
>
> While I am able to access the db file just fine when I
> run my perl script from the shell prompt I get the
> fo
Steven Lloyd said:
> I thought of that first but still no luck. I am using the full path to
> the
> file and still get the same error.
>
> Any other ideas?
You might want to check if that path is really the full path. A lot of
servers are set up in a chroot environment, which changes where the
M
Subject: Re: [sqlite] unable to open database
Steven Lloyd said:
I have been using SQLite successfully for quite some time. I recently
installed it on a friends server in order to use it there.
While I am able to access the db file just fine when I run my perl script
from the shell prompt I get th
Steven Lloyd said:
> I have been using SQLite successfully for quite some time. I recently
> installed it on a friends server in order to use it there.
>
> While I am able to access the db file just fine when I run my perl script
> from the shell prompt I get the following error when trying to ru
29 matches
Mail list logo
