I had installed ODAC 11.2 Release 5 (11.2.0.3.20) and Update Model from database wizard was working as expected...then after installing update 2 the wizard quit working....So Installed the latest managed drivers and beta..Data Connection connect and I can see the views and tables. but the Update Model from database wizard does not show the views and tables..
View 5 Replies1> I installed "Microsoft Visual Studio Express 2012 for Web[32 Bit]" on Win-7[64 Bit] platform.
2> Then installed Oracle Database 11gR2 [64 Bit]
What else do i need to install, in order to Add a new database connection through Visual Studio 2012's Database Explorer.
i am a Microsoft SQL Server user,and I recently thought of migrating to Oracle.So to give it I try I downloaded the following files : [URL]
But for the past two days I am heck stuck with making a Proper Installation ! I have swept the Internet and the Oracle Forums but there is not single tutorials on how to 'INSTALL' these products completely.(All tutorials are on on 10 XE and dont cover Dev Tools installation)
For eg. I installed Oracle 11 XE and ODAC 11.2 Release 5 (11.2.0.3.20) with Oracle Developer Tools for Visual Studio but still the database was not connecting.A blog suggested that I should edit and place the tnsname.ora files in the correct location then I should configure the machine.config file.But Oracle says that its universal installer automatically configures the config file.
Honestly,I love tough things but its stupid the way oracle is deploying its products. how to install and configure Oracle 11 XE with Visual Studio 2010.
dont get me wrong but this is way too outdated: [URL]
i'm newbie in oracle and visual studio 2005..i running a sql-query in visual studio 2005 with the oracle dataset..i want the data that displayed is in the date range and the parameter is set by user..
EXEC ('
SELECT DISTINCT
XNP_TIMER_VIOLATION.VIOLATION_TIME,
FROM
XNP_TIMER_VIOLATION, ...
WHERE
(DATEADD(hh, 8,XNP_TIMER_VIOLATION.VIOLATION_TIME) BETWEEN ? AND ?)',@FROM_DATE, @TO_DATE ) AT npcrpt ;
When I run a query form the the Query Window in Visuial Studios 2012 all the date fields truncated to 'mm/dd/yyyy', but i need the full date returned. I am able to get full date from TO_char(MyDateField, 'yyyy-mm-dd hh24:mi:ss'), but if I do TO_DATE(MyDateField, 'yyyy-mm-dd hh24:mi:ss') it only returns 'mm/dd/yyyy'. I'm sure this is a simple setting in Visual studios but I cant find it to save my life. Is there there a way to have the full date returned by default?
View 0 Replies View RelatedI am developing an 64bit And-In software. My OS is windows7 64bit Ultimate. Developer tool is Microsoft Visual Studio 2010 Ultimate 64bit any-CUP.Server is SUN server and Oracle database 10.2.0.5 64bit enterprise edition.I have installed instantclient-odbc-win64-10.2.0.5 on my computer.I am able to connect through the command line sqlplus user/pass@server.In date source(c:windowssystem32odbcad32.exe), ODBC Driver connection successful.But in VS2010 C#, use Tools -> Connect Database,I get an error 193 (Oracle in instantclient10_2,c:ora10_64SQORA32.dll) cann't be loaded.SQORA32.dll is 32bit ODBC Driver or 64bit ODBC Driver?How can I connect database with vs2010 64bit?
View 2 Replies View Relatedhow to convert ‘06/13/2012’ to ’June-13-2012’ in sql?
View 6 Replies View RelatedI am using Oracle forms 10.1.20.2 and Excel 2007.
I have written the following code to Quit Excel But This removes Excel from the desktop but the application still runs. If you view the task manager you see all the excel application there taking up all the recourse.
ole2.release_obj(worksheet1);
ole2.invoke (workbooks1, 'Close');
OLE2.release_obj(Workbook1 );
OLE2.release_obj(Workbooks1 );
ole2.invoke (application, 'Quit');
OLE2.release_obj(application );
SYS.DBMS_SESSION.free_unused_user_memory;
I have build a form based on a table with 2 columns,one of which isprimary key. I have created a Button with name "Quit".For that i used when-button-pressed trigger with built in "exit_form". But when I run the form,with out any execution of query or any action if I press "Quit" button,it is not working
The error message is "FRM-40202 : Field must be entered" Then I used a trigger to the item with primary key.when-new-item-instance:
set_item_instance_property('CUTOMER.CUSTID',CURRENT_RECORD,REQUIRED,PROPERTY_FALSE);
While using this,the error is "unable to resolve reference to item customer.custid" Cutomer is block name & custid is textitem with primary key. canvas used is Tab canvas with 3 tab pages with master detail relation b/w thwm. The primary key is required compulsory at the time on inserting.
with a as (
SELECT subscriber_agn,max(ixml_id) ixml_id, claim_id
FROM
(
[Code].....
i want to combine above two and need only one sql stmt.
I am having trouble getting the following update statement to work.
update Team
set Names.Team_Name = "Not Yet Assigned"
WHERE
Team.ROE_PROCESS = 'G' AND
[code]...
The error message I am receiving is:
ORA-00904: "Department"."UI_WKLY_EARNS": invalid identifier
We are using APEX 4.1. When we try to upload data to a table through upload wizard, even if the record is an update , it still shows "Insert" and then fails with "Primary Key violation" error. We have defined the correct Primary key at table and APEX interface.
View 3 Replies View RelatedWhat steps should I use in the data block wizard to create a content canvas and a tab canvas that uses one data block?
View 1 Replies View RelatedI'm new to SQL Developer and am using the wizard to import a dataset with a non-standard row terminator.The row terminator is essentially 2 spaces back to back.
In SQL Server I specified the following in the SQL Server wizard and it worked:
{CR}{LF}{CR}{LF}
What's the equivalent for oracle?
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 sql datasource 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:
[URL].........
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
ishaproduct11.2.0client_1NetworkAdmin 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 Oracle 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.
i want to retrieve records of empno from SCOTT.EMP talbe in form but without data block wizard using ..how .. and what logic will be in coding
DECLARE
TYPE EROC IS TABLE OF VARCHAR2(200) INDEX BY BINARY_INTEGER;
E1 EROC;
NO_EMPNOVARCHAR2(2000);
[code]....
just caling here EMPNO and :v_empno is fields on form...
I would like to Import data from Oracle 10g using Microsoft Sql Server (2008 R2) Import/Export Wizard, but i get this error when i try too establish the connection :
ora-01017
this the step i followed;
1- i filled the server name
2- username & password
3 - test connection ---> success
but when i try to follow pressing next(Suivant) i got the ora-01017 Error
I have Oracle 10g on an XP machine, and use the 'Oracle in OraDB10g_home1' driver to read the data. I have another Windows Server 2008 R2 machine on the same network, with SQL Server 2012 on it. What is the best way to read Oracle Tables in SQL Server? Can I setup an ODBC link from my Windows Server machine to the Oracle Database (which would require me to download an Oracle ODBC driver)? Or is the best way to export the required tables from Oracle (e.g. into csv format) and import them into SQL?
View 1 Replies View Relatedknow whether Oracle 9i works in Windows 2012? As we are planning to upgrade.
View 1 Replies View RelatedI have been trying out the new 12c on Windows 2012 Essentials with the same type of errors. The OraDim step fails and cannot create the services. It fails a bit differently if I choose "Create New Windows User", choose a "Use Existing Windows User", or choose the Windows Built-in user.
View 3 Replies View RelatedI have one problem when i try to setup ODTwithODAC121010 for connect from Visual Studio 2012 express to Oracle database 10g R2.When i setup ODTwithODAC121010 on Windows 7, can connect from visual studio to oracle database, but when i setup on Windows server 2012 Standard Evaluation x64 can't connect to oracle database through Visual studio 2012 express.
I check in registry of windows server 2012 x64 can't show Oracle folder in registry.how to connect from Visual studio 2012 express on windows server 2012 Standard evaluation x64 to Oracle database 10g.
I was wondering if the Express Edition of Oracle Database inherited the same vulnerabilities as the whole edition? Namely I have a few hosts that have Oracle Database 11g Express Edition installed and I was wondering if they would then be vulnerable to CVE-2012-3132 and specifically the easily exploitable flaw associated with it, detailed below:
Can't use links until I've posted 5 messages, ugh..link obfu with x's and [] URL....
I have a database in which two table contains millions of data and the whole database size is getting more bigger. is there any option to archive the old data which has stored before 2012 and can be restored when the data required for 2011 or 2010 needed.
View 4 Replies View Relatedhow to get visual attribute name into a variable ??I have used the below code....
s_v:=get_item_property('slot1',visual_attribute);
but i am unable to get the name of the visual_attribute..
Any info source (a book, or other) for learning how to use Visual Basic 2010 to read/update an Oracle database schema?
View 2 Replies View Relatedmy issue in oracle database 11g.
1. I installed Oracle 11g Personal Edition, Release 11.2.0.10, 64bits,
2. Test connection(oracle in oradb11g_home1) is successed in data source, odbc,
2. Then, I tried to connect this with Visual Basic(Visual Studio 2010), data connections, add connections, .net framework data provider for oracle,
3. but I received an error message as "Attempt to load Oracle client libraries threw BadImageFormatException."
4. Then, I download the ODAC(11.2.0.3.0) for 64bits, and installed,
5. I tried to test the connection, but failed with error message as stated above,
"Unable to connect SQLState=08004 Oracle ODBC Ora-12154: TNS:could not resolve the connect identifier specified"
I need to install ODAC for 11g Personal Edition ?
way to set the properties of a visual attribute group during runtime? During our forms 6 to 10 conversion we missed that our visual attributes for mandatory and not-manadatory items were different, so we have font size 8 and 9 in our system now, does not look very nice.
View 1 Replies View RelatedI have a database block that refreshes using a timer. In short, I list all open work pieces for a certain garage, displaying route, run, on_time, of_time, location grouped by garage, on_time, off_time
I need to highlight every garage with a different color. I am highlighting the on_time every time the garage changes.
The problem is, every time I move down the records, instead of keeping the previous garage color, and highlight the new garage on_time with a new color, the whole on_time column will be set to the current garage color.
I need to break down the block by color so the user can distinguish between the different garages, and the start and end time. Here is my code, I am putting it in when_new_record_instance of the work_block:
IF :work_bLock.current_garage = 9006 THEN
Set_Item_Property('work_block.on_time', BACKGROUND_COLOR, 'r191g223b191');
ELSIF :work_bLock.current_garage = 9002 THEN
Set_Item_Property('work_block.on_time', BACKGROUND_COLOR, 'r255g228b196');
ELSE
Set_Item_Property('work_block.on_time', BACKGROUND_COLOR, 'r255g250b250');
END IF;
I need the block to be 3 or more different colors depending on the garage.
I'm trying to add edmx file in my project for first time. I want to choose the oracle provider ODP.net but cannot find Oracle in the data source list. I have oracle 11g installed , odp and odt installed and can access it from the solution as well. I saw the Oracle listed under data source when I tried to connect the solution to the database through server explorer. The solution is connected to Oracle database through ODP.
View 8 Replies View RelatedI m using oracle forms 9i in which i want effect on text fields that will change color of text after mouse cursor move on that field . is it possible in oracle form 9i .
View 6 Replies View Related