SQL Developer

Ok, here is my issue.

I'm able to connect to my Oracle database using SQL Developer when I enter in

Connetion Name: myDatabase
username: uuid
password: pwd

Connection Type: Basic
hostname: myOracleServer
Port: 1521
SID: orcl



now, I'm trying to connect to that same database but using the TNSNAMES.ora file, however, I keep getting error messages
[TNS listener was not given the SERVICE_NAME in CONNECT_DATA]

my TNS file looks like this:


myDatabase =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myOracleServer)(PORT = 1521))
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)

)
)


what am I missing? I really need to connect to this Database from another source (SSIS), so I need to get this working, but I'm not sure what I"m missing. I googled but nothing appears to be working for me.

My TNS file is located in the following folder: c:\app\username\product\11.2.0\client_1\Network\Admin


[it appears that this is the only forum I can post into for whatever reason, so if this is the wrong forum, go ahead and place it in the correct one