topic Re: Updating Tables in MDF Database in Python Questions

Updating Tables in MDF Database

MitchHolley1 — Fri, 06 May 2016 15:02:37 GMT

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!

Re: Updating Tables in MDF Database

JakeSkinner — Fri, 06 May 2016 15:37:15 GMT

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.

Re: Updating Tables in MDF Database

DanPatterson_Retired — Fri, 06 May 2016 15:41:50 GMT

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

Re: Updating Tables in MDF Database

MitchHolley1 — Fri, 06 May 2016 17:13:17 GMT

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!