[sqlite] New SQLite ODBC driver
Devart team is proud to introduce new SQLite ODBC Drivers. The most significant features in this version are: - Direct Mode - allows to connect to your databases directly via TCP/IP avoiding DB client software, thus simplifying application deployment process and increasing performance. - Drivers fully support standard ODBC API functions and data types, multiple server data types and features. - Advanced connection string parameters provided to allow any desktop and web applications to access databases from various environments and platforms, that support ODBC. - Full Unicode support provides capacity to interpret Unicode function calls without the intervention of the Driver Manager. - Advanced data conversion from DBMS data types to native ODBC data types. - Support for 32-bit and 64-bit Windows platforms provides capabilities to develop both 32-bit and 64-bit cross-platform database applications. ODBC driver for SQLite supports SQLite versions since 3.0 and higher. More Details Download driver
[sqlite] re SQLite ODBC Driver,
Thanks Kees, Christian, SQLSetConnectAttrW(q->hdbc, SQL_ATTR_AUTOCOMMIT, (SQLPOINTER)SQL_AUTOCOMMIT_OFF, 0); this is what I already had and I think you have answered the question with "The SQLite ODBC driver allows only one SQL statement per SQLExecDirect()", this is the conclusion that I came to. Kees, your suggestion is exactly what I did, tah is a single statement per SQLExecDirect( ... ) SQLExecDirect("INSERT INTO t (col1,col2) VALUES ('val11','val21')"); Thanks to both of you for your quick reply, looks like I will have to accept the way things are, but that's a small price to pay for a very useful database. Regards Len ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] ODBC Driver
> I do not seem to be able to parse a multiple insert statement through > the odbc drive using SQLExecDirect(...) I have tried with BEGIN, COMMIT > TRANSACTION does anyone have any ideas? The SQLite ODBC driver allows only one SQL statement per SQLExecDirect() and SQLPrepare(). When using transactions the right sequence of calls is SQLSetConnectAttr(...SQL_AUTOCOMMIT, SQL_AUTOCOMMIT_OFF), SQLExecDirect() and finally SQLEndTran() to commit or rollback. There's no need to send BEGIN/COMMIT statements through SQLExecDirect() Hope that helps, Christian ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] ODBC Driver
On Sat, 06 Nov 2010 15:36:46 +1100, "Len(c-sharplizards)" wrote: > I do not seem to be able to parse a multiple insert statement through > the odbc drive using SQLExecDirect(...) I have tried with BEGIN, COMMIT > TRANSACTION does anyone have any ideas? You don't give us much to work on. - Which ODBC driver do you use? - What does your "multiple insert statement" look like? - What is the result (error messages, state of the db before and after the statement)? - What do you expect the result to be? For your information, sqlite does not support the form INSERT INTO t (col1,col2) VALUES ('val11','val21'), ('val12','val22'), ('val13','val23'); In general it is a bit challenging to expect that the whole chain supports something like: sql="BEGIN TRANSACTION; INSERT INTO t (col1,col2) VALUES ('val11','val21'); INSERT INTO t (col1,col2) VALUES ('val12','val22'); INSERT INTO t (col1,col2) VALUES ('val13','val23'); COMMIT TRANSACTION;" SQLExecDirect(sql); Better change that to: SQLExecDirect("BEGIN TRANSACTION"); SQLExecDirect("INSERT INTO t (col1,col2) VALUES ('val11','val21')"); SQLExecDirect("INSERT INTO t (col1,col2) VALUES ('val12','val22')"); SQLExecDirect("INSERT INTO t (col1,col2) VALUES ('val13','val23')"); SQLExecDirect("COMMIT TRANSACTION") I hope this helps, if not please take some effort to describe your exact problem. -- ( Kees Nuyt ) c[_] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ODBC Driver
I do not seem to be able to parse a multiple insert statement through the odbc drive using SQLExecDirect(...) I have tried with BEGIN, COMMIT TRANSACTION does anyone have any ideas? Regrards ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite ODBC Driver - relative path
Hello. On 17/03/2010 04:16, Shen Nan wrote: > I used SQLite ODBC Driver to display data in Excel, and everything works > fine. > Except in the connection String, I have to enter an absolute path, which is > very troublesome every time I move the file. > I wonder is there any way to specify relative path instead in the connection > String? You can do two things to (probably) fix this. 1. You can use a symbolic link to the moved database file. Use an absolute path to a location that should never change, and in that location, put a symbolic link to the database file; to create one, try the sysinternal utility here: http://technet.microsoft.com/en-us/sysinternals/bb896768.aspx 2. If you move the database file with the Excel file, you can recreate the ODBC connection string in VBA every time you open the file by parsing the Excel document's path name and replacing the relative part. Guy ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite ODBC Driver - relative path
Hi sqlite users, I used SQLite ODBC Driver to display data in Excel, and everything works fine. Except in the connection String, I have to enter an absolute path, which is very troublesome every time I move the file. I wonder is there any way to specify relative path instead in the connection String? Driver={SQLite3 ODBC Driver};Database=C:\TempFolder\test.db;... I use the ODBC driver from http://www.ch-werner.de/sqliteodbc/. Thank you for your help in advance! Best regards, Nan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Conflict with SQLite ODBC Driver and MS Office 2007 ?
Shane Harrelson wrote: > I know of no conflicts. I regularly test against SQL Server 2005, > MySQL, OracleXE, and SQLite all via ODBC interfaces (specifically > Christian Werner's ODBC interface for SQLite). The various ODBC > interfaces all play happily. > ...and numerous applications include SQLite built in - Firefox is one! Cheers, Mohit. 10/15/2009 | 10:31 PM. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Conflict with SQLite ODBC Driver and MS Office 2007 ?
I know of no conflicts. I regularly test against SQL Server 2005, MySQL, OracleXE, and SQLite all via ODBC interfaces (specifically Christian Werner's ODBC interface for SQLite). The various ODBC interfaces all play happily. HTH -Shane On Wed, Oct 14, 2009 at 4:15 PM, Jack Ort wrote: > Hello! Not sure where to ask this question, so I apologize if this is not > appropriate. I want to use SQLite as the basis for a new project where I > work. I'm new to SQLite - this would be my first use of it beyond some > simple test applications. Plan to use REBOL to develop a GUI frontend. For > reporting, I thought I might use MS Access called by REBOL code to provide > canned reports against the SQLite database. I believe I need to use the > SQLite ODBC driver (http://www.ch-werner.de/sqliteodbc/) for Access to link > to the SQLite db. > > Now my question: my IT Manager is witholding approval of using SQLite > because he thinks he's heard of a conflict between the SQLite ODBC driver > and the SQL Server 2005 "stuff" that gets installed as part of a MS Office > 2007 installation. (Some users have Office 2007 - I have Office 2003 so I > cannot test.) > > I suspect someone meant to refer to a conflict with SQL Server Express > instead of SQLite. I cannot find anything in Google searches. > > Does anyone here know of any conflicts I should be concerned about? This > would be in a XP SP2 environment. > > Thanks in advance! > -Jack > ___ > 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] Conflict with SQLite ODBC Driver and MS Office 2007 ?
Hello! Not sure where to ask this question, so I apologize if this is not appropriate. I want to use SQLite as the basis for a new project where I work. I'm new to SQLite - this would be my first use of it beyond some simple test applications. Plan to use REBOL to develop a GUI frontend. For reporting, I thought I might use MS Access called by REBOL code to provide canned reports against the SQLite database. I believe I need to use the SQLite ODBC driver (http://www.ch-werner.de/sqliteodbc/) for Access to link to the SQLite db. Now my question: my IT Manager is witholding approval of using SQLite because he thinks he's heard of a conflict between the SQLite ODBC driver and the SQL Server 2005 "stuff" that gets installed as part of a MS Office 2007 installation. (Some users have Office 2007 - I have Office 2003 so I cannot test.) I suspect someone meant to refer to a conflict with SQL Server Express instead of SQLite. I cannot find anything in Google searches. Does anyone here know of any conflicts I should be concerned about? This would be in a XP SP2 environment. Thanks in advance! -Jack ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Free the text (SQLite ODBC driver 0.79 & ADO 2.8 problem)
So I’m in the process of liberating my GIS data on a shoestring budget with the SQLite / SpatiaLite combo, all test connections to my database (through Christian Werner’s ODBC driver) are going great, but then I run into major difficulties returning ADODB RecordSet’s in ArcMap VBA on any Text field whatsoever (Integer fields are ok). The instant I include Text columns in the Select statement field list or Where clause, I end up with a falsely empty recordset (it even chokes on SELECT *...). Getting data into the db with Connection.Excute is no problem (DSN or Driver based connections). Reading data via linked tables or pass-through queries in MS Access is no problem. I’ve tried various versions of ADO (currently on 2.8) and the SQLite ODBC driver (currently on 0.79). I've tried all manor of cursor and lock types. The SpatiaLite library extension has been turned off, still the problem persists. This is where I say, "What in the what what?". Any insights are very welcome. Please be kind, as I'm quite green. I'm running XP sp2. I've cross posted this with the SpatiaLite Users Google Group at (if you care to see the info from that thread): http://groups.google.com/group/spatialite-users/browse_thread/thread/18358e0344097b8a On a related note (at least in my mind); has dhSQLite been compiled to allow the loading of dll extensions (like SpatiaLite)? Thanks for any assistance you all can provide. -- View this message in context: http://www.nabble.com/Free-the-text-%28SQLite-ODBC-driver-0.79---ADO-2.8-problem%29-tp19870745p19870745.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] ODBC driver for C error "only one SQL statement allowed"
Abshagen, Martin RD-AS2 wrote: Hi, sqlite-users, am evaluating Sqlite ODBC driver for C (current sqliteodbc.exe by Ch. Werner, http://www.ch-werner.de/sqliteodbc/). After defining successfully two tables "mytable" and "mysequence", I tried to define a trigger by means of "CREATE TRIGGER trg BEFORE INSERT ON mytable FOR EACH ROW BEGIN INSERT INTO mysequence VALUES(0); END" This worked fine with sqlite3.c, when passed to sqlite3_exec(), but gave rise to an error message with sqlite3odbc.c , when passed to SQLExecDirect(). The message was : "only one SQL statement allowed". Is there a special SQL syntax required for sqlite3odbc? Are there any (further) restrictions for triggers? Or is it a bug? Best regards Martin Abshagen ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users It's clearly a bug / limitation in the ODBC wrapper - it obviously parses the SQL you're passing it and doesn't understand trigger syntax, thus bailing out. You might want to contact the developer and ask whether there are plans to update the wrapper. -- Multumesc, Mihai Limbasan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ODBC driver for C error "only one SQL statement allowed"
Hi, sqlite-users, am evaluating Sqlite ODBC driver for C (current sqliteodbc.exe by Ch. Werner, http://www.ch-werner.de/sqliteodbc/). After defining successfully two tables "mytable" and "mysequence", I tried to define a trigger by means of "CREATE TRIGGER trg BEFORE INSERT ON mytable FOR EACH ROW BEGIN INSERT INTO mysequence VALUES(0); END" This worked fine with sqlite3.c, when passed to sqlite3_exec(), but gave rise to an error message with sqlite3odbc.c , when passed to SQLExecDirect(). The message was : "only one SQL statement allowed". Is there a special SQL syntax required for sqlite3odbc? Are there any (further) restrictions for triggers? Or is it a bug? Best regards Martin Abshagen ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] ODBC driver C source file includes a header which was notshipped
"Abshagen, Martin RD-AS2" wrote: > > Hi, > > am trying to use the Sqlite3 ODBC driver for C, provided by Christian Werner > (http://www.ch-werner.de/sqliteodbc/, product sqliteodbc-0.77-1.src.rpm). > If _WIN32 is defined, sqlite3odbc.c includes a "resource3.h" header file, > which is not shipped with the version. How could I work around or find > "resource3.h"? The resource3.h file is generated from resource.h.in, see the Makefile.mingw-cross for the sed command line. See also the mingw-cross-build.sh script on how the drivers and SQLite are built. HTH, Christian ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ODBC driver C source file includes a header which was not shipped
Hi, am trying to use the Sqlite3 ODBC driver for C, provided by Christian Werner (http://www.ch-werner.de/sqliteodbc/, product sqliteodbc-0.77-1.src.rpm). If _WIN32 is defined, sqlite3odbc.c includes a "resource3.h" header file, which is not shipped with the version. How could I work around or find "resource3.h"? Best regards Martin Abshagen ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite ODBC driver version 0.77 released
Dear all, version 0.77 of the SQLite ODBC driver is available for download from http://www.ch-werner.de/sqliteodbc It's Windows one-click installer is built with SQLite 3.5.4 and 2.8.17. There were two major bug fixes with respect to wide-char parameter binding and wide-char data retrieval, thus an update is suggested. Happy new year, Christian - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] ANN: SQLite ODBC Driver 0.73
Noah Hart wrote: > > Hello Christian, > > I tried your odbc driver, and it works pretty well, but does not handle > Unicode at all. > > I have a "dictionary" application with two columns, first being English, > second being Punjab (stored in Unicode) > For example, simple table with > EN_WORD PJ_WORD > === === > Punjabi ਪੰ�ਾਬ� > > If I link a sqlite3 table via access and run a query to insert into the > table, I get gibberish in the sqlite3 database. > > Did you support Unicode in your odbc driver? Noah, IMO the SQLite3 driver starting with version 0.71 (as well as the SQLite3 UTF-8 driver) does support UNICODE. There could be some olden Accesses which don't use the SQLWCHAR ODBC APIs. Did you try that simple table with OpenOffice 2.0.* Base with UTF-8 as Base's encoding ? Regards, Christian - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] ANN: SQLite ODBC Driver 0.73
Hello Christian, I tried your odbc driver, and it works pretty well, but does not handle Unicode at all. I have a "dictionary" application with two columns, first being English, second being Punjab (stored in Unicode) For example, simple table with EN_WORD PJ_WORD === === Punjabi ਪੰਜਾਬੀ If I link a sqlite3 table via access and run a query to insert into the table, I get gibberish in the sqlite3 database. Did you support Unicode in your odbc driver? Thanks, Noah Hart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christian Werner Sent: Sunday, February 18, 2007 11:28 AM To: sqlite-users@sqlite.org Subject: [sqlite] ANN: SQLite ODBC Driver 0.73 Hi all, release 0.73 of the SQLite ODBC driver is available for download from http://www.ch-werner.de/sqliteodbc >From the change log: * update to SQLite 3.3.13 * SQLGetInfo(SQL_OWNER_TERM) now is empty string * fixed bug in Win32 version concerning SQLDriverConnect() * added -L/-l/-I/-i switches to sqlite+tcc.c Cheers, Christian - To unsubscribe, send email to [EMAIL PROTECTED] - CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] ANN: SQLite ODBC Driver 0.73
Hi all, release 0.73 of the SQLite ODBC driver is available for download from http://www.ch-werner.de/sqliteodbc >From the change log: * update to SQLite 3.3.13 * SQLGetInfo(SQL_OWNER_TERM) now is empty string * fixed bug in Win32 version concerning SQLDriverConnect() * added -L/-l/-I/-i switches to sqlite+tcc.c Cheers, Christian - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] ANN: SQLite ODBC driver 0.71
--- Christian Werner <[EMAIL PROTECTED]> wrote: > Joe Wilson wrote: > > > > Hi Christian, > > > > Does your ODBC driver allow for SQLite loadable modules out of the box? > > If so, how do you specify the names of the module DLLs? > > No, the extension loading is not supported yet, although compiled into > the Win32 driver DLLs. But it might be possible to create a SQLite > function in the SQLite3 driver, which would allow you to write > > SQLExecDirect(stmt, "select load_extension('my.dll')", SQL_NTS); > > but wouldn't this land us on the shores of hell allowing a new class > of SQL injection ? I'm not suggesting something like that. Nevermind the SQL-injection attack thing, it is not practical to have a user to run a SELECT statement before they can use their database. (My Excel SQLite business users would never be able to understand that). For sqlite extension modules to be useful with minimal effort on the part of the end-user it should be specified in the ODBC connection string. i.e.: DSN=SQLite3 Datasource;Database=my.db;Modules=module1,module2;... Everyone would know up front what module(s) they would wish to load for a given ODBC sqlite datasource anyway. Alternatively, you could put the module name(s) in an .ini file or in a "special" table within a given sqlite3 database itself. If this latter approach is chosen it has the power to have database-specific modules loaded. Yahoo! Music Unlimited Access over 1 million songs. http://music.yahoo.com/unlimited - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] ANN: SQLite ODBC driver 0.71
Joe Wilson wrote: > > Hi Christian, > > Does your ODBC driver allow for SQLite loadable modules out of the box? > If so, how do you specify the names of the module DLLs? No, the extension loading is not supported yet, although compiled into the Win32 driver DLLs. But it might be possible to create a SQLite function in the SQLite3 driver, which would allow you to write SQLExecDirect(stmt, "select load_extension('my.dll')", SQL_NTS); but wouldn't this land us on the shores of hell allowing a new class of SQL injection ? - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] ANN: SQLite ODBC driver 0.71
Hi Christian, Does your ODBC driver allow for SQLite loadable modules out of the box? If so, how do you specify the names of the module DLLs? thanks. --- Christian Werner <[EMAIL PROTECTED]> wrote: > Howdy! > > Release 0.71 of the SQLite ODBC driver is ready for download from > > http://www.ch-werner.de/sqliteodbc (Main page) > http://www.ch-werner.de/sqliteodbc/sqliteodbc.exe (Win32 Installer) > http://www.ch-werner.de/sqliteodbc/sqliteodbc-0.71.tar.gz (Sources) > > The most important changes are: > > - improved support for pathnames with non-ASCII chars on Win32 > - SQLite3 driver now provides wide-char APIs on Win32 > - improved thread safety on Win32 > - Win32 installer contains drivers built against >SQLite 2.8.17 and 3.3.10 __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] ANN: SQLite ODBC driver 0.71
Howdy! Release 0.71 of the SQLite ODBC driver is ready for download from http://www.ch-werner.de/sqliteodbc (Main page) http://www.ch-werner.de/sqliteodbc/sqliteodbc.exe (Win32 Installer) http://www.ch-werner.de/sqliteodbc/sqliteodbc-0.71.tar.gz (Sources) The most important changes are: - improved support for pathnames with non-ASCII chars on Win32 - SQLite3 driver now provides wide-char APIs on Win32 - improved thread safety on Win32 - Win32 installer contains drivers built against SQLite 2.8.17 and 3.3.10 Best Regards, Christian - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] [ANN] SQLite ODBC driver version 0.70
Version 0.70 of the SQLite ODBC driver is ready for download from http://www.ch-werner.de/sqliteodbc The Win32 installer now is made with SQLite 3.3.7. Enjoy, Christian - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] [ANN] SQLite ODBC driver version 0.68
Version 0.68 of the SQLite ODBC driver is ready for download from http://www.ch-werner.de/sqliteodbc It fixes some more bugs mainly in the SQLite 3.x version of the driver. Enjoy, Christian
Re: AW: [sqlite] [ANN] SQLite ODBC driver version 0.67
[EMAIL PROTECTED] wrote: > > Hi, > > I just would like to point out that: > > - a zip-archive for the drivers ("no-install") is not provided That was my intention; is the ZIP version really necessary ? > - the documentation for sqliteodbc.c / sqliteodbc.h is missing Ditto, since SQLite 2.* is legacy. The doxygen stuff had a lot of warnings when formatting both SQLite2 and SQLite3 driver sources, therefore I left the legacy one out. If there's really interest in browsable source code for the SQLite2 driver, I'll try to fix it. Regards, Christian
AW: [sqlite] [ANN] SQLite ODBC driver version 0.67
Hi, I just would like to point out that: - a zip-archive for the drivers ("no-install") is not provided - the documentation for sqliteodbc.c / sqliteodbc.h is missing Regards, Michael -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Christian Werner Gesendet: Montag, 3. April 2006 18:19 An: sqlite-users@sqlite.org Betreff: [sqlite] [ANN] SQLite ODBC driver version 0.67 Version 0.67 of the SQLite ODBC driver is ready for download from http://www.ch-werner.de/sqliteodbc It fixes some Unicode length issues with the SQLite 2.8.17 version of the driver and now fully supports binary data. The Win32 version is now made with a MinGW cross compiler and NSIS. Enjoy, Christian
[sqlite] [ANN] SQLite ODBC driver version 0.67
Version 0.67 of the SQLite ODBC driver is ready for download from http://www.ch-werner.de/sqliteodbc It fixes some Unicode length issues with the SQLite 2.8.17 version of the driver and now fully supports binary data. The Win32 version is now made with a MinGW cross compiler and NSIS. Enjoy, Christian
[sqlite] Do I have to install sqlite odbc driver if I want to use ASP to connect SQLite?
Hi,all Do I have to install sqlite odbc driver if I want to use ASP to connect SQLite? If there are any available samples ,could you give me some? Thank you so much! - 雅虎1G免费邮箱百分百防垃圾信 雅虎助手-搜索、杀毒、防骚扰
[sqlite] ANN: SQLite ODBC Driver
Version 0.66 of the SQLite ODBC Driver is available on http://www.ch-werner.de/sqliteodbc It supports now SQLite 3.3.4 and 2.8.17. Cheers, Christian
[sqlite] ODBC driver
Hi, I've been trying to modify the ODBC driver (http://www.ch-werner.de/sqliteodbc/) to be able to work with BLOBs. The current 0.65 ODBC driver can only handle CLOBs (i.e. null terminated strings) inspite of it being built on sqlite3 . I've managed to get BLOB writing to work by using sqlite3_bind_blob(...) at write time. This is a bit problematic though as it requires the entire BLOB to be available at binding time. Lets say a 10MB file is to be stored in the database, usual procedure would be to divide it up in chunks and do SQLPutData on each chunk. With the current SQLite API that is not possible. I'd propose an added API called sqlite3_bind_chunk(...) that has the same function prototype (as _bind_blob) but with the added function that calling sqlite3_step() returns SQLITE_OK until the data size parameter to sqlite3_bind_chunk(...) is zero, like: sqlite3_prepare(db, "INSERT INTO T_TABLE (DATA) VALUES(?) WHERE ID=42", -1, &stmt, &szTail); while (true) { int chunkLength = min(dataLength, CHUNK_LENGTH); sqlite3_bind_chunk(stmt, 0, dataPtr, chunkLength, SQLITE_TRANSIENT); dataLength -= chunkLength; rc = sqlite3_step(); if (rc == SQLITE_DONE) { break; } } I.e. bind the blob in several consecutive chunks instead of one. Make sense? Or is it RTFM?? ;) However, getting the data back is a bit problematic as the SQLite statement scope is only within SQLExecute. When SQLGetData is called, there no longer is a statement to use for sqlite3_column_blob(...). The 0.65 driver solves this by copying the rowset as returned in SQLExecute (by sqlite3_get_table) into a char** structure which is then used in SQLGetData to pass data on to the calling application. However, I'd prefer not to have this behavior as it means more data copy than needed. I'll try not to sqlite3_finalize the statement until SQLFreeStmt is called (from the application), so that the actual data pointers are available in SQLGetData during BLOB fetch. Does anybody see any hazard in doing this? /Rob
Re: [sqlite] ODBC Driver
The page that gives the (very impressive) list of drivers and wrappers for SQLite is: http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers The specific one you want is: http://www.ch-werner.de/sqliteodbc/ Excellent thanks! Rgds, Dan
Re: [sqlite] ODBC Driver
Ah, I should have made it clear _why_ i need an odbc driver. I'm using some commercial reporting and application generation tools to connect to it - They dont support sqlite natively, so I must use odbc. So which one should I use? Thanks! Dan From: Oliver Bienert <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [sqlite] ODBC Driver Date: Thu, 23 Dec 2004 00:15:46 +0100 Dan Keeley wrote: Hi, I've finally got round to building sqlite. Now i'm after the odbc driver for it. Only thing is I can't seem to find the page on the sqlite website that lists other programs, such as an odbc driver for use with sqlite? Is there a recommended odbc driver to use? You do not need an ODBC Driver in order to use a sqlite database. You can directly talk to database via API. Regards Oliver
Re: [sqlite] ODBC Driver
Dan Keeley wrote: Hi, I've finally got round to building sqlite. Now i'm after the odbc driver for it. Only thing is I can't seem to find the page on the sqlite website that lists other programs, such as an odbc driver for use with sqlite? Is there a recommended odbc driver to use? Dan, The page that gives the (very impressive) list of drivers and wrappers for SQLite is: http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers The specific one you want is: http://www.ch-werner.de/sqliteodbc/ I hope you will enjoy working with SQLite as much as I have. Gerry
Re: [sqlite] ODBC Driver
Dan Keeley wrote: Hi, I've finally got round to building sqlite. Now i'm after the odbc driver for it. Only thing is I can't seem to find the page on the sqlite website that lists other programs, such as an odbc driver for use with sqlite? Is there a recommended odbc driver to use? You do not need an ODBC Driver in order to use a sqlite database. You can directly talk to database via API. Regards Oliver
[sqlite] ODBC Driver
Hi, I've finally got round to building sqlite. Now i'm after the odbc driver for it. Only thing is I can't seem to find the page on the sqlite website that lists other programs, such as an odbc driver for use with sqlite? Is there a recommended odbc driver to use? Rgds, Dan
Re: [sqlite] ODBC driver?
Here: http://www.ch-werner.de/sqliteodbc/ --- Jay <[EMAIL PROTECTED]> wrote: > Good morning all, > > Is there an odbc driver for Sqlite3? > It would be useful to be able to use existing data > tools... > > = > > - > > The Castles of Dereth Calendar: a tour of that art > and architecture of the online game world of > Asheron's Call > http://www.lulu.com/content/77264 > > > > __ > Do you Yahoo!? > Yahoo! Mail - 250MB free storage. Do more. Manage > less. > http://info.mail.yahoo.com/mail_250 > __ Do you Yahoo!? Dress up your holiday email, Hollywood style. Learn more. http://celebrity.mail.yahoo.com
[sqlite] ODBC driver?
Good morning all, Is there an odbc driver for Sqlite3? It would be useful to be able to use existing data tools... = - The Castles of Dereth Calendar: a tour of that art and architecture of the online game world of Asheron's Call http://www.lulu.com/content/77264 __ Do you Yahoo!? Yahoo! Mail - 250MB free storage. Do more. Manage less. http://info.mail.yahoo.com/mail_250
[sqlite] ANN: SQLite ODBC Driver 0.65
Hi all, a new version of the SQLite ODBC Driver is available on http://www.ch-werner.de/sqliteodbc An unoptimized driver version supporting SQLite 3.0.7 is included. Best regards, Christian
[sqlite] ODBC Driver
Hi, I try to find a ODBC driver to use on linux with OOo. Can you help me ? P.S. Sorry for my english. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] SqLite ODBC driver - AutoIncrement from OpenOffice
Bonjour, I'm testing the Driver - quite successfully I must say - on Win2000. What I'm failing to do is to create a record with an autoIncremental Primary Key from OpenOffice (Datasource view or Writer form). The frustrating thing is that from MS Access (2000), it is working properly, just with the 'INTEGER PRIMARY KEY' autoincremental type of SqLite. Actually, the record is well sent to the source DB, as I can check afterwards from DbManager. This is OK for typing ONE record at a time. Problem is that, in OpenOffice app, trying to commit the record (I mean : leave the record for going to new/next record) leaves the visible row with the PKey BLANK, and an Odbc Error MSG is issued : '[Microsoft][ODBC Driver MAnager]Invalid cursor state - SQL status : 24000'. I tried to type explicitely 'NULL' in the field, but this is immediately converted to 0, which happens to be NOT unique. QUESTIONS : 1. Is there a limitation in the ODBC Driver features I shoud know about (triggering, probably) ? 2.What sould I do ? 2.1. At OpenOffice level, I must admit that some options in ODBC settings for the concerned datasource are unclear to me (despite looking into the doc, which is silent on this issue) : In Dialog 'Datasource Administration'/Tab 'ODBC', we find a checkbox 'Retrieve generated values', offering 2 more textboxes : - Auto-increment statement - Query of generated values Is there something helping there ? Compatible with the typed field 'INTEGER PRIMARY KEY', or to be used with a 'NUMERIC PRIMARY KEY' 2.2. At SqLite level Can I do something at Table definition level ? Can I make use of the typed field 'INTEGER PRIMARY KEY', or should I abandon this possibility ? 3. Are there other people somewhere working on OpenOffice + SqLite Thanks on forward ___ P-Y Delens, Manager LIENTERFACES - PY Delens, sprl Avenue Dolez, 243 - 1180 Bruxelles phone : 32 2 375 55 62 fax : 32 2 374 75 74 mail : [EMAIL PROTECTED] web : www.lienterfaces.be ___ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]