Re: [pysqlite] list-pysqlite Digest, Vol 8, Issue 9

Dear Gerhard,

I would like to thank you very much for the info you sent me! This was 
the exact kind of info I needed! Thanks!

Have a great day!

Michel


list-pysqlite-request-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org wrote:
> Send list-pysqlite mailing list submissions to
> 	list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite
> or, via email, send a message with subject or body 'help' to
> 	list-pysqlite-request-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
>
> You can reach the person managing the list at
> 	list-pysqlite-owner-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of list-pysqlite digest..."
>
>
> Today's Topics:
>
>    1. Pysqlite 2.5.0 with FTS enabled (jimmy bot)
>    2. Re: Pysqlite 2.5.0 with FTS enabled (Gerhard H?ring)
>    3. Converting SQLite database (Michel dos Santos Mesquita)
>    4. Re: Converting SQLite database (Gerhard H?ring)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 29 Oct 2008 02:03:22 -0700
> From: "jimmy bot" <[email protected]>
> Subject: [pysqlite] Pysqlite 2.5.0 with FTS enabled
> To: list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
> Message-ID:
> 	<51bd762f0810290203q3a7bb070kd06e4cda9f8d2f47-JsoAwUIsXosN+BqQ9rBEUg@public.gmane.org>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hello,
>
> Just wanted to say a few things.  First, great idea!
>
> Second, for installation on Vista, you probably need to Run as administrator
> or it fails.  Also make sure you get rid of any previously installed
> pysqlite (due to easy_install or install program).
>
> Third, a minor issue: sqlite.sqlite_version reports 3.6.1.  But you compiled
> with 3.6.4?  Not really a problem, but I wonder why there's the discrepancy?
>
> Cheers.
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://itsystementwicklung.de/pipermail/list-pysqlite/attachments/20081029/321ad90a/attachment-0001.html 
>
> ------------------------------
>
> Message: 2
> Date: Wed, 29 Oct 2008 19:37:21 +0100
> From: Gerhard H?ring <[email protected]>
> Subject: Re: [pysqlite] Pysqlite 2.5.0 with FTS enabled
> To: "About pysqlite and APSW."
> 	<list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org>
> Message-ID: <[email protected]>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> jimmy bot wrote:
>   
>> Hello,
>>
>> Just wanted to say a few things.  First, great idea! 
>>
>> Second, for installation on Vista, you probably need to Run as 
>> administrator or it fails.  Also make sure you get rid of any previously 
>> installed pysqlite (due to easy_install or install program).
>>
>> Third, a minor issue: sqlite.sqlite_version reports 3.6.1. 
>> <http://3.6.1.>  But you compiled with 3.6.4?  Not really a problem, but 
>> I wonder why there's the discrepancy?
>>     
>
> The root of all evil in software-land: redundancy. I've got similar code 
> in both the win32 cross-compile script and in the normal setup.py 
> script. But only the normal one was updated for SQLite 3.6.4.
>
> I'll need to get rid of the redundancy and borrow some code from APSW 
> that automatically downloads the latest SQLite version by parsing the 
> SQLite website.
>
> -- Gerhard
>
>
> ------------------------------
>
> Message: 3
> Date: Wed, 29 Oct 2008 21:13:08 +0100
> From: Michel dos Santos Mesquita <Michel.Mesquita-X9DskfXPHWAW/[email protected]>
> Subject: [pysqlite] Converting SQLite database
> To: list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
> Message-ID: <C2B3D7FD-6B06-4471-A563-6B759A5BD4AE-afly1vuFV30@public.gmane.org>
> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
>
> Hi,
>
> I'm new to SQLite and I have been reading some books/website about it.  
> I am going to create a database in SQLite, but I'd like to have this  
> db available to other users. These are users who are not familiar with  
> SQLite, but with Microsoft Access.
>
> So, I would like to ask two questions:
>
> 1) Is it possible to open an SQLite db in MS Access?
>
> 2) Is there a program/function to convert from SQLite format to mdb  
> (MS Access) format?
>
> I thank you in advance!
>
> Kindest regards,
>
> Michel
>
>
> ------------------------------
>
> Message: 4
> Date: Thu, 30 Oct 2008 10:18:02 +0100
> From: Gerhard H?ring <[email protected]>
> Subject: Re: [pysqlite] Converting SQLite database
> To: "About pysqlite and APSW."
> 	<list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org>
> Message-ID: <[email protected]>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Michel dos Santos Mesquita wrote:
>   
>> Hi,
>>
>> I'm new to SQLite and I have been reading some books/website about it.  
>> I am going to create a database in SQLite, but I'd like to have this  
>> db available to other users. These are users who are not familiar with  
>> SQLite, but with Microsoft Access.
>>
>> So, I would like to ask two questions:
>>
>> 1) Is it possible to open an SQLite db in MS Access?
>>     
>
> MS Access can open any database via an ODBC link. And there's an ODBC 
> driver for SQLite. So it is possible.
>
>   
>> 2) Is there a program/function to convert from SQLite format to mdb  
>> (MS Access) format?
>>     
>
> Not directly, you'd have to write one yourself, which wouldn't bee too 
> difficult because there are Python libraries for accessing both.
>
> Evaluating all this you might come to the conclusion that it's better to 
> skip SQLite and just use the JET engine directly from Python. Features 
> are probably comparable to SQLite anyway.
>
> I'd use this library: http://adodbapi.sourceforge.net/
>
> It's a DB-API interface for any database accessible via Microsoft's ADO. 
>   There's a link on the page to the connection strings where you'll have 
> to look up the right one for MS Access.
>
> HTH
>
> -- Gerhard
>
>
> ------------------------------
>
> _______________________________________________
> list-pysqlite mailing list
> list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
> http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite
>
> End of list-pysqlite Digest, Vol 8, Issue 9
> *******************************************
>