How to enable Microsoft Access Driver (*.mdb, *.accdb) in Microsoft Azure server?

How to enable Microsoft Access Driver (*.mdb, *.accdb) in Microsoft Azure windows server 2012 R2?

  • 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:

    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.

user3129330 at Stack Overflow Visit the source

Was this solution helpful to you?

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.