How to connect to ORACLE Database

I was able to install a Oracle client (both a x32 and a x64, since i got the error from this post: Connecting to Oracle Database) .

Now though i get the same error as described in this post: Error connecting to database but the solution doesnt help me. As far as I can read I have a problem with my ODBC, but what is the prerequisite for using this setup?

Alternately if I try to set up my connection with:
ProviderName: “System.Data.OracleClient”
ConnectionString: “SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myHostNam)(PORT=myPort))(CONNECT_DATA=(SERVICE_NAME=mySID)));uid=myUsername;pwd=myPwd;”
I get the error message:
“Connect : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor”

Got any pointers on what Im doing wrong?

Kind/desperate regards Mikkel

1 Like