2,627 Topics

Member Avatar for
Member Avatar for ashok.salvey

I have using asp.net and oracle (oracle provider) but within some time oracle sessions are full. so it gives error. have any body work on asp.net and oracle. how to handle oracle sessions. Regards. Thanks in advance... ashok salve.

Member Avatar for Ramy Mahrous
0
52
Member Avatar for Indianblues

Hi all, In C, is it possible to write a program that will read the data from database(like oracle) and inserting the data to database and some doing manipulations on the data. If yes,pls provide me information to write the program and some sample code.I am posting the same question …

Member Avatar for jephthah
0
87
Member Avatar for Agni

[quote]Reposting from another forum as i didnt get many suggestions there[/quote] Hi Guys, In my project the user will enter the name of the organization and it's floor map has to be displayed. the maps have to be made by us and need not be complicated at all. what i …

Member Avatar for ithelp
0
201
Member Avatar for echocoder

I am trying to determine a way to create a timeout for a connection attempt to remote Oracle databases. If the connection isn't created in X seconds or less, regardless of the reason, I need to stop the connection attempt and report a message. Below is the relevant bit of …

Member Avatar for echocoder
0
338
Member Avatar for BlackSwan

Hi everyone, I have a third-party application which uses DSN (in this case, only system and user DSNs) to setup database connections. I created a connection using the "Microsoft ODBC for Oracle" driver, but everytime my application needs to access the DB, I'm asked for password. I cannot change the …

Member Avatar for jwenting
0
177
Member Avatar for yobehcor15

Just want to ask question, what is the difference using server.mappath and report.load, in creating datasets for Crystal Reports? When I use server.mappath and then setting the DataSource for my Dataset, I always end up getting an error in report --> "Load Report Failed", The system cannot find the file …

0
39
Member Avatar for yobehcor15

Just want to ask question, what is the difference using server.mappath and report.load, in creating datasets for Crystal Reports? When I use server.mappath and then setting the DataSource for my Dataset, I always end up getting an error in report --> "Load Report Failed", The system cannot find the file …

0
57
Member Avatar for Iqbal_h_a

Hi All, I am struck with following problem. Please help me out. I have defined a Oracle procedure as follows. [code] PROCEDURE JOB_EXPORT IS cur CWTYPES.cursorType; l_nextdate DATE; -- JOB_NEXT_RUN l_interval VARCHAR2(64); BEGIN OPEN cur FOR SELECT JOB_NEXT_RUN, JOB_INTERVAL FROM JOB_EXPORT_CDRS WHERE ACTIVE_STATUS=1 AND JOB_INTERVAL IS NOT NULL LOOP FETCH …

Member Avatar for Iqbal_h_a
0
169
Member Avatar for KromatiK

Noobish query but oh well.... I am trying to implement TPC-H in Oracle. I downloaded the reference set for it which is a .rar file. The archive contains files in form of *.tbl.[number], *.tbl.u1.[number], *.tbl.u75.[number], *.tbl.u150.[number] and delete.u[1, 75, 150] How do i concatenate the files to make 1 single …

Member Avatar for fatima_m
0
66
Member Avatar for e_dipo81

HELLO, CAN I GET RESPONSES TO THE FOLLOWING QUESTIONS ON ORACLE 10g. 1. HOW CAN I CREATE 2 EXTRA CONTROL FILES FOR MY DATABASE, I CREATED ONE WHILE INSTALLING ORACLE 10g? 2. HOW DO INCREASE MY DUMP AREA SPACE? 3. I GOT THIS MESSAGE UNDER ALERTS "SQL RESPONSE TIME IS …

Member Avatar for jwenting
0
183
Member Avatar for monjuri

hello all, for few days i have been trying to connect with my oracle 9i database with visual studio 2005 using c#. i tried all the processes that i found in internet. but i fail to connect with my oracle database. i have service named GLOBAL USERNAME: first password: first …

Member Avatar for jwenting
0
241
Member Avatar for hgedek

I am beginner at java.I want to learn jdbc-oracle database subjects.By downloading jdeveloper and sqldeveloper I started but I couldnt connect database.So I want to start learning jdbc-oracle from begin.I need your advices.thanks.

Member Avatar for jwenting
0
74
Member Avatar for Cal_GIS

I need some help. Some collegues need to link their AutoCAD files with an external data base, in this case in Oracle. So far pretty simple, and done... Next step is to link functionality, if a record is deleted in the db, we want the corresponding CAD drawing component deleted …

Member Avatar for Cal_GIS
0
131
Member Avatar for Agni

Hi Guys, In my project the user will enter the name of the organization and it's floor map has to be displayed. the maps have to be made by us and need not be complicated at all. what i want to know is that what technologies can i use to …

Member Avatar for ithelp
0
68
Member Avatar for e_dipo81

hi all, my name is dipo elegbede, i am a nigerian and i am planning to take oracle 10g certified examination. can i get any one to give a helping hand...i had to come into the professional lounge to see if i'd get anybody. i am also working on java …

0
14
Member Avatar for ranjiths

hi, Please help what`s the process to insert local system pictures to web server database using ASP.

0
45
Member Avatar for catch.divya08

Please help me... Its very urgent... I've to finish my miniproject by tomorrow... Please Debug The coding given below... i am doin student information system. in vb oracle. i have created a module in which i wanna display info about students extracurriculars in ms flex grid control from a form …

0
93
Member Avatar for techbrain55

hello there I am new into scripting . What is the use of unix shell scripting with oracle and how can I combine oracle with unix shell scripting? Any replies regarding this would be great. Thanks in advance, Techbrain55

Member Avatar for chris5126
0
61
Member Avatar for chrisdent1986

Hi I'm a final year university student and i'm running into a bit of trouble with my final year project (It's very important) My task is to create a DBA (Database Administration) tool in visual basic to allow me to add/edit/delete users from an existing oracle(sql) database. I really don't …

Member Avatar for chrisdent1986
0
64
Member Avatar for highspeedhook

Hello, I am a programmer with 6 years professional experience. I have worked with VB.NET, Coffee Cup, Oracle, and C++. I look forward to cruzing around and check other posts and adding any helpful info I can. I also enjoy skydiving, golf, playing bass guitar, being a private pilot. :icon_cool:

Member Avatar for zandiago
0
78
Member Avatar for JoeMayo

You can tell from my screenname is Joe. I live on the coast of MS. Yes redneck central here. Looking to attend my local CC for a applied science degree (associates) and hopefully do this type of stuff for a living. Need some help on what fields or what courses …

Member Avatar for zandiago
0
99
Member Avatar for mccloud

hi i am doing a proj in jsp and oracle 9i. i want to read data from oracle and show it in the text boxes in html/jsp. i know how to read the data from oracle, but i cannot put it into text boxes. can anyone tell me how to …

Member Avatar for electron33
0
905
Member Avatar for mowen85

I have a JSP page with some text boxes. The user fills out the form, clicks the Apply button, the inputs get saved to an Oracle 10.g database. The form can be viewed again and the text boxes are populated with the saved data so the entries can be edited …

Member Avatar for ~s.o.s~
0
270
Member Avatar for reuifdjk

Hello all, When I enable Audit Trail, there are two options, AUDIT_TRAIL = DB or AUDIT_TRAIL = OS. If I use "OS", when in Windows, the audit records will be sent to the Event Viewer; but now that I am using UNIX, so can someone tell me where is the …

Member Avatar for reuifdjk
0
113
Member Avatar for reuifdjk

Hi all, I am currently doing an application using MS Access 97 as front-end GUI, connecting to a back-end Oracle server. The Oracle server version is 9.x. Now I wanna use integrated security so that I won't need to enter the username/password every time I start my application. The problem …

Member Avatar for reuifdjk
0
427
Member Avatar for dogma

I have limited oracle experience I want to dump a copy of one db and import it into a local oracle server which I'm using for dev. My problem is that I can't sort out the connect information (user@host:port/SID) type stuff. I've tried just connecting to the remote db using …

Member Avatar for debasisdas
0
235
Member Avatar for bugmenot

hi guys, i am using vb6 as front end and oracle as back end for my project. i am using ADO to connect to oracle database. can u please help me with the code. my code is [B]Dim con As New ADODB.Connection Dim str As String Private Sub Command1_Click() str …

Member Avatar for bugmenot
0
283
Member Avatar for dogma

Is there a way to query Oracle on the number of connections open (Not as the administrator). I am trying to setup connection pooling and I want something (on the client end) to check how many connections are being maintained etc.

Member Avatar for dogma
0
139
Member Avatar for omya

Hi, Plz help me in developing a simple db factory in c#.Net which can support SQL and Oracle.. i found some large code written in generics.. But i am looking for a much simpler code.. plz reply asap..

Member Avatar for debasisdas
0
68
Member Avatar for john_sm

Hey Folks - We need your help. We were hoping, we could gain from your experience with implementing server virtualization. When should we be using Red Hat Virtualization, Citrix Virtualization, Xen Virtualization, Microsoft Virtualization, Oracle Virtualization and VMWare. I will be very interested in learning from your first hand experince. …

Member Avatar for hardwyrd
0
118
Member Avatar for Auzzie

Right well i thought that seeing as i am creating a complete application i thought i would write my own db class just done a little bit of it and i am getting a nice error of [QUOTE]Fatal error: Call to undefined function mysql_connect() in *:\****************\database.engine.php on line 61[/QUOTE] it …

Member Avatar for Auzzie
0
98
Member Avatar for conklin

Hello everybody! I am from India, country where software is booming like in no other country in the world. I'm a Mechanical Engineer by degree but i'm thinking of shifting into software because the the opportunities that exist currently. I have many doubts and a lot of curiosity about programming …

Member Avatar for conklin
0
63
Member Avatar for charitha_sharma

hello all i have experience with windows forms programming but now i have to work independently for the whole project i need help in two topics pls help me 3 clients will be connected to my server front end : VB.Net my database : Oracle my question is how to …

Member Avatar for charitha_sharma
0
86
Member Avatar for chitranjanv

Hi All I would like some opionion from my IT colleagues around the world including in INdia for myself. To help you give better opinion let me first give you my background: - 26 yrs in IT - 11+ yrs in infrastructure - servers, networking.... - recent 15+ yrs in …

Member Avatar for DangerDev
0
94
Member Avatar for nirmala_n6

hi this is nirmala, i've done my oracle certification(oracle developer), i'm planning to do a project on hospital management using SQL and D2K, i need guidance as i really dont know how and where to start. please help.

Member Avatar for zandiago
0
24
Member Avatar for Ankita B

Hi,I wish to make a configuration file for db connection parameters. I read about properties file.I have made a properties file that contains the following info--- String jdbcDriver="oracle.jdbc.driver.OracleDriver"; String connectionURLThin="jdbc:oracle:thin:@ hostname:AIPUAT1"; String DbUserId="abc"; String DbUserpassword="abc"; and saved it as DbConnection.properties. i have also made a java file that uses these …

Member Avatar for Ankita B
0
141
Member Avatar for wolverine_ramir

i need help in my query.. i need to compute for the difference between two time.. i already have a formula for that but the problem is, i am setting up a condition before i get the difference between two diffrenet time... i have a table named test.. it has …

Member Avatar for debasisdas
0
77
Member Avatar for msr_viz

Hi, My name is Srinivas. im working as a software engineer in one MNC. now i want to do the oracle apps. but im in confusion to what to do in apps. 1. DBA 2. Technical Please suggest me which on is best. Regards, Srinivas Reddy. Pune.

Member Avatar for alimahboob
0
109
Member Avatar for torcakey

Hello Everyone: I've been in the computer arena for 32 years now and came up thru the ranks as operator , programmer (Cobol), Mainframe (not DB2) DBA, Informix DBA, Oracle DBA (novice). However no experience yet in the newer technologies / languages. Still love programming etc, and don't consider myself …

Member Avatar for nav33n
0
45
Member Avatar for Gimmick

Hello everyone, Gimmick here, just arrived on site. I am a noob regarding 'real' programming. Started on Oracle SQL/PLSQL just 1,5 years ago for my work. Before that I worked a year with C/All, a Navision own language based on Pascal. Joined the site since it seems like a fun …

Member Avatar for nav33n
0
102
Member Avatar for sridharp_in

Hi, My project requires, autosuggest textbox in jsp/servlets/javascript where we retrieve data from database(oracle). Thank u, Sridhar.

Member Avatar for masijade
0
64
Member Avatar for mbhawk

I am rather new at this code and am attempting to modify existing code to use clob datatypes, which I have never used before. The database tables have been set up for clob data. When trying to use dbms_lob.writeappend, I am getting the following error..Command text was not set for …

0
65
Member Avatar for jagdish.ind

hi, i am using crystal report to prepare reports. my database is in oracle 9i. i am using vb.net 2003. after creating crystal report whenever i am going to view the report in button click event it is asking me to give login id and password. for each and every …

Member Avatar for sbv
0
107
Member Avatar for Ankita B

Hi, What needs to be done to connect TOAD with oracle database ?....i have installed oracle client 9i..

Member Avatar for Jx_Man
0
127
Member Avatar for Ankita B

Hi, Im trying to modify user information on my site.for this im using java and jsp.when the user enters id,his info stored in db is to be retrieved and displayed in corresponding textboxes. I know how to access db but dont know how to put the value retrieved into textboxes …

Member Avatar for DangerDev
0
80
Member Avatar for Neji

Hi all... i am newbie here. my name is neji. i m 21 years old. i m looking for forum site and i found daniweb. i really likes this forum layout. :) i learning vb6,vb.net,c#.net,asp.net,sql server and oracle but i m not pretty much. so i need some guest from …

Member Avatar for zandiago
0
86
Member Avatar for sbv

Hi i want to select the values from my table where a column must contains some value. So i wrote this Select * from RG_TAB where CMCode = 4 and CMCode = 5 This query not giving me any result but Select * from RG_TAB where CMCode = 4 Or …

Member Avatar for debasisdas
0
96
Member Avatar for Ankita B

hi, after i create a table using toad.im tryin to insert values thru sql but it says the given table does not exist.i cant find any commit button..what could be wrong???

Member Avatar for Jx_Man
0
154
Member Avatar for krunalvarma

hello all, can any one teach me how to connect to oracle database from asp.net in vb 2005 pls reply me with code and example if u can bye

Member Avatar for Jx_Man
0
70
Member Avatar for ahmed elweshahy

how can i convert an access database to oracle database please help me

Member Avatar for kevs1607
0
78

The End.