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 [email protected] 874.467.3462 From: [email protected] <[email protected]> On Behalf Of Celia Caust-Ellenbogen Sent: Wednesday, February 16, 2022 12:32 PM To: Archivesspace Users Group <[email protected]> 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$> [email protected]<mailto:[email protected]>
_______________________________________________ Archivesspace_Users_Group mailing list [email protected] http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
