<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (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;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
p.MsoNoSpacing, li.MsoNoSpacing, div.MsoNoSpacing
{mso-style-priority:1;
margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Arial",sans-serif;
color:#1F497D;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:632826704;
mso-list-type:hybrid;
mso-list-template-ids:-1132313768 67698689 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1
{mso-list-id:734744684;
mso-list-type:hybrid;
mso-list-template-ids:2102447994 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l1:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.25in;
text-indent:-.25in;}
@list l1:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.75in;
text-indent:-.25in;}
@list l1:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:1.25in;
text-indent:-9.0pt;}
@list l1:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.75in;
text-indent:-.25in;}
@list l1:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.25in;
text-indent:-.25in;}
@list l1:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:2.75in;
text-indent:-9.0pt;}
@list l1:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:3.25in;
text-indent:-.25in;}
@list l1:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:3.75in;
text-indent:-.25in;}
@list l1:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:4.25in;
text-indent:-9.0pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></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]-->
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D">Hi Celia,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D">I had to redo my ODBC setting recently, so it’s relatively fresh in my mind. Here’s what I think is the relevant issue from our documentation at NUL:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNoSpacing">Set up an ODBC connection with the following: <o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoNoSpacing" style="mso-list:l0 level1 lfo2">Data Source Name: ArchivesSpace Production<o:p></o:p></li><li class="MsoNoSpacing" style="mso-list:l0 level1 lfo2">Description: can be left blank<o:p></o:p></li><li class="MsoNoSpacing" style="mso-list:l0 level1 lfo2">TCP/IP Server: [your TCP/IP server here]<o:p></o:p></li><li class="MsoNoSpacing" style="mso-list:l0 level1 lfo2">Port: 3306 [this is the default – yours may differ]<o:p></o:p></li><li class="MsoNoSpacing" style="mso-list:l0 level1 lfo2">User: [check with your DBA for this]<o:p></o:p></li><li class="MsoNoSpacing" style="mso-list:l0 level1 lfo2">Password: [check with your DBA for this]<o:p></o:p></li><li class="MsoNoSpacing" style="mso-list:l0 level1 lfo2">Database: can be left blank until the connection is first made, then should be archivesspace<o:p></o:p></li></ul>
<p class="MsoNoSpacing" style="margin-left:.5in"><o:p> </o:p></p>
<p class="MsoNoSpacing" style="margin-left:.5in"><o:p> </o:p></p>
<p class="MsoNoSpacing">If you want to check out your own configuration in the ODBC Data Source Administrator (click Configure to see how it’s set up for you), that should give you the TCP/IP server and the Port number.<o:p></o:p></p>
<p class="MsoNoSpacing"><o:p> </o:p></p>
<p class="MsoNoSpacing">If you need fuller instructions, I can edit our documentation to hide the local settings and send it along.<o:p></o:p></p>
<p class="MsoNoSpacing"><o:p> </o:p></p>
<p class="MsoNoSpacing">Karen<o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><b><span style="font-family:"Arial",sans-serif;color:#272323">Karen D. Miller<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:black">Monographic Cataloger/Metadata Specialist<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Arial",sans-serif;color:#272323">Northwestern University Libraries<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Arial",sans-serif;color:#4E2A85">Northwestern University<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Arial",sans-serif;color:black">1970 Campus Drive<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Arial",sans-serif;color:black">Evanston, IL 60208<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Arial",sans-serif;color:#272323">www.library.northwestern.edu<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Arial",sans-serif;color:black">k-miller3@northwestern.edu<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#272323">874.467.3462</span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Celia Caust-Ellenbogen<br>
<b>Sent:</b> Wednesday, February 16, 2022 12:32 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [Archivesspace_Users_Group] ODBC advice<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hi folks,<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">My colleague is trying to set up an ODBC connection between ArchivesSpace and MS Access (read-only) and has hit a dead end. I set it up for myself about 7 years ago and so my memory is foggy. Has anyone done it recently or can offer assistance?
The step that is tripping her up is setting up the Data Source (on a Windows machine)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks!<br>
Celia<br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">-- <o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt">Celia Caust-Ellenbogen (<a href="https://urldefense.com/v3/__https:/www.swarthmore.edu/lgbtq/gender-pronouns__;!!Dq0X2DkFhyF93HkjWTBQKhk!D7Rn54F7Dy4gAmmuhQ7htFhwNP42RSySVEhB_BgXAHP27iHbpY4KP2XX0YGRIRdGZizNLIxU$" target="_blank">she/her/hers</a>)
(<a href="https://urldefense.com/v3/__https:/www.name-coach.com/celia-caust-ellenbogen__;!!Dq0X2DkFhyF93HkjWTBQKhk!D7Rn54F7Dy4gAmmuhQ7htFhwNP42RSySVEhB_BgXAHP27iHbpY4KP2XX0YGRIRdGZuQ308Kx$" target="_blank">pronounce my name</a>)</span><o:p></o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt"><a href="https://urldefense.com/v3/__http:/swarthmore.edu/friends-historical-library__;!!Dq0X2DkFhyF93HkjWTBQKhk!D7Rn54F7Dy4gAmmuhQ7htFhwNP42RSySVEhB_BgXAHP27iHbpY4KP2XX0YGRIRdGZksKVJU3$" target="_blank">Friends
Historical Library of Swarthmore College</a></span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="mailto:ccauste1@swarthmore.edu" target="_blank"><span style="font-size:10.0pt">ccauste1@swarthmore.edu</span></a><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>