Skip to content

Instantly share code, notes, and snippets.

@mschmidty
Created April 5, 2023 19:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mschmidty/0260f6a9eae8a1c4d1193e84b85bfdba to your computer and use it in GitHub Desktop.
Save mschmidty/0260f6a9eae8a1c4d1193e84b85bfdba to your computer and use it in GitHub Desktop.
Set up ODBC Connection to SDE for TRFO tools

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