如何在Microsoft Azure Windows Server 2012 R2中启用Microsoft Access驱动程序（* .mdb，* .accdb）？

Question

I have virtual machine(Windows server 2012 R2) in Azure server (Plan as A0).

I cant find ODBC Data source in Administrative Tools.

I want to use below ODBC connection for my application.

 new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};charset=UTF-8; DBQ=$destination_file; Uid=$db_username; Pwd=$db_password;") or die("Invalid user credentials for Access file.");

Answer 1

I cant find ODBC Data source in Administrative Tools.

It seems strange, I have created an A0 VM on Azure to have a further check, I could get [ODBC Data Source] from Administrative tool: Could you please try to search 'Administrative tool' again in Azure VM and double check if it works, or try to set up another VM to see if the issue can be reproduced.