[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. -

[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 conc

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(). W

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

[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

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

[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

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

Re: [sqlite] Conflict with SQLite ODBC Driver and MS Office 2007 ?

e 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 SQLi

[sqlite] Conflict with SQLite ODBC Driver and MS Office 2007 ?

. 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

[sqlite] Free the text (SQLite ODBC driver 0.79 & ADO 2.8 problem)

). 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

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

[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 I

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

[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

[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

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

RE: [sqlite] ANN: SQLite ODBC Driver 0.73

ian 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

[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

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

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 f

[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

[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

AW: [sqlite] [ANN] SQLite ODBC driver version 0.67

uftrag 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 SQL

[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

[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] 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

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

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

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

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

[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

[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

[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]