Connecting to Oracle SQL Developer

[mrkuosea]

I am trying connect MS-Access 2007 database to Oracle SQL Developer.

I used the following in tnsnames.ora file:

alias =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myserver.mycompany.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)


I keeping getting Ora-12504 error.

Is there a simpler way of doing this?

Thanks,
Mark.

 

[PHV]

Have a look here:

http://www.connectionstrings.com/oracle

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886