[Archivesspace_Users_Group] ODBC advice

Karen Miller k-miller3 at northwestern.edu
Thu Feb 17 11:04:20 EST 2022

Hi Celia,

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:

Set up an ODBC connection with the following:

  *   Data Source Name: ArchivesSpace Production
  *   Description: can be left blank
  *   TCP/IP Server: [your TCP/IP server here]
  *   Port: 3306 [this is the default – yours may differ]
  *   User: [check with your DBA for this]
  *   Password: [check with your DBA for this]
  *   Database: can be left blank until the connection is first made, then should be archivesspace

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.

If you need fuller instructions, I can edit our documentation to hide the local settings and send it along.


Karen D. Miller
Monographic Cataloger/Metadata Specialist
Northwestern University Libraries
Northwestern University
1970 Campus Drive
Evanston, IL 60208
k-miller3 at northwestern.edu

From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Celia Caust-Ellenbogen
Sent: Wednesday, February 16, 2022 12:32 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] ODBC advice

Hi folks,

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)


Celia Caust-Ellenbogen (she/her/hers<https://urldefense.com/v3/__https:/www.swarthmore.edu/lgbtq/gender-pronouns__;!!Dq0X2DkFhyF93HkjWTBQKhk!D7Rn54F7Dy4gAmmuhQ7htFhwNP42RSySVEhB_BgXAHP27iHbpY4KP2XX0YGRIRdGZizNLIxU$>) (pronounce my name<https://urldefense.com/v3/__https:/www.name-coach.com/celia-caust-ellenbogen__;!!Dq0X2DkFhyF93HkjWTBQKhk!D7Rn54F7Dy4gAmmuhQ7htFhwNP42RSySVEhB_BgXAHP27iHbpY4KP2XX0YGRIRdGZuQ308Kx$>)
Friends Historical Library of Swarthmore College<https://urldefense.com/v3/__http:/swarthmore.edu/friends-historical-library__;!!Dq0X2DkFhyF93HkjWTBQKhk!D7Rn54F7Dy4gAmmuhQ7htFhwNP42RSySVEhB_BgXAHP27iHbpY4KP2XX0YGRIRdGZksKVJU3$>
ccauste1 at swarthmore.edu<mailto:ccauste1 at swarthmore.edu>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20220217/aacd7c52/attachment.html>

More information about the Archivesspace_Users_Group mailing list