Connect to a SQL Server database from MS Access Planned maintenance scheduled April 23, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?ArcSDE error: “Maximum number of connections to instance exceeded ”Issues while changing ArcSDE from a Workgroup to Domain EnvironmentQGIS 2.4 access .mdb add errorNeeding ArcGIS Server to edit MS SQL Server database?Connecting QGIS 2.14.3 to SQL 2012 both on LocalHost or RemoteAccess database file to QGISConnecting to SQL Server with ArcGIS Desktop?How to get data from Access to QGIS?Is it possible to connect Alteryx to feature classes in an Oracle based SDE?Import tables from MSAccess to QGIS
Why wasn't DOSKEY integrated with COMMAND.COM?
What would you call this weird metallic apparatus that allows you to lift people?
Why does it sometimes sound good to play a grace note as a lead in to a note in a melody?
How to tell that you are a giant?
Is CEO the "profession" with the most psychopaths?
Is grep documentation about ignoring case wrong, since it doesn't ignore case in filenames?
If Windows 7 doesn't support WSL, then what does Linux subsystem option mean?
When a candle burns, why does the top of wick glow if bottom of flame is hottest?
Why do we need to use the builder design pattern when we can do the same thing with setters?
How to compare two different files line by line in unix?
How fail-safe is nr as stop bytes?
What is the appropriate index architecture when forced to implement IsDeleted (soft deletes)?
Question about debouncing - delay of state change
How do living politicians protect their readily obtainable signatures from misuse?
How could we fake a moon landing now?
Crossing US/Canada Border for less than 24 hours
Dating a Former Employee
Why should I vote and accept answers?
Hangman Game with C++
Has negative voting ever been officially implemented in elections, or seriously proposed, or even studied?
A term for a woman complaining about things/begging in a cute/childish way
Why does the remaining Rebel fleet at the end of Rogue One seem dramatically larger than the one in A New Hope?
Maximum summed subsequences with non-adjacent items
How does light 'choose' between wave and particle behaviour?
Connect to a SQL Server database from MS Access
Planned maintenance scheduled April 23, 2019 at 00:00UTC (8:00pm US/Eastern)
Announcing the arrival of Valued Associate #679: Cesar Manara
Unicorn Meta Zoo #1: Why another podcast?ArcSDE error: “Maximum number of connections to instance exceeded ”Issues while changing ArcSDE from a Workgroup to Domain EnvironmentQGIS 2.4 access .mdb add errorNeeding ArcGIS Server to edit MS SQL Server database?Connecting QGIS 2.14.3 to SQL 2012 both on LocalHost or RemoteAccess database file to QGISConnecting to SQL Server with ArcGIS Desktop?How to get data from Access to QGIS?Is it possible to connect Alteryx to feature classes in an Oracle based SDE?Import tables from MSAccess to QGIS
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom: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
edited Apr 10 at 23:24
Vince
14.8k32850
asked Apr 10 at 15:03
brandon pbrandon p
11
|
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
edited Apr 10 at 23:24
Vince
14.8k32850
asked Apr 10 at 15:03
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
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
|
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
edited Apr 10 at 23:24
Vince
14.8k32850
asked Apr 10 at 15:03
brandon pbrandon p
11
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
enterprise-geodatabase sql-server esri-geodatabase ms-access
edited Apr 10 at 23:24
Vince
14.8k32850
asked Apr 10 at 15:03
brandon pbrandon p
11
edited Apr 10 at 23:24
Vince
14.8k32850
asked Apr 10 at 15:03
brandon pbrandon p
11
edited Apr 10 at 23:24
Vince
14.8k32850
edited Apr 10 at 23:24
Vince
14.8k32850
edited Apr 10 at 23:24
Vince
14.8k32850
14.8k32850
asked Apr 10 at 15:03
brandon pbrandon p
11
asked Apr 10 at 15:03
brandon pbrandon p
11
asked Apr 10 at 15:03
brandon pbrandon p
11
11
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
|
show 4 more comments
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
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
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 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
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
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
Hello Vince. I have edited the question.
– brandon p
Apr 10 at 16:35
|
show 4 more comments
1 Answer
1
active
oldest
votes
You have to use the ODBC in Windows to add the proper driver and set-up the DNS.
edited Apr 10 at 23:19
Vince
14.8k32850
answered Apr 10 at 18:59
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
Apr 10 at 23:22
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
);
);
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
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
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You have to use the ODBC in Windows to add the proper driver and set-up the DNS.
edited Apr 10 at 23:19
Vince
14.8k32850
answered Apr 10 at 18:59
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
Apr 10 at 23:22
add a comment |
You have to use the ODBC in Windows to add the proper driver and set-up the DNS.
edited Apr 10 at 23:19
Vince
14.8k32850
answered Apr 10 at 18:59
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
Apr 10 at 23:22
add a comment |
You have to use the ODBC in Windows to add the proper driver and set-up the DNS.
edited Apr 10 at 23:19
Vince
14.8k32850
answered Apr 10 at 18:59
guillermo_dangeloguillermo_dangelo
13211
You have to use the ODBC in Windows to add the proper driver and set-up the DNS.
edited Apr 10 at 23:19
Vince
14.8k32850
answered Apr 10 at 18:59
guillermo_dangeloguillermo_dangelo
13211
edited Apr 10 at 23:19
Vince
14.8k32850
edited Apr 10 at 23:19
Vince
14.8k32850
edited Apr 10 at 23:19
Vince
14.8k32850
14.8k32850
answered Apr 10 at 18:59
guillermo_dangeloguillermo_dangelo
13211
answered Apr 10 at 18:59
guillermo_dangeloguillermo_dangelo
13211
answered Apr 10 at 18:59
guillermo_dangeloguillermo_dangelo
13211
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
Apr 10 at 23:22
add a comment |
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
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
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
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
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
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
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