Oracle DB with Pro/5 - Oracle Database

Dominic

Hi,

I am TOTALLY new to all this stuff and really hope to find help here.

I have to come up with a solution for one of my client.
They use HP-UX and Pro/5

What I'm trying to do:
Using Pro/5. Make a SQL ( select ) statement to an ORACLE database.
What I need to know and do:
- Find an OBDC driver that will allow me to connect to the ORACLE database.
- Configure what file ? ( config.tpm, obdc.ini, sql.ini ) are all these
files important ?? What should they look like ? Have any example of those
file for an Oracle database.

=============== ===========
I just need to install a simple test oracle database and query a table from
pro/5.

All this is so new, my question might seem to much work to explain, but I
read a lot on many website, but can't make things to work ... can't find an
obdc .. don't know how to configure it anyway ... I need help please.

I know it is possible to query an Unix-Oracle Database from Pro/5 (NOT
VPRO5) , I just need help of someone who did this already.

Thanks !
Dominic

db*****@cosotec h.com

Jul 19 '05 #1

Subscribe Reply

3204

Peter Murray

Hi Dominic,

If you have the Oracle CD and have installed Oracle client libraries, an
ODBC driver should come with it. Alternatively, you can download a
driver from DataDirect (http://www.datadirect.com). Their drivers do not
require Oracle's client libraries however these drivers will cost you $500.

You could also try WinSQL (http://www.synametrics.com) that comes with
Oracle's Driver and can be used to test your connectivity.

Regards,
PM

Dominic wrote:

Hi,

I am TOTALLY new to all this stuff and really hope to find help here.

I have to come up with a solution for one of my client.
They use HP-UX and Pro/5

What I'm trying to do:
Using Pro/5. Make a SQL ( select ) statement to an ORACLE database.
What I need to know and do:
- Find an OBDC driver that will allow me to connect to the ORACLE database.
- Configure what file ? ( config.tpm, obdc.ini, sql.ini ) are all these
files important ?? What should they look like ? Have any example of those
file for an Oracle database.

=============== ===========
I just need to install a simple test oracle database and query a table from
pro/5.

All this is so new, my question might seem to much work to explain, but I
read a lot on many website, but can't make things to work ... can't find an
obdc .. don't know how to configure it anyway ... I need help please.

I know it is possible to query an Unix-Oracle Database from Pro/5 (NOT
VPRO5) , I just need help of someone who did this already.

Thanks !
Dominic

db*****@cosotec h.com

Jul 19 '05 #2

Similar topics

5218

Oracle 8.1.7 on Mandrake 9.1 install problems

by: Jan Bols | last post by:

I've been trying to install Oracle 8.1.7 on a fresh Mandrake 9.1 O.S for days, but I'm still not able to get it running. I've tried several install instructions that I found on the internet but no luck yet. Here is a short description of what I did so far: 1. I installed the jdk118_v3-glibc-2.1.3.tar in the /usr/local/ dir and made a symbolic link from /usr/local/java to this 2. I installed all the necessary groups and users (oracle,...

Oracle Database

19984

migration from oracle 8i to 9i

by: susmita_ganguly | last post by:

Hi I am trying to upgrade from oracle 8i to oracle 9i on the same server ..I don't know much abt migration . Can anyone help me out. Thanks. Susmita

Oracle Database

25607

Equivilant of Oracle's DB Links in DB2

by: Nick Palmer | last post by:

Hi all, Is there a DB2 equivilant to Oracle's DB Link functionality ? I have two DB2 databases and I need to get access to the tables in one from the other. In Oracle I would just create a DB Link between the two instances. Is such a thing possible between two DB2 databases ? Thanks in advance, Nick

DB2 Database

23449

Import table from Oracle to Access

by: Jon Ole Hedne | last post by:

My Access 2002-application need to work with tables from both Oracle and Access. To solve this, I want to run some querys on three views in Oracle and import the results into temporary Access-tables. I have tried this: conn.Provider = "Microsoft.Jet.OLEDB.4.0" conn.ConnectionString = "data source=" & datafil & ";Jet OLEDB:Database Password=" conn.Open datafil

Microsoft Access / VBA

7462

Oracle Adventures

by: Chris Botha | last post by:

The machine is running XP Pro with all the latest service packs, etc. I must access an Oracle database so I installed the Oracle client stuff. I can query Oracle from a Windows app, no problem. Using the exact same code (copy and paste) into a Web app I get the following error "Error while trying to retrieve text for error ORA-01019". Security I thought, so I use Impersonation on the Web site, then the aspnet_wp.exe crashes with "The...

ASP.NET

14225

Oracle 11g New Features

by: Vinod Sadanandan | last post by:

All, Below listed are the new features in Oracle 11g ,please join me in this discussion to generate a testcase and analyze each of the listed features . Precompilers: Additional Array INSERT and SELECT Syntax Support by Pro*C/C++ and Pro*COBOL Precompilers: Dynamic SQL Statement Caching in Pro*C/C++ and Pro*COBOL Precompilers: Fix Execution Plan in Pro*C/C++ and Pro*COBOL Precompilers: Flexible B Area Length...

Oracle Database

3556

Please point us on installing Oracle 9.2 on FreeBSD

by: Ruslan A Dautkhanov | last post by:

Hello ! I'm about to install O9i on FreeBSD box. uname -a: FreeBSD stat2.scn.ru 5.2.1-RELEASE-p3 FreeBSD 5.2.1-RELEASE-p3 #2: Fri Apr 23 19:19:43 KRAST 2004 rd@stat2.scn.ru:/usr/src/sys/i386/compile/RDSTAT2-ORACLE i386 uname -a under oracle user : Linux stat2.scn.ru 2.4.2 FreeBSD 5.2.1-RELEASE-p3 #2: Fri Apr 23 19:19:43 KRAST 2004 i686 unknown

Oracle Database

3309

LogiXML BI - Oracle Database

by: Jack | last post by:

Training Classes for Oracle10g, 9i, 8i Certification training in Oracle10g and 9i: DBA, Developer, Discoverer. training conducted at your location worldwide. Courseware licensing also available. http://a.uuload.com/Oracle-Database.htm Unlock the Value of Your IT System Confio Software's Ignite for Oracle uses wait-event analysis to improve database performance by 65% or more. Gain visibility of every Oracle wait event. Download free...

.NET Framework

3282

Oracle Database Training, Practice Tests

by: Winder | last post by:

DB2 Database

4630

Not able to open test.fmx in oracle application server 10gR2

by: sathyguy | last post by:

when i type the below in my RHEL AS 4's Firefox 1.5 http://appsworld.ncc.com:7777/forms/...&form=test.fmx iam getting the below error... The requested URL /forms/frmservlet was not found on this server. formsweb.cfg contents...... baseHTML=/u01/app/oracle/OraHome_1/forms/server/base.htm

Oracle Database

8174

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8618

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8568

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8423

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6083

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5537

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

2558

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1699

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1417

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General