Yii v2 snippet guide III

Comparing #105 with #106

Revision #106 was created by rackycz on Aug 15, 2022, 6:33:39 AM.

Microsoft Access MDB

Content

[...]

- (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)