[sqlite] Sqlite ODBC Query

[Manasi Deshpande]

Hello All,


1. RetCode = SQLExecDirect(hStmt, (SQLTCHAR*)query.c_str(), SQL_NTS);

2. When success RetCode = SQLFetch(hStmt);

3. if (SQL_SUCCEEDED(RetCode))

{

While(SQLDescribeCol)

{

Switch(colDataType)

{

Case SQL_INTEGER:

SQLGetData is called to fetch the data from stmt handle

}

}

}



SQLGetData returns invalid handle in case of SQLite DB where as it works fine 
for other Databases!



Need help!


Regards,
Manasi
--
This email and any attachments are confidential and are for the use of the
addressee only. If you are not the addressee, you must not use or disclose the
contents to any other person. Please immediately notify the sender and
delete the email. Statements and opinions expressed here may not
represent those of the company. Email correspondence is monitored by
the company. This information may be subject to export control
regulation. You are obliged to comply with such regulations.

Renishaw plc (company number 1106260) and Wotton Travel Limited (company
number 01973158) are companies registered in England and Wales with a 
registered office
at New Mills, Wotton-under-Edge, Gloucestershire, GL12 8JR,
United Kingdom, Telephone +44 1453 524524.
--

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

[sqlite] SQLite & ODBC or DDE

[The Tango Club]

Dear SQLite Users,

I am considering purchasing an application written in SQLite. Can anyone 
advise me if I can use ODBC or DDE with the database?

Many Thanks

Liz
-- 
w TheTangoClub.com
e [EMAIL PROTECTED] 
_
t +44 20 7701 9647
~~~
*LINKS * | The Tango Club  | 
Strictly Tango Courses 
 
| A4 Calendar (pdf) 
 
| A3 Calendar (pdf) 
 
| 2008 Programme (pdf) 
 | 
Remove me  
from the email list | Add me 
 to 
the email list
~~~
*THURSDAYS - click here for details 

*19:00 - 21:00 *Continuing Tango -* a class for all levels especially 
recent beginners & elementary (but there's something here for everyone 
except absolute beginners), this is based on principles, technique and 
developing the partnership £10 for members, £12 for non-members 
(includes practica) followed by...
21:00 - 22:30 *Practica -* for everyone, £5 for members £6 for non-members
*FRIDAYS - click here for details
* 19:45 - 20:15 *Warm Up with Nefra*, body awareness, movement and 
co-ordination before dancing, £5
20:30 - 22:00 *Adelante *- dancer-led class improving critical 
awareness at level 4+ (intermediate 1) £10 for members, £12 for 
non-members (includes the milonga)
22:00 - 01:30 *Midnight Milonga* - at The Tango Club , £8 for members, 
£10 for non-members, £6 for voyeurs 
* TANGO TEA - _click here for details 
_
*15:00 - 18:00 the first Saturday of every month, avoid the shopping 
come to dance tango & eat cakes. Bring your shoes and and sense of fun. 
£5 for members £6 for non-members

* SATURDAYS*
*Strictly Tango Courses *starting 15th June, 16th August, 15th November 
- * click here for details 
*
* Beginners - a course of 3 Saturdays, 2 hours each to introduce you to 
Tango
* Recent Beginners - a course of 3 Saturdays, 2 hours each to continue 
your tango
*Study Afternoons* - 3 hours of intensive study on on aspect of tango - 
* click here for details 
*
* Sacadas I, July 12th
* Boleos II, 13th September
* Sacadas II, 8th November

*LOS OCAMPO in LONDON
Improving Fluency*, Friday 4th July 20:30 - 22:30, followed by Summer Party
*Turns with Barridas*, Saturday 19th July 11:30 - 13:30
*Vals II*, Saturday 19th July 14:30 - 17:30
also available for private lessons

* Practice & Rehearsal space available Fridays & Saturdays - call to 
book.* Members receive a discount. The studios are suitable for private 
lessons, practice, rehearsal - dance or music, meetings etc. Kitchen 
facilities and disabled access are also available.

/At// /- 8 Hop Gardens, off St Martin's Lane (beside St Martin's Hotel & 
opposite Freed's). Map here 

/Tube/ - Leicester Square, Charing Cross, Covent Garden,
/BR/ - Waterloo
/Buses/ - Trafalgar Square
/Parking/ - usual restrictions (including Saturday day time), single 
yellows OK after 18:30 but not resident's. try: King William IV Street, 
Agar Street, Chandos Place; also Adam Street, John Adam Street just off 
The Strand; or Craven Street, Northumberland Avenue; Waterloo Bridge or 
High Holborn - what's a 5 minute walk if you are going to dance for 2 hours?
~~
Please Note: We use spam and virus protection, if you have emailed and 
not had a reply there is a small chance that it has not got through. 
Please let us know if this happens (by telephone).

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite ODBC?

[Mark Wyszomierski]

Hi,

Are there are ODBC drivers out there for sqlite on win32? I'm already
using an ODBC library and wanted to see if I could get around
rewriting everything using the native sqlite API.

Thanks,
Mark

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] sqlite, odbc, any gotchas?

[Jay Sprenkle]

On 2/21/06, Jose Da Silva <[EMAIL PROTECTED]> wrote:
> On February 21, 2006 12:48 pm, Jay Sprenkle wrote:
> > Sqlite has been very fast for me. If you need raw blazing
>
> Well, sqlite is definitely fast in relation to other sqls, but every sql
> has overhead, and they all can't match direct access of a
> flattish-file-format by a computer doing it's own work of accessing the
> files directly (assuming smallish small-company files at this point,
> versus large user-base files).
>
> > speed Access and ODBC are not the way to go.
>
> True, but still have to deal with convincing and converting users who
> get fed their information via slick-glossy magazines, so at this point,
> there is still the stigma to overcome and the user-base needs to be
> introduced to alternatives slowly.

