Quantcast

Reading SQLite format 3

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Reading SQLite format 3

Keith Culotta ns
This is a new-to-SQL question.

I opened my QuickBooks data file with Text Edit and the first few characters are "SQLite format 3".  Can this type of data be accessed using the SQL LOGIN?

Keith
Computer Dimensions, Inc.
**********************************************************************
4D v12.2 is Available - Now Powered with 64-bit server
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Reading SQLite format 3

Rob Laveaux

On 23 sep 2011, at 16:22, Keith Culotta wrote:

> This is a new-to-SQL question.
>
> I opened my QuickBooks data file with Text Edit and the first few characters are "SQLite format 3".  Can this type of data be accessed using the SQL LOGIN?

Hi Keith,

I think you can only access it with SQL LOGIN if you install a ODBC driver for SQLite.

If you want something that is more easy to setup, use SQLite Plugin:
http://www.pluggers.nl/sqlite_plugin.html

HTH,

- Rob Laveaux

--------------------------------------------------------
Pluggers Software
Bleriotlaan 62
2497 BM  Den Haag
The Netherlands

Email: [hidden email]
Website: http://www.pluggers.nl

--------------------------------------------------------



**********************************************************************
4D v12.2 is Available - Now Powered with 64-bit server
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Reading SQLite format 3

Keith Culotta ns
Thanks, I'll take a look.

Keith
Computer Dimensions, Inc.

On Sep 23, 2011, at 10:11 AM, Rob Laveaux wrote:

>
> On 23 sep 2011, at 16:22, Keith Culotta wrote:
>
>> This is a new-to-SQL question.
>>
>> I opened my QuickBooks data file with Text Edit and the first few characters are "SQLite format 3".  Can this type of data be accessed using the SQL LOGIN?
>
> Hi Keith,
>
> I think you can only access it with SQL LOGIN if you install a ODBC driver for SQLite.
>
> If you want something that is more easy to setup, use SQLite Plugin:
> http://www.pluggers.nl/sqlite_plugin.html
>
> HTH,
>
> - Rob Laveaux
>
> --------------------------------------------------------
> Pluggers Software
> Bleriotlaan 62
> 2497 BM  Den Haag
> The Netherlands
>
> Email: [hidden email]
> Website: http://www.pluggers.nl
>
> --------------------------------------------------------
>
>
>
> **********************************************************************
> 4D v12.2 is Available - Now Powered with 64-bit server
> http://www.4d.com/products/new.html
>
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:[hidden email]
> **********************************************************************
>

**********************************************************************
4D v12.2 is Available - Now Powered with 64-bit server
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************
Loading...