[Archivesspace_Users_Group] ODBC advice

[Karen Miller]

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


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

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)

Thanks!
Celia

--
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>