Azure Machine Learning
An Azure machine learning service for building and deploying models.
3,332 questions
How to interact with Microsoft Access Database on Vs code through Azure ML compute
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 47%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
Deep R. Joshi
0
Reputation points
Hi,
I am trying to interact with an MS Access Database (.accdb file) using a VS code (python) compute instance through Azure ML studio. I want to access a table, perform calculations, and update the database. Locally, I was using pyodbc library to achieve this but this approach didn't work on the compute instance due to the lack of an MS Access Driver. I also tried importing the table through the subprocess library, but I cannot update the access file. Is there a way I can accomplish this in the ML studio compute?
Azure Machine Learning
{count} votes
-
romungi-MSFT 48,906 Reputation points Microsoft Employee Moderator2023-06-07T10:03:58.71+00:00 @Deep R. Joshi Are you trying to use VS code to run a notebook on the compute instance? If yes, then you could try to run the following through a notebook cell to install pyodbc on your compute instance which should make this library available through the kernel used to run the notebook.
%pip install pyodbc -
Deep R. Joshi 0 Reputation points
2023-06-07T14:24:02.8766667+00:00 Yes I am. I already have pyodbc installed. This is the error that I am seeing.
Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'Microsoft Access Driver (*.mdb, *.accdb)' : file not found (0) (SQLDriverConnect)")These are the ODBC drivers available:
['ODBC Driver 17 for SQL Server', 'MDBToolsODBC', 'MDBToolsODBC'] -
romungi-MSFT 48,906 Reputation points Microsoft Employee Moderator
2023-06-08T05:56:38.41+00:00 @Deep R. Joshi Is the file on the compute instance? Did you try to place the file on the instance and check if it was accessible from notebook rather than your local machine. If this works, then it could be that the file is not accessible due to some networking conditions from your compute instance.
-
Deep R. Joshi 0 Reputation points
2023-06-09T16:00:38.36+00:00 Yes the file is on the compute instance. I could use
subprocesslibrary to load the file and extract data and perform all necessary calculations but I still can not save the data to another access database due to the error that I had mentioned above -
Deep R. Joshi 0 Reputation points
2023-06-14T14:43:20.54+00:00 @romungi-MSFT Can you please look into this whenever you get a chance?
Sign in to comment
Sign in to answer