Oracle Database Discussions

Hello-

I am a new Oracle user and have permission to access to a remote Oracle database, however I am having issues with the initial setup/configuration using ODBC! I have downloaded the Oracle Driver and Instant Client (11.2.0.2.0) and I need to use Microsoft Access for accessing the data (the Access database is already configured to the correct Oracle database). Note: Im working on Windows XP.

Issues I am having:

I am still struggling with ODBC in that I get the same SQLState=S1000 Error. ORA-12514: TNS: Listener does not currently know of service requested in connect descriptor.

My TNSnames.ora file currently looks like this:

alias= (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=chrdbprd02)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=alias)))

I need to be linking to operating system chrdbprd02, port 1521. The database name is p016 (but Im not sure where to include that in the TNSnames.ora file if you can't have both a service and SID in the same file...)

I have been using "Alias" for the "TNS Service name" and the "Data Source Name".

I would appreciate any feedback. Thanks!