Re: [sqlite] Opening a database on a Mac

2011-06-17 Thread john darnell 
Thanks  Pavel.  That worked.

R,
John

> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
> On Behalf Of Pavel Ivanov
> Sent: Friday, June 17, 2011 2:23 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Opening a database on a Mac
> 
> >   strcpy(DBEnginePath, "Macintosh HD:Applications:Adobe InDesign CS5:Plug-
> Ins:WPC_ID:IndexData.db");
> 
> Try to change path here to "/Applications/Adobe InDesign
> CS5/Plug-Ins/WPC_ID/IndexData.db".
> 
> 
> Pavel
> 
> 
> On Fri, Jun 17, 2011 at 3:08 PM, john darnell
> <john.darn...@walsworth.com> wrote:
> > Sorry to send this twice, but I realized that my first transmission did not 
> > include a
> subject line.
> >
> > _
> > From: john darnell
> > Sent: Friday, June 17, 2011 1:56 PM
> > To: 'General Discussion of SQLite Database'
> > Subject:
> >
> >
> > I am attempting to open an SQLite database on the Mac (OSX Snow Leopard)
> and am getting an error.  This is the code I am using:
> >
> >
> >   char      DBEnginePath[1000];
> >
> >   strcpy(DBEnginePath, "Macintosh HD:Applications:Adobe InDesign CS5:Plug-
> Ins:WPC_ID:IndexData.db");
> >   fprintf(stderr, "%s\n", DBEnginePath);                                    
> >     //  Sends
> correct path to stderr for verification.
> >   Result = sqlite3_open_v2(DBEnginePath, _ptr,
> SQLITE_OPEN_READONLY, NULL);  //  Errors out here.
> >
> >   const char *msg = sqlite3_errmsg(db_ptr);
> >   fprintf(stderr, "Here's the SQLite error message: %s\n", msg);            
> >     // Sent
> to stderr: "Unable to open database file."
> >
> >
> > I have verified that the file exists on the path described above.  What am 
> > I doing
> wrong?
> >
> > TIA!
> >
> > R,
> > John A.M. Darnell
> > Senior Programmer
> > Walsworth Publishing Company
> > Brookfield, MO
> > John may also be reached at
> johnamdarn...@gmail.com<mailto:johnamdarn...@gmail.com>
> >
> > Trivia question Trivia question:  In The Lord of the Rings,Leglolas was a 
> > prince
> among the Silvan Elves.  What was the name of his father the King?  For extra
> credit, what was his surname?
> >
> >
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Opening a database on a Mac

2011-06-17 Thread Pavel Ivanov 
>   strcpy(DBEnginePath, "Macintosh HD:Applications:Adobe InDesign 
> CS5:Plug-Ins:WPC_ID:IndexData.db");

Try to change path here to "/Applications/Adobe InDesign
CS5/Plug-Ins/WPC_ID/IndexData.db".


Pavel


On Fri, Jun 17, 2011 at 3:08 PM, john darnell
 wrote:
> Sorry to send this twice, but I realized that my first transmission did not 
> include a subject line.
>
> _
> From: john darnell
> Sent: Friday, June 17, 2011 1:56 PM
> To: 'General Discussion of SQLite Database'
> Subject:
>
>
> I am attempting to open an SQLite database on the Mac (OSX Snow Leopard) and 
> am getting an error.  This is the code I am using:
>
>
>   char      DBEnginePath[1000];
>
>   strcpy(DBEnginePath, "Macintosh HD:Applications:Adobe InDesign 
> CS5:Plug-Ins:WPC_ID:IndexData.db");
>   fprintf(stderr, "%s\n", DBEnginePath);                                      
>   //  Sends correct path to stderr for verification.
>   Result = sqlite3_open_v2(DBEnginePath, _ptr, SQLITE_OPEN_READONLY, 
> NULL);  //  Errors out here.
>
>   const char *msg = sqlite3_errmsg(db_ptr);
>   fprintf(stderr, "Here's the SQLite error message: %s\n", msg);              
>   // Sent to stderr: "Unable to open database file."
>
>
> I have verified that the file exists on the path described above.  What am I 
> doing wrong?
>
> TIA!
>
> R,
> John A.M. Darnell
> Senior Programmer
> Walsworth Publishing Company
> Brookfield, MO
> John may also be reached at 
> johnamdarn...@gmail.com
>
> Trivia question Trivia question:  In The Lord of the Rings,Leglolas was a 
> prince among the Silvan Elves.  What was the name of his father the King?  
> For extra credit, what was his surname?
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Opening a database on a Mac

2011-06-17 Thread john darnell 
Sorry to send this twice, but I realized that my first transmission did not 
include a subject line.

_
From: john darnell
Sent: Friday, June 17, 2011 1:56 PM
To: 'General Discussion of SQLite Database'
Subject:


I am attempting to open an SQLite database on the Mac (OSX Snow Leopard) and am 
getting an error.  This is the code I am using:


   char  DBEnginePath[1000];

   strcpy(DBEnginePath, "Macintosh HD:Applications:Adobe InDesign 
CS5:Plug-Ins:WPC_ID:IndexData.db");
   fprintf(stderr, "%s\n", DBEnginePath);   
 //  Sends correct path to stderr for verification.
   Result = sqlite3_open_v2(DBEnginePath, _ptr, SQLITE_OPEN_READONLY, NULL); 
 //  Errors out here.

   const char *msg = sqlite3_errmsg(db_ptr);
   fprintf(stderr, "Here's the SQLite error message: %s\n", msg);   
 // Sent to stderr: "Unable to open database file."


I have verified that the file exists on the path described above.  What am I 
doing wrong?

TIA!

R,
John A.M. Darnell
Senior Programmer
Walsworth Publishing Company
Brookfield, MO
John may also be reached at 
johnamdarn...@gmail.com

Trivia question Trivia question:  In The Lord of the Rings,Leglolas was a 
prince among the Silvan Elves.  What was the name of his father the King?  For 
extra credit, what was his surname?



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Opening SQLite database file on Mac OS X AppleShare volume

2008-06-24 Thread Michael Dupuis 
"-DSQLITE_ENABLE_LOCKING_STYLE=1"
I personally found that this is not as simple as just turning on this
compiler flag. When I turned  on this flag (set it to 1) I could then not
get the latest version of SQLite to compile, and my queries here as to why
it wouldn't compile went unanswered.

On Tue, May 27, 2008 at 12:01 AM, BareFeet <[EMAIL PROTECTED]> wrote:

> Hi all,
>
> As you may know, I posted a comparison of various SQLite management
> tools (mainly for Mac OS X) at:
> http://www.tandb.com.au/sqlite/compare/?ml
> One of the features I compare is whether each tool can open a database
> file on a remote volume. Several of the applications there require a
> JDBC plug in, for which I've been using the Zentus sqlitejdbc. That
> plug in (and therefore those applications) fail to open files on a
> remote volume.
>
> On a separate discussion forum, about the Zentus sqlitejdbc, I
> suggested that they enable their implementation of SQLite to open
> files on shared Mac OS volumes (ie via AppleShare). As I understand
> it, the default release of SQLite source code still does not
> facilitate this, but requires a small compile time change:
>
>  -DSQLITE_ENABLE_LOCKING_STYLE=1
>
> I believe that this is enabled in the SQLite that's distributed in Mac
> OS X, and was due to be included in the SQLite source code, but I
> haven't seen it appear yet.
>
> Two questions:
>
> 1. Will this be enabled by default in the SQLite source code soon?
>
> 2. The author (I believe) of the Zentus SQLiteJDBC comments below.
> What can I tell him?
>
> Thanks,
> Tom
> BareFeet
>
>  
> From: "David Crawshaw" <[EMAIL PROTECTED]>
> Date: 4 May 2008 4:02:02 PM
> To: [EMAIL PROTECTED]
> Subject: [sqlitejdbc] Re: Opening SQLite database file on Mac OS X
> AppleShare volume
> Reply-To: [EMAIL PROTECTED]
>
> Is this turned on the SQLite binaries for Mac OS X? If so, I'm willing
> to add it to the SQLiteJDBC binary, but not until then. Yes, it's a
> terrible bug on Apple's part, yes, SQLite needs to work around it, but
> this driver's binary releases should remain as similar as possible to
> the main binary releases.
>
> Compiling your own version with this is easy.
>
> d.
>
>  
> Date: 2008/4/26
> From: BareFeet
>
> Here's a quote from the author of SQLite, Dr Richard Hipp:
> http://www.mail-archive.com/sqlite-users@sqlite.org/msg22772.html
>
> >  -DSQLITE_ENABLE_LOCKING_STYLE=1
> >
> > We are working toward turning on this patch by default, but we are
> > not quite there yet.
> --~--~-~--~~~---~--~~
> Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
> To unsubscribe, send email to [EMAIL PROTECTED]
> -~--~~~~--~~--~--~---
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users