<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
I had to install:
<a class="moz-txt-link-freetext" href="http://www.microsoft.com/en-us/download/details.aspx?id=13255">http://www.microsoft.com/en-us/download/details.aspx?id=13255</a> and
then went through the ODBC Connection<br>
<br>
Granted I did this on a windows laptop with no ArcGIS installed -
which makes me wonder if it would be any different.....<br>
<br>
I wrote it up a turorial:
<a class="moz-txt-link-freetext" href="http://www.northrivergeographic.com/qgis-accessing-personal-geodatabase">http://www.northrivergeographic.com/qgis-accessing-personal-geodatabase</a>
<br>
<br>
Hope it helps or gets you pointed in the right direction! <br>
<br>
Randy<br>
<br>
<div class="moz-cite-prefix">On 04/13/2015 11:26 AM, John Barnes
wrote:<br>
</div>
<blockquote
cite="mid:B0CAF2A7A9F5E94DBF56876CC499BF5501BB39DEDC@xch2010"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Generator" content="Microsoft Word 12 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">QGIS 2.8.1<o:p></o:p></p>
<p class="MsoNormal">Windows 7 64bit<o:p></o:p></p>
<p class="MsoNormal">MS Office 2007 32bit<o:p></o:p></p>
<p class="MsoNormal">.NET Framework 4.5.2<o:p></o:p></p>
<p class="MsoNormal">Scrip Runner Version 2.0.1<o:p></o:p></p>
<p class="MsoNormal">Installed via standalone installer<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Trying to connect to an access database via
OLEDB. Tried this multiple ways, but I just can’t get it to
work. Error below says the Provider may not be properly
installed, but I connect to the same access database through a
vb.net addin in ArcMap with the same connection string
(Microsoft.JET.OLEDB.4.0).<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Any ideas?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">John<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">==============my
code======================================<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">import adodbapi<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">def run_script(iface):<o:p></o:p></p>
<p class="MsoNormal"> cLayer = iface.activeLayer()<o:p></o:p></p>
<p class="MsoNormal"> #print cLayer.name()<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"> databasename = 'c:\\aab\\GISdb.mdb'<o:p></o:p></p>
<p class="MsoNormal"> constr =
'Provider=Microsoft.JET.OLEDB.4.0;Data Source=%s' %
databasename
<o:p></o:p></p>
<p class="MsoNormal"> db = adodbapi.connect(constr)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">=============================================================<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">====================Error
message==============================<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","serif"">----------2015-04-13
08:13:05.038000----------<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","serif"">Running db.py in: C:/Program
Files/QGIS Wien/bin<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","serif"">Traceback (most recent call
last):<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","serif"">File
"C:/Users/barnesj/.qgis2/python/plugins\scriptrunner\scriptrunner.py",
line 553, in run_script<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","serif"">user_script.run_script(self.iface)<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","serif"">File
"C:\PROGRA~1\QGISWI~1\bin\db.py", line 11, in run_script<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","serif"">db = adodbapi.connect(constr)<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","serif"">File
"C:\PROGRA~1\QGISWI~1\apps\Python27\lib\site-packages\adodbapi\adodbapi.py",
line 307, in connect<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","serif"">raise OperationalError(e,
"Error opening connection: " + connection_string)<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","serif"">OperationalError:
(com_error(-2147352567, 'Exception occurred.', (0,
u'ADODB.Connection', u'Provider cannot be found. It may not
be properly installed.', u'C:\\Windows\\HELP\\ADO270.CHM',
1240655, -2146824582), None), 'Error opening connection:
Provider=Microsoft.JET.OLEDB.4.0;Data
Source=c:\\aab\\GISdb.mdb;')<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","serif"">Abnormal termination<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","serif"">Completed script: db.py<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
-----------------
Randal Hale
North River Geographic Systems, Inc
<a class="moz-txt-link-freetext" href="http://www.northrivergeographic.com">http://www.northrivergeographic.com</a>
423.653.3611 <a class="moz-txt-link-abbreviated" href="mailto:rjhale@northrivergeographic.com">rjhale@northrivergeographic.com</a>
twitter:rjhale <a class="moz-txt-link-freetext" href="http://about.me/rjhale">http://about.me/rjhale</a>
<a class="moz-txt-link-freetext" href="http://www.northrivergeographic.com/introduction-to-quantum-gis">http://www.northrivergeographic.com/introduction-to-quantum-gis</a></pre>
</body>
</html>