Difference between #107 and #108 of
Yii v2 snippet guide III

Revision #108 has been created by rackycz on Aug 15, 2022, 6:47:30 AM with the memo:

Microsoft Access MDB
« previous (#107) next (#109) »

Changes

Title unchanged

Yii v2 snippet guide III

Category unchanged

Tutorials

Yii version unchanged

2.0

Tags unchanged

tutorial,yii2,beginer

Content changed

[...]
- "ODBC Data Sources 64-bit"
- (Just hit the Win-key and type "ODBC")

Open the one you need, go to tab "System DSN" and click "Add". You will see what drivers are available - **only these drivers can be used in the DSN String!!**

If only "SQL Server" is present, then you need to install the Access Engine (or MS Access) with drivers for your platform. You need driver named cca "Microsoft Access Driver (\*.mdb, \*.accdb)" In my case the Engine added following 64bit drivers: - Microsoft Access dBASE Driver (\*.dbf, \*.ndx, \*.mdx) - Microsoft Access Driver (\*.mdb, \*.accdb) - Microsoft Access Text Driver (\*.txt, \*.csv) - Microsoft Excel Driver (\*.xls, \*.xlsx, \*.xlsm, \*.xlsb) **And how about Linux ?** You need the MS Access Drivers as well, but Microsoft does not provide them. There are some 3rd party [MdbTools](https://github.com/mdbtools/mdbtools) or [EasySoft](https://www.easysoft.com/products/data_access/odbc-access-driver/index.html#section=tab-1), but their are either not-perfect or expensive. Plus there is [Unix ODBC](http://www.unixodbc.org/).

For Java there are [Java JDBC](http://www.hxtt.com/access.html), [Jackcess](https://jackcess.sourceforge.io/) and [Ucanaccess](http://ucanaccess.sourceforge.net/site.html).

**And how about Docker ?**
As far as I know you cannot run Windows images under Linux so you will not be able to use the ODBC-advantage of Windows in this case.
[...]
8 0
4 followers
Viewed: 191 038 times
Version: 2.0
Category: Tutorials
Tags: beginer, tutorial, yii2
Written by: rackycz
Last updated by: rackycz
Created on: Jan 21, 2021
Last updated: a year ago
Update Article
Revert to #107 | Revert to #108

Revisions

View all history