Does Powerbuilder 7.0.3 allow connection to the Oracle 9i

Posted on 2005-03-07
Medium Priority
Last Modified: 2013-12-26
Right now I'm using with PowerBuilder7.0.3 Version and I'm trying to get the information thru Oracle  Here my connection is successful thru ODBC, but i'm not able to connect thru Oracle9 database. Can you give the suggesion if you know. In database profile pb7 is supporting upto Oracle8. How can I install Oracle 9i patch.

Question by:venkat4sv
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 13481837

I'm using 7.0.3 with Oracle 9.2 and it is fine. Are you using the Powerbuilder desktop product? I think that only comes with ODBC to the older version of oracle. There are free patches on the Sybase website which may help also. Try this http://www.sybase.com/downloads

Hope that helps
LVL 18

Expert Comment

ID: 13483761

i thought PB7 does not support Oracle 9i.. but as maran says hes using it then im sure its does support...
in that case u need to try downloading the latest build of PB 7 and apply the patch and check if u can connect to Oracle 9i...
the procedure is as follows for ur referal...

go to www.sybase.com

---> go to the download option
---> in the download page there is a link EBFs/Maintenance
---> u will be asked to register once u go to that link....
---> register onto sybase(this will help in future)
---> there will be a selection of time frame...select 'all'
---> now when u search u will find build  10312 for PB 7
---> Download it (its 34 MB!)

Install this patch and many of ur issues will be solved...

also refer...  http://www.sybase.com/detail?id=1011566


LVL 33

Accepted Solution

sajuks earned 375 total points
ID: 13494180
Use the O84 driver --pbo8470.dll for connecting to oracle from pb. Sybase does support oracle from powerbuilder 7.0.3 onwards but we've also faced some problems in the past. Using the O84 driver drivers allowed us to work without any problem

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.
Suggested Courses
Course of the Month9 days, 19 hours left to enroll

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question