Updating Tables in MDF Database

Question

I'm trying to write a script that will update records in an MDF database (SQL Sever Express).  I was looking into using the pyodbc module and update the fields with Python.  Is this possible?  Has anyone connected and updated a MDF database this way?

This is what I have so far.

Is it worth it to continue with this script?  Or am I wasting my time?

Thanks for the help!

MitchHolley1 · Answer

Jake,

Thanks for the response.  It is a geodatabase, and it does sit in SQL Server Express.  I'll see if I can connect with arcpy.

Thanks again!

DanPatterson_Retired · Answer

did it print your last statement? any errors? or it just did nothing?

jskinner · Answer

Hi Mitch,

Quick question, is this a geodatabase in SQL Server Express?  Or is it strictly a database (i.e. no feature classes, or SDE repository)?

If this is a geodatabase, and the tables are registered with the geodatabase, you should use the arcpy.da.UpdateCursor to make the update.