I am writing a python script. In certain part of the script I would like to create a connection to MS Access database. Based on argument the script would read ID of the municipality and use it for other operations.
Below is the part of JS script which connects and reads data from MS Access Database and I would like to use it in python script.
appDB = WScript.CreateObject("ADODB.Connection");
appDB.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Database);
str = "SELECT mun.id, mun.alias FROM mun WHERE (mun.alias)='" + municipality + "';";
appRS = appDB.Execute(str);
midOb = appRS("id").Value;
appRS.close;
appDB.close;
#WScript.Echo(alias);
#WScript.Echo(idMun);
#WScript.Echo(mun_code);
ArcGIS version: 9.1-9.3. I hope you remember old times