LOL! I have certainly seen that!  That and the FUD people spread about
and some people manufacture on their own!

> The odbc allows my options to remain open as to how to implement the
> webstuff, and possibly other alternatives of access. The alternative
> was accessing DBF files directly from the server, therfore allowing me
> to also read DBF files via linux and eventually the webserver stuff.
>
> Your suggestion about database corruption is a definite drop of DBF and
> committing with odbc.  Thanks

Good luck!

Re: [sqlite] sqlite, odbc, any gotchas?

[Jose Da Silva]

On February 21, 2006 12:48 pm, Jay Sprenkle wrote:
> Sqlite has been very fast for me. If you need raw blazing

Well, sqlite is definitely fast in relation to other sqls, but every sql 
has overhead, and they all can't match direct access of a 
flattish-file-format by a computer doing it's own work of accessing the 
files directly (assuming smallish small-company files at this point, 
versus large user-base files).

> speed Access and ODBC are not the way to go.

True, but still have to deal with convincing and converting users who 
get fed their information via slick-glossy magazines, so at this point, 
there is still the stigma to overcome and the user-base needs to be 
introduced to alternatives slowly.
The odbc allows my options to remain open as to how to implement the 
webstuff, and possibly other alternatives of access. The alternative 
was accessing DBF files directly from the server, therfore allowing me 
to also read DBF files via linux and eventually the webserver stuff.

Your suggestion about database corruption is a definite drop of DBF and 
committing with odbc.  Thanks

Re: [sqlite] sqlite, odbc, any gotchas?

[Jay Sprenkle]

On 2/21/06, Jose Da Silva <[EMAIL PROTECTED]> wrote:
> I was a bit hesitant about using sqlite when I read elsewhere that a sql
> type database is about 15x slower than direct access.
> However, since this will eventually be multiuser, the
> access-trashing-aspect is definitely something I want to avoid.  :-)
> Thanks, that's a good suggestion.

Sqlite has been very fast for me. If you need raw blazing
speed Access and ODBC are not the way to go.

If you do have problems with speed getting the query and the schema
correct can make the difference betweens many minute response
times and sub second response times.

Good luck!

Re: [sqlite] sqlite, odbc, any gotchas?

[Jose Da Silva]

I was a bit hesitant about using sqlite when I read elsewhere that a sql 
type database is about 15x slower than direct access.
However, since this will eventually be multiuser, the 
access-trashing-aspect is definitely something I want to avoid.  :-)
Thanks, that's a good suggestion.

If anyone is interested in compiling the latest sqliteodbc (0.65), I've 
got a modified configure file to replace the 0.65 sqliteodbc configure 
file located at:  http://www.joescat.com/configure.tar.gz
(sorry, no webpage setup due to lack of time)  :-(

The modified configure file defaults to use sqlite3 versus sqlite2 
headers and information, and you don't have-to-have sqlite2 installed 
to get past the configure command, plus you don't need to type options 
on the configure line if your sqlite is located in default file 
locations:

./configure
make
make install

the sqliteodbc authour already has been notified and been given a copy 
now too, so not necessary to send multiple copies his way (since this 
is a mailinglist and I'm sure several people will want to mention 
it).  ;-)


On February 21, 2006 07:15 am, Jay Sprenkle wrote:
> That might be a good way to get some basic tools over the top
> of the database. Access does tend to trash its database files if used
> by multiple users on a network. If you connect to sqlite files via
> odbc they should be ok though. Backup your mdb file to be safe!
>
> On 2/19/06, Jose Da Silva <[EMAIL PROTECTED]> wrote:
> > If read a bit already and see limitations and benefits in SQlite.
> > Our office still wants to use the GUI present in MS-Access.
> > I like the simplicity of maintaining SQLite plus it's rollback
> > features etc.   Later, there are aspirations for a webbrowser
> > interface to same database.
> > Anyone have recommendations or suggestions to this scenario:
> > Windows(MS-Access)<---office network--->(sqliteodbc-sqlite)linux

Re: [sqlite] sqlite, odbc, any gotchas?

[Jay Sprenkle]

That might be a good way to get some basic tools over the top
of the database. Access does tend to trash its database files if used
by multiple users on a network. If you connect to sqlite files via odbc
they should be ok though. Backup your mdb file to be safe!



On 2/19/06, Jose Da Silva <[EMAIL PROTECTED]> wrote:
> If read a bit already and see limitations and benefits in SQlite.
> Our office still wants to use the GUI present in MS-Access.
> I like the simplicity of maintaining SQLite plus it's rollback features
> etc.   Later, there are aspirations for a webbrowser interface to same
> database.
> Anyone have recommendations or suggestions to this scenario:
> Windows(MS-Access)<---office network--->(sqliteodbc-sqlite)linux

[sqlite] sqlite, odbc, any gotchas?

[Jose Da Silva]

If read a bit already and see limitations and benefits in SQlite.
Our office still wants to use the GUI present in MS-Access.
I like the simplicity of maintaining SQLite plus it's rollback features 
etc.   Later, there are aspirations for a webbrowser interface to same 
database.
Anyone have recommendations or suggestions to this scenario:
Windows(MS-Access)<---office network--->(sqliteodbc-sqlite)linux

Thanks

[sqlite] SqLite ODBC driver - AutoIncrement from OpenOffice

[Pierre-Yves Delens]

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]