[sqlite] New SQLite ODBC driver

[Denis Yanov]

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,

[Len(c-sharplizards)]

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

[christian.wer...@t-online.de]

> 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

[Kees Nuyt]

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

[Len(c-sharplizards)]

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

[Guy Hachlili]

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

[Shen Nan]

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 ?

[Mohit Sindhwani]

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 ?

[Shane Harrelson]

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 <jack@gmail.com> 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 ?

[Jack Ort]

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)

[markbrad]

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"

[Mihai Limbasan]

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"

[Abshagen, Martin RD-AS2]

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

[Christian Werner]

"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

[Abshagen, Martin RD-AS2]

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

[Christian Werner]

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

[Christian Werner]

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

[Noah Hart]

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

[Christian Werner]

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

[Joe Wilson]

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

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

[Christian Werner]

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

[Christian Werner]

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

[Christian Werner]

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

[Christian Werner]

[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

[michael.hanssen]

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

[Christian Werner]

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] ODBC driver

[Bielik, Robert]

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, 
, );

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

[Dan Keeley]

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

[Dan Keeley]

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

[Gerry Snyder]

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

[Oliver Bienert]

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

[Dan Keeley]

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?

[Sid Liu]

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?

[Jay]

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

[Christian Werner]

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

[Federico Granata]

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]