1

I have an existing Microsoft SQL Server database which has been configured as an Enterprise geodatabase. I want to access it in MS Access in order to extract data to populate a form. What is the proper way to connect it? I have an ArcGIS Enterprise connection file named: "G:\Database Connections\eGIS_Cadastral on EGISDBP1 as viewer.sde"

So far I went to new data source > from other source > odbc database and chose Link data source. It now wants a file data source. What is that?

Here is an image on where I am stuck:

enter image description here

This is an image of the connection properties in ArcMap:

enter image description here

closed as off-topic by Hornbydd, Vince, Fran Raga, LaughU, Jochen Schwarze May 13 at 7:26

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions relating to general IT or with no clear GIS component, are off-topic here but can be researched/asked at Stack Overflow (software development), Super User (computing hardware and software), Database Administrators (relational databases) and other SE sites" – Hornbydd, Vince, Fran Raga, LaughU, Jochen Schwarze
If this question can be reworded to fit the rules in the help center, please edit the question.

  • To what 'DNS' are you referring? Domain Name Service isn't file-oriented, although it uses a hosts file as a resource – Vince Apr 10 at 15:24
  • I am not sure where you insert the host file. I am stuck at the part of selecting the data source. – brandon p Apr 10 at 15:59
  • I tried to click new and now wants a ODBC File Data Source. Is that the host file? – brandon p Apr 10 at 15:59
  • Please Edit this question to clarify the task you are attemping to complete – Vince Apr 10 at 16:14
  • Hello Vince. I have edited the question. – brandon p Apr 10 at 16:35
0

You have to use the ODBC in Windows to add the proper driver and set-up the DNS.

  • This is similar to a link-only answer, except it doesn't have a link. Please provide details to expand upon the steps necessary. – Vince Apr 10 at 23:22

Not the answer you're looking for? Browse other questions tagged or ask your own question.