On Sat, 06 Nov 2010 15:36:46 +1100, Len(c-sharplizards)
l...@c-sharplizards.com 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
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
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
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
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
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
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
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
. 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
).
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
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
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
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
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
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
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
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
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
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
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
--- 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
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]
-
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
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
[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
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
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免费邮箱百分百防垃圾信
雅虎助手-搜索、杀毒、防骚扰
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
-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
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
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
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
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
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
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
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
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]
37 matches
Mail list logo