I am trying to make a simple connection from my desktop(local computer) with Oracle 11g which is installed on windows server 2008 R2.Now I have problems with the ConnectionString.
could you please let me know how I set a correct connection String while I have parameters like these:
Database name: GISData
Server Name : SRV_GISSER
Port : 1521
User Name : Example
Password: : Example
I already tried the
ConnectionString = "provider=MSDAORA;data source=GISData;user id=Example;password=Example";
an I am getting this exception:
An Exception of type System.Data.OleDb.OlDbException was thrown\nORA-12154:TNS:Could not resolve the connect identifier specified
I know that I am missing the server part but Honestly I do not know how to provide the string with it!