DevOps, CI/CD and Automation

Hello all,

i have one DB-Server and one Application-Server. From the App-Server i want to access the db via odbc.

Even if i create the odbc connection in windows odbc manager and click "test connection", i get the error "Ora-12154 TNS: Angegebener Connect Identifier konnte nicht aufgelöst werden"

DB-Server:
Oracle DB 11.0.2g 64 bit

App-Server:
windows 2008 R2 64Bit, login as network administrator
Oracle Instantclient_11_2 with installed ODBC drivers
folder of instantclient: "C:\ora\instantclient_11_2_new"
folder of tnsnamesora: "C:\ora\net"

environment variables:
-ORACLE_HOME: "C:\ora\instantclient_11_2_new"
-Path: "C:\ora\instantclient_11_2_new"
-TNS_Admin: "C:\ora\net"

tnsnames.ora:
bns =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.99.99)(PORT = 1521)))
(CONNECT_DATA =
(SERVICE_NAME = bns)
)
)

Anybody has an idea what the issue is ?
Unfortunately this is the first odbc connection to the oracle db.

Thanks for your help