Skip to content

Instantly share code, notes, and snippets.

@mschmidty

mschmidty/sde_connect.md

Created April 5, 2023 19:54
Show Gist options
  • Save mschmidty/0260f6a9eae8a1c4d1193e84b85bfdba to your computer and use it in GitHub Desktop.
Save mschmidty/0260f6a9eae8a1c4d1193e84b85bfdba to your computer and use it in GitHub Desktop.
Download ZIP
Set up ODBC Connection to SDE for TRFO tools
Raw
sde_connect.md

RODBC Connection

In order to connect to this connection you must be on a BLM computer.

To create an ODBC connection, on a Windows computer connected to a BLM network or VPN network, in the search bar search "ODBC Data Sources (32-bit)" in the windows search bar.

When the window opens:

  • Click "Add".
  • Select "SQL Server" and click "Finish".
  • Enter a name (this can be whatever you want) "COsde"
  • Enter a description "COsde"
  • In the Database field add "ilmocop3db16\sdesqlco".
  • Click Next
  • Leave the next screen as default and click next.
  • Select "Change the default database to:"
  • Then from the dropdown select "ilmcoedt"
  • click "Next"
  • then click "Finish"
  • A new dialogue should pop up, Click "Test Data Source"
  • If the next data dialogue says: "TESTS COMPLETED SUCCESSFULLY!" you are good to go.
  • Click "Ok" and "Ok" on both open dialogues and close the ODBC Data Source dialogue.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment