Showing posts with label ODBC Drivers. Show all posts
Showing posts with label ODBC Drivers. Show all posts

Friday, April 27, 2018

Are there ODBC drivers for SQLite databases?

Yes. There are ODBC drivers.

Please go to this site  to download your ODBC driver for SQLite.

The current version are as described in my previous post. Download the one appropriate for you use:

LiteODBC_00

I downloaded the one shown here,


LiteODBC_0

You double click the executable show above to begin the installation.

Follow the wizard. Here are some screens shown for your guidance.


LiteODBC_1



LiteODBC_2

I chose the default folder.


LiteODBC_3


LiteODBC_4
As you may know Windows OS has two ODBC Data Source (x32) and (x64). You can verify that you find the driver in the (x64) version as shown here:


LiteODBC_5

Now you start using SQLite.

In the Install directory (in my case: C:\Program Files\SQLite ODBC Driver for Win64), you can find the ODBC Drivers for two versions,
SQLite 2.8.17 
 SQLite 3.22.0 .

Tuesday, April 17, 2018

Are there ODBC drivers available for SQLite?

ODBC drivers are indeed available for SQLite databases. You can download the version you want from this link here. The driver has been tested with the following SQLite versions:

SQLite 2.8.17 
SQLite 3.22.0
Windows NT/2000 in MS Excel 97 (MSQUERY)

The author (Chris Wolf) of the driver has wrapped the SQLite C library into a ODBC driver.

These current versions may be of interes to you:

Current version
sqliteodbc.exe [http://www.ch-werner.de/sqliteodbc/sqliteodbc.exe]
sqliteodbc_w64.exe [http://www.ch-werner.de/sqliteodbc/sqliteodbc_w64.exe]
sqliteodbc-0.9996.tar.gz [http://www.ch-werner.de/sqliteodbc/sqliteodbc-0.9996.tar.gz]
sqliteodbc-0.9996-1.src.rpm [http://www.ch-werner.de/sqliteodbc/sqliteodbc-0.9996-1.src.rpm]

Tuesday, February 24, 2015

How can I connect to an Microsoft EXCEL file on my Windows 8.1 laptop?

If you have Office running on your laptop it should be immediately possible and you would not be asking this question. Although you do not have Office sometimes you may want to connect to it.
For example you may use a Export/Import wizard to create a Excel file from the data on your SQL server. In such cases you come up with the following error:


Excel11

You will find that there are no ODBC (x64) drivers on your machine which will enable to correct this error and you need to download and register them on your computer. Open ODBC Manager on your computer and verify.
 

Internet search reveals that you can download the Access driver (Microsoft Access Database Engine 2010 Redistributable) from here:
http://www.microsoft.com/en-us/download/details.aspx?id=13255


AccessDriver

The details of this driver are shown here from the Microsoft site. This installation will provide drivers for office applicaitions including MS ACCESS and MS EXCEL.

Download and install the AccessDatabaseEngine_x64.exe file and double click the file to run the program.
Excel 22

This will install the Microsoft EXCEL and Microsoft ACCESS drivers needed for connectivity.