Re: [sqlite] sqlite db portability
Thanks everyone for your input. Shilpa On 8/27/07, Asif Lodhi <[EMAIL PROTECTED]> wrote: > Hi Shilpa, > > On 8/28/07, Shilpa Sheoran <[EMAIL PROTECTED]> wrote: > > Eg. I create sqlite db file say "mysqlitedb.db" and now I have MySQL > > installed. Can it access "mysqlitedb.db" > > IIRC, I did read about "Linked Servers" in MS-SQL-Server documentation > where, if your SQL Server is being used in an NT domain setting then > you can create "Linked Servers" - which means that you can "link-in" > different databases having ADO wrappers. MS-Access is NOT a database > server but I think I did read that you could link in MS-Access > databases to your SQL Server process. Though I am NOT sure but I think > someone did mention ADO wrappers pertaining to Sqlite and I would > suggest that you give that a shot. > > -- > Best, > > Asif > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqlite db portability
Just FYI, ODBC specs is very similar to JDBC, except that ODBC is in C whereas JDBC is in java. Thanks Uma Markus Hoenicka <[EMAIL PROTECTED]> wrote: Quoting Uma Krishnan : > Hello Markus, > > How is libdbi different from, say odbc? > I've never used ODBC, but from what I read I'd say the main differences are the footprint and the scope. libdbi is language-specific (C), lightweight, and allows you to do simple things in a simple fashion. However, you're still required to handle database engine specific stuff in your code to use more advanced SQL features. ODBC seems to encapsulate all and everything, at the price of being huge. regards, Markus -- Markus Hoenicka [EMAIL PROTECTED] (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqlite db portability
Markus Hoenicka wrote: Quoting Uma Krishnan <[EMAIL PROTECTED]>: Hello Markus, How is libdbi different from, say odbc? I've never used ODBC, but from what I read I'd say the main differences are the footprint and the scope. libdbi is language-specific (C), lightweight, and allows you to do simple things in a simple fashion. However, you're still required to handle database engine specific stuff in your code to use more advanced SQL features. ODBC seems to encapsulate all and everything, at the price of being huge. regards, Markus ODBC is a proprietary name for the ANSI Standard SQL/CLI, the computer language interface to SQL. Other computer language interfaces to SQL databases are less cumbersome having not been designed by a standards committee. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqlite db portability
Quoting Uma Krishnan <[EMAIL PROTECTED]>: Hello Markus, How is libdbi different from, say odbc? I've never used ODBC, but from what I read I'd say the main differences are the footprint and the scope. libdbi is language-specific (C), lightweight, and allows you to do simple things in a simple fashion. However, you're still required to handle database engine specific stuff in your code to use more advanced SQL features. ODBC seems to encapsulate all and everything, at the price of being huge. regards, Markus -- Markus Hoenicka [EMAIL PROTECTED] (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqlite db portability
Hi Shilpa, On 8/28/07, Shilpa Sheoran <[EMAIL PROTECTED]> wrote: > Eg. I create sqlite db file say "mysqlitedb.db" and now I have MySQL > installed. Can it access "mysqlitedb.db" IIRC, I did read about "Linked Servers" in MS-SQL-Server documentation where, if your SQL Server is being used in an NT domain setting then you can create "Linked Servers" - which means that you can "link-in" different databases having ADO wrappers. MS-Access is NOT a database server but I think I did read that you could link in MS-Access databases to your SQL Server process. Though I am NOT sure but I think someone did mention ADO wrappers pertaining to Sqlite and I would suggest that you give that a shot. -- Best, Asif - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqlite db portability
Shilpa Sheoran wrote: I meant the db file. Eg. I create sqlite db file say "mysqlitedb.db" and now I have MySQL installed. Can it access "mysqlitedb.db" /me blinks Um... no. To the best of my knowledge, MySQL cannot read a sqlite database file. Nor can sqlite read a MySQL database file. They are two completely different and incompatible products. -- Glenn McAllister <[EMAIL PROTECTED]> +1 416 348 1594 SOMA Networks, Inc. http://www.somanetworks.com/ +1 416 977 1414 Asking a writer what he thinks about criticism is like asking a lamppost what it feels about dogs. - John Osborne - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqlite db portability
I meant the db file. Eg. I create sqlite db file say "mysqlitedb.db" and now I have MySQL installed. Can it access "mysqlitedb.db" On 8/27/07, Markus Hoenicka <[EMAIL PROTECTED]> wrote: > Shilpa Sheoran writes: > > Can the sqlite db file be accessed using another DB api's eg. MySQL > > or anyother. > > > > Not directly, but you can use a database abstraction layer like libdbi > (http://libdbi.sourceforge.net) for C or the DBI/DBD stuff for > Perl. Your program uses the abstraction layer's API instead of the > database-specific API. > > regards, > Markus > > -- > Markus Hoenicka > [EMAIL PROTECTED] > (Spam-protected email: replace the quadrupeds with "mhoenicka") > http://www.mhoenicka.de > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqlite db portability
Hello Markus, How is libdbi different from, say odbc? Thanks in advance Uma Markus Hoenicka <[EMAIL PROTECTED]> wrote: Shilpa Sheoran writes: > Can the sqlite db file be accessed using another DB api's eg. MySQL > or anyother. > Not directly, but you can use a database abstraction layer like libdbi (http://libdbi.sourceforge.net) for C or the DBI/DBD stuff for Perl. Your program uses the abstraction layer's API instead of the database-specific API. regards, Markus -- Markus Hoenicka [EMAIL PROTECTED] (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] sqlite db portability
Shilpa Sheoran writes: > Can the sqlite db file be accessed using another DB api's eg. MySQL > or anyother. > Not directly, but you can use a database abstraction layer like libdbi (http://libdbi.sourceforge.net) for C or the DBI/DBD stuff for Perl. Your program uses the abstraction layer's API instead of the database-specific API. regards, Markus -- Markus Hoenicka [EMAIL PROTECTED] (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] sqlite db portability
Can the sqlite db file be accessed using another DB api's eg. MySQL or anyother. Thanks. - To unsubscribe, send email to [EMAIL PROTECTED] -