SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Connecting to SQLite

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Connecting to SQLite
Author Message
ilcaa72
Guest





Post Connecting to SQLite Reply with quote
using the SQL Editor... I selected 'SqLite' from Database Type, was expecting a browse tool to connect to my SQLite file.... it gave me the option for ODBC connection type

how can i just connect to a sqlLite db file and query the tables?
Mon Aug 02, 2021 6:11 pm
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
There is no browse button, that Database field is generic, can be used for server names or file names depending on the database type. Simply enter the complete SQLite file name into the Database field. You will need to do it once only, it will remember what you entered. If you enter a nonexisting file name, it will create a new database, else open an existing one.

In case you don't have the ODBC driver installed, here is the download link to the most popular version http://www.ch-werner.de/sqliteodbc/sqliteodbc_w64.exe
Mon Aug 02, 2021 10:59 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.