title: Connection to Oracle ODBC Datasource via Visual Studio asp.net
body: <p>I would like to connect to a oracle db in our network, but I do not know how.
  In visual code, we use this .env for our database connection:</p>
  <pre><code># db credentials
  ORACLEDB_USER=x
  ORACLEDB_PASSWORD=x
  ORACLEDB_HOSTNAME=xxxx
  ORACLEDB_PORT=1521
  ORACLEDB_SERVICE_NAME=xxxx
  IF_INV_PATH=
  inv_target_path=
  TIFF_PATH_ROOT=
  inv_path=
  </code></pre>
  <p>which works.
  When I now try to use the Visual Studio ODBC Server connection I have to use a connection string.
  I tried something like this (found via google):
  (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=xxxx)));uid=xxxx;pwd=xxxx;</p>
  <p>where I get this error:<br />
  <a href="https://i.stack.imgur.com/DNHbF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DNHbF.png" alt="enter image description here" /></a></p>
  <p>(which loosely translates to: Datasource not found, and no default driver given)</p>
  <p>I'm pretty confused and have no experience with setting up a connection to a oracle db.
  I have installed the x64 driver from this site:
  <a href="https://docs.microsoft.com/de-de/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15" rel="nofollow noreferrer">https://docs.microsoft.com/de-de/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15</a>
  But it doesn't change anything.</p>