Revision #106                                    has been created by  rackycz                                    on Aug 15, 2022, 6:33:39 AM with the memo:
 rackycz                                    on Aug 15, 2022, 6:33:39 AM with the memo:
                                
                                
                                    Microsoft Access MDB                                
                                                                    « previous (#105)                                                                                                    next (#107) »                                                            
                            Changes
                            
    Title
    unchanged
    Yii v2 snippet guide III
    Category
    unchanged
    Tutorials
    Yii version
    unchanged
    2.0
    Tags
    unchanged
    tutorial,yii2,beginer
    Content
    changed
    [...]
- (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)