Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Configuration for VS 2012

user12050217Feb 18 2013
Hi,
Having below setup : (All this is testing environment)

1.One virtual Machine Guest OS is Windows 8 Pro 64 bit in Oracle Virtual Box
2.In the guest I have Microsoft Visual Studio 64 bit Ultimate Edition
3.Oracle 11.2.0.1 on same host machine windows 7 64 bit

In above Visual studio I wish to use Oracle 11.2.0.1 on same host machine. When I adds sqldatasource control, Visual Studio is saying for installation of either one :

(A) Oracle Developer Tools for Visual Studio
(B) Oracle client software version 8.1.7 or greater.

So, I downloaded ODTwithODAC1120320_32bit.zip from below link:

http://www.oracle.com/technetwork/developer-tools/visual-studio/downloads/index.html

and installation run successfully with a message regarding running installAllOracleASPNETProviders.sql after a new installation. My questions are :

1.When I opened command prompt and said sqlplus / as sysdba it is saying ORA-12560.
2.When I says sqlplus scott/tiger@orcl (I created tnsnames.ora) c:\app\nisha\product\11.2.0\client_1\Network\Admin with like this :
 orcl =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XXX.XXX)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
In above HOST = i am giving IP address of host machine on which this VM is installed and this is also oracle server database machine too, on which I am running orcl database;
so, after few seconds I am getting, ORA-12154.

How do I connect my orcl database which is running on the same host machine by using above configurations. My virtual machine is visible from other machines as well as oracle database machine too i.e. ping to VM IP is working fine.

Thanks.

Comments

Timo Hahn

User, tell us your exact JDev version, please!

In the EO or VO you select the attribute, then select the U-Hint tab and set 'Simple Date' as format type, then you can enter your pattern as 'yyyy/MM/dd hh:mm:ss' into the format field:

pastedImage_0.png

In the UI you get

pastedImage_1.png

Timo

Dimitar Dimitrov

Just a small correction - he asked for HH24:MI:SS, so 'hh' in the Java format mask must me either 'HH' (for hour in day 00-23) or 'kk' (for hour in day 01-24). Also he asked for MM/DD/YYYY, so Java format mask must be 'MM/dd/yyyy':

MM/dd/yyyy HH:mm:ss

MM/dd/yyyy kk:mm:ss

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 18 2013
Added on Feb 18 2013
0 comments
1,105 views