Vjylku

Is three citations per paragraph excessive for undergraduate research paper?

Why isn't airport relocation done gradually?

Why can Shazam fly?

Am I thawing this London Broil safely?

Geography at the pixel level

Is there any way to tell whether the shot is going to hit you or not?

Building a conditional check constraint

I see my dog run

Aging parents with no investments

What is the meaning of the verb "bear" in this context?

How technical should a Scrum Master be to effectively remove impediments?

Earliest use of the term "Galois extension"?

Deal with toxic manager when you can't quit

What do hard-Brexiteers want with respect to the Irish border?

What did it mean to "align" a radio?

Output the Arecibo Message

What tool would a Roman-age civilization have for the breaking of silver and other metals into dust?

Origin of "cooter" meaning "vagina"

What do the Banks children have against barley water?

Landlord wants to switch my lease to a "Land contract" to "get back at the city"

Falsification in Math vs Science

If a Druid sees an animal’s corpse, can they wild shape into that animal?

Why do UK politicians seemingly ignore opinion polls on Brexit?

Is "plugging out" electronic devices an American expression?

Connect to a SQL Server database from MS Access

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

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

This is an image of the connection properties in ArcMap:

enterprise-geodatabase sql-server esri-geodatabase ms-access

share|improve this question

edited 9 mins ago

Vince

14.8k32849

asked 8 hours ago

brandon pbrandon p

11

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  To what 'DNS' are you referring? Domain Name Service isn't file-oriented, although it uses a hosts file as a resource
  
  – Vince
  8 hours ago
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I am not sure where you insert the host file. I am stuck at the part of selecting the data source.
  
  – brandon p
  7 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I tried to click new and now wants a ODBC File Data Source. Is that the host file?
  
  – brandon p
  7 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please Edit this question to clarify the task you are attemping to complete
  
  – Vince
  7 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hello Vince. I have edited the question.
  
  – brandon p
  6 hours ago
  

  
  
  
  

 | 
show 4 more comments

0

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

This is an image of the connection properties in ArcMap:

enterprise-geodatabase sql-server esri-geodatabase ms-access

share|improve this question

edited 9 mins ago

Vince

14.8k32849

asked 8 hours ago

brandon pbrandon p

11

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  To what 'DNS' are you referring? Domain Name Service isn't file-oriented, although it uses a hosts file as a resource
  
  – Vince
  8 hours ago
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I am not sure where you insert the host file. I am stuck at the part of selecting the data source.
  
  – brandon p
  7 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I tried to click new and now wants a ODBC File Data Source. Is that the host file?
  
  – brandon p
  7 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please Edit this question to clarify the task you are attemping to complete
  
  – Vince
  7 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hello Vince. I have edited the question.
  
  – brandon p
  6 hours ago
  

  
  
  
  

 | 
show 4 more comments

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

This is an image of the connection properties in ArcMap:

enterprise-geodatabase sql-server esri-geodatabase ms-access

share|improve this question

edited 9 mins ago

Vince

14.8k32849

asked 8 hours ago

brandon pbrandon p

11

share|improve this question

edited 9 mins ago

Vince

14.8k32849

asked 8 hours ago

brandon pbrandon p

11

share|improve this question

edited 9 mins ago

Vince

14.8k32849

asked 8 hours ago

brandon pbrandon p

11

edited 9 mins ago

Vince

14.8k32849

edited 9 mins ago

Vince

14.8k32849

asked 8 hours ago

brandon pbrandon p

11

asked 8 hours ago

brandon pbrandon p

11

1 Answer
1

active

oldest

votes

0

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

share|improve this answer

edited 14 mins ago

Vince

14.8k32849

answered 4 hours ago

guillermo_dangeloguillermo_dangelo

13211

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  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
  11 mins ago
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "79"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f318394%2fconnect-to-a-sql-server-database-from-ms-access%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

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

share|improve this answer

edited 14 mins ago

Vince

14.8k32849

answered 4 hours ago

guillermo_dangeloguillermo_dangelo

13211

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  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
  11 mins ago
  

  
  
  
  

add a comment | 

0

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

share|improve this answer

edited 14 mins ago

Vince

14.8k32849

answered 4 hours ago

guillermo_dangeloguillermo_dangelo

13211

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  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
  11 mins ago
  

  
  
  
  

add a comment | 

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

share|improve this answer

edited 14 mins ago

Vince

14.8k32849

answered 4 hours ago

guillermo_dangeloguillermo_dangelo

13211

share|improve this answer

edited 14 mins ago

Vince

14.8k32849

answered 4 hours ago

guillermo_dangeloguillermo_dangelo

13211

edited 14 mins ago

Vince

14.8k32849

edited 14 mins ago

Vince

14.8k32849

answered 4 hours ago

guillermo_dangeloguillermo_dangelo

13211

answered 4 hours ago

guillermo_dangeloguillermo_dangelo

13211