Connecting to Oracle 7.2/7.3 with PB5 & SQL*Net 2.3
We are currently developing with PB 5.0.02, Oracle 7.2, SQL*Net 2.2 (32 bit), and Win 95. This setup is also our typical client platform. We will soon be going to Oracle 7.3. Before that happens we'll be trying SQL*Net 2.3 with Oracle 7.2. 1) Has anyone encountered any substantial problems with PB 5.0.02 with SQL*Net 2.3 and Oracle 7.2? 2) Does anyone have any information to pass along about PB 5.0.02 and Oracle 7.3 but using the native Oracle 7.2 driver? (I work at a fairly large firm, i.e. lots of testing involved, and I doubt we'll be going to PB 5.0.03 before we go to Oracle 7.3). Thanks in advance!
|
0 |
|
Bill
7/1/1997 9:09:12 PM
sybase.powerbuilder.connection
3893 articles. 
0 followers.
3 Replies
745 Views
Bill Mitchell wrote: > > We are currently developing with PB 5.0.02, Oracle 7.2, SQL*Net 2.2 (32 > bit), and Win 95. This setup is also our typical client platform. We will > soon be going to Oracle 7.3. Before that happens we'll be trying SQL*Net > 2.3 with Oracle 7.2. > > 1) Has anyone encountered any substantial problems with PB 5.0.02 with > SQL*Net 2.3 and Oracle 7.2? > 2) Does anyone have any information to pass along about PB 5.0.02 and > Oracle 7.3 but using the native Oracle 7.2 driver? (I work at a fairly > large firm, i.e. lots of testing involved, and I doubt we'll be going to PB > 5.0.03 before we go to Oracle 7.3). > > Thanks in advance! Bill, I worked on a large app at a hospital about six months ago where we started with Oracle 7.2 and PB 5.0.01. Eventually, we upgraded to 5.0.02, SQL*Net 2.3 and stayed with Oracle 7.2 because they didn't have 7.3 ready for NT yet. We did not experience any PB related problems once we got SQL*Net installed properly. As per usual with Oracle, get rid of SQL*Net 2.2 BEFORE doing the upgrade if you want things to go smoothly. A friend of mine has written an OracleTrack system to monitor the db in 5.0.02 and I'm pretty sure he's hitting 7.3 db's with it. I'll double check Monday to be sure unless someone else responds first. -- Billy Bosworth bbosworth@ka.net http://www.ka.net/bbosworth
|
|
0 |
|
Billy
7/4/1997 3:27:27 PM
Billy Bosworth wrote: > > Bill Mitchell wrote: > > > > We are currently developing with PB 5.0.02, Oracle 7.2, SQL*Net 2.2 (32 > > bit), and Win 95. This setup is also our typical client platform. We will > > soon be going to Oracle 7.3. Before that happens we'll be trying SQL*Net > > 2.3 with Oracle 7.2. > > > > 1) Has anyone encountered any substantial problems with PB 5.0.02 with > > SQL*Net 2.3 and Oracle 7.2? > > 2) Does anyone have any information to pass along about PB 5.0.02 and > > Oracle 7.3 but using the native Oracle 7.2 driver? (I work at a fairly > > large firm, i.e. lots of testing involved, and I doubt we'll be going to PB > > 5.0.03 before we go to Oracle 7.3). > > > > Thanks in advance! > > Bill, > > I worked on a large app at a hospital about six months ago where we > started with Oracle 7.2 and PB 5.0.01. Eventually, we upgraded to > 5.0.02, SQL*Net 2.3 and stayed with Oracle 7.2 because they didn't have > 7.3 ready for NT yet. We did not experience any PB related problems > once we got SQL*Net installed properly. As per usual with Oracle, get > rid of SQL*Net 2.2 BEFORE doing the upgrade if you want things to go > smoothly. > > A friend of mine has written an OracleTrack system to monitor the db in > 5.0.02 and I'm pretty sure he's hitting 7.3 db's with it. I'll double > check Monday to be sure unless someone else responds first. > > -- > Billy Bosworth > bbosworth@ka.net > http://www.ka.net/bbosworth Bill, I checked here at work and my partner is connecting to 7.2 and 7.3 with SQL*Net 2.3 and PB 5.0.02. He cited no glaring issues to watch for. -- Billy Bosworth bbosworth@ka.net http://www.ka.net/bbosworth
|
|
0 |
|
Billy
7/7/1997 6:47:47 PM
Bill Mitchell wrote:
> We are currently developing with PB 5.0.02, Oracle 7.2, SQL*Net 2.2
> (32
> bit), and Win 95. This setup is also our typical client platform. We
> will
> soon be going to Oracle 7.3. Before that happens we'll be trying
> SQL*Net
> 2.3 with Oracle 7.2.
>
> 1) Has anyone encountered any substantial problems with PB 5.0.02 with
>
> SQL*Net 2.3 and Oracle 7.2?
> 2) Does anyone have any information to pass along about PB 5.0.02 and
> Oracle 7.3 but using the native Oracle 7.2 driver? (I work at a fairly
>
> large firm, i.e. lots of testing involved, and I doubt we'll be going
> to PB
> 5.0.03 before we go to Oracle 7.3).
>
> Thanks in advance!
We developed an application with this configuration, and found no
problems with connecting issues. The only problem was with Stored
Procedures and Datawindows. We could not get both to work at the same
time. It was necessary to create a physical data table, fill it up with
stored procedure and then read this table with datawindow.
Maybe you get better luck.
[]'s
Diego Hulse
------------
Develop Informatica
info@develop.com.br
http://www.develop.com.br
|
|
0 |
|
Develop
7/9/1997 7:17:43 PM
Similar Artilces:
[ANN] Release of Bugzilla 3.2.1, 3.0.7, 2.22.7, and 3.3.2
Today we have some major security improvements for Bugzilla in the form of four releases. We strongly recommend that all Bugzilla administrators read the Security Advisory for these releases, which is linked below in this email. Bugzilla 3.2.1 is our latest stable release. It contains various useful bug fixes in addition to major security improvements. Bugzilla 3.0.7 and Bugzilla 2.22.7 are security updates for their branches. Bugzilla 3.3.2 is an unstable development release. In addition to the security fixes that all the other releases contain, this release contains n...
[ANN] Security Advisory for Bugzilla 3.2.7, 3.4.7, 3.6.1, and 3.7.2
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Summary ======= Bugzilla is a Web-based bug-tracking system used by a large number of software projects. The following security issues have been discovered in Bugzilla: * It was possible to (at least partially) determine the membership of any group using the Search interface. * It was possible to use the 'sudo' feature without sending a notification to the user being impersonated. * The 'Reports' and 'Duplicates' pages let you guess the name of products you could not see, due to the error message ...
Connecting PB 7 to Oracle 7.3 #2
Hi I have a problem in connecting PB 7 to Oracle 7.3 database which is located in Denver and I am at NewYork. I get the following message when I try to connect "Please connect as the PowerBuilder Catalog Owner. This is necessary for the Initial connection to Oracle to GRANT priviliges on the repository". I give you below the connection information : // Profile prod SQLCA.DBMS = "O73 ORACLE 7.3" SQLCA.LogPass = <*****> SQLCA.ServerName = "@tns:pmprod" SQLCA.LogId = "admin" SQLCA.AutoCommit = False SQLCA.DBParm = "" I ...
Connecting PB 5.0 to Oracle 7.3.2.2.0
Hi Everyone, Would anybody help me figure out this problem? When trying to connect to the Oracle 7.3.2.2.0 database from PowerBuilder 5.0 (Windows NT 4.0) using the database profile I set up, I got the following error message: ORA-01031:Insufficient Privileges The database profile in PowerBuilder is set up as follows: Profile Name : Connect_DB (i.e any name) DBMS : 071 ORACLE v7.1 UserID : (i.e blank because they are not applicable) Password : ( " ) Data...
Connecting PB 7 to Oracle 7.3 #3
Hi I have a problem ...
PB5.0 Connectivity with Oracle 7.1 for Solaris 2.3
Hi , I am trying to connect PB5.0 on Win NT 4.0 with Oracle 7.1 for Solaris 2.3 using Native Drivers. When I am using an embedded SQL Select Statement , I am getting the following error: ORA-01006: Bind Variable does not exist. Could u help me ASAP Thanks and Regards. Amit Mail me at amita@mindware.soft.net Hi, Have you tried installing the latest version the sqlnet dlls from Oracle. You can also use DisableBind=1 in the dbParm of your transaction object before you connect. HTH -- - Met vriendelijke groet, Eric Aling [TeamPS], Cypres Informatisering bv, ...
[ANN] Release of Bugzilla 3.2.7, 3.4.7, 3.6.1, and 3.7.1
Today we have four new releases! One new development snapshot (3.7.1), two new stable releases (3.6.1 and 3.4.7) and one update for the legacy 3.2 branch (3.2.7). Bugzilla 3.6.1 is our latest stable release. It contains some significant bug fixes for the 3.6 branch. Bugzilla 3.4.7 is the last bug-fix release for the 3.4 series. After this, there will only be additional 3.4 releases if there are security issues discovered in the 3.4 series. Bugzilla 3.2.7 is a security update for the 3.2 branch. Bugzilla 3.7.1 is our first unstable development release on the road to ...
Connecting to Oracle 7.3 #2
Hello, Anybody!? My friend have trying to connect to Oracle 7.3 with ODBC, it is OK but when he connected with native driver and then he configure it, the driver is not in the DBMS list. What could be wrong anyway?!! Can anybody help me?? Anyhelp will be appreciated. Environment: - Windows 95 - PB 5.0 Best Regards, Mulyani Matrix@cbn.net.id You need to open the PB.INI file, find the VENDORS line and add the following to the end: ,O73 ORACLE V7.3 Andy Kurtz Matrix, You can type it yourself either: OR7 (the driver taken is pbor7050.dll) (I am using this one i...
[ANN] Release of Bugzilla 3.2.8, 3.4.8, 3.6.2, and 3.7.3
Today we have four new releases. One new development snapshot (3.7.3), one new stable release (3.6.2) and two security updates for the old stable releases (3.4.8 and 3.2.8). Bugzilla 3.6.2 is our latest stable release. It contains various useful bug fixes and security improvements for the 3.6 branch. Bugzilla 3.4.8 and 3.2.8 are security updates for the 3.4 branch and the 3.2 branch, respectively. Bugzilla 3.7.3 is our third unstable development release leading to Bugzilla 4.0. We have done a fair amount of QA on this release. However, QA found many bugs that have not ye...
[ANN] Security Advisory for Bugzilla 3.2.8, 3.4.8, 3.6.2, and 3.7.3
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Summary ======= Bugzilla is a Web-based bug-tracking system used by a large number of software projects. The following security issues have been discovered in Bugzilla: * There is a way to inject both headers and content to users, causing a serious Cross-Site Scripting vulnerability. * It was possible to see graphs from Old Charts even if you did not have access to a particular product, and you could browse a particular URL to see all product names. * YUI 2.8.1, which shipped with Bugzilla starting with 3.7.x, contain...
[ANN] Security Advisory for Bugzilla 3.2.1, 3.3.2, and 3.0.7
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Summary ======= Bugzilla is a Web-based bug-tracking system, used by a large number of software projects. Bugzilla 3.2.1, 3.0.7, and 3.3.2, when running under mod_perl, generated insufficiently random numbers, resulting in all random tokens being the same, all CSRF protection being defeated, and the new attachment_base functionality being compromised. Only these releases were affected--earlier releases are not affected. All affected installations are encouraged to upgrade as soon as possible. Vulnerability Details =========...
Connecting to Packages in Oracle 7.3.2
I am having a problem with powerbuilder recognizing stored procedures that have been created in a package. When I created the procedures individually powerbuilder had no problem finding them and using them, but when I removed the procedures and put them in a package powerbuilder cannot see them. I could not find any reference to packages in the help menu. Does powerbuilder support packages and if so how do I access them? Thank you in advance, Christopher Foutz Hi, Yes, PB does support that. You must dec...
VMware player 3 & PlayonLinux 3.7.2 Work 11.2!
Just A Quick Announcement for two Applications that are not installable through the software manager at this time. They are both working in Opensuse 11.2. Vmware player 3 installed and played a 7 vm. Playonlinux is a little tougher to get going but it works great once you have its dependencies installed. Here is a link to the playonlinux 3.7.2 howto for 11.2. 'Howto for Playonlinux' (http://tinyurl.com/ycbh2hm) -- J100 ------------------------------------------------------------------------ ...
pb5.0.01 connect to personal oracle 7.3.3
Hi, everybody: I try to connect pb5.0.01 to personal Oracle 7.3.3. When I use powerbuilder's native driver O72, Oracle support file 7.2x, and server set at @2:ORCL. I get connection, But oracle stored procedure return nothing.( I use package and procedure method, and only one return set, datawindow can see all the columns in return set but no return result. I use PB6.0 with O73 native driver to same procedure, I get result without any problem). I also try to download pb5.0.02 matainance release to get O73 native driver( I can not find matainance release for pb5.0.01), try manu...
Today we have some major security improvements for Bugzilla in the form of four releases. We strongly recommend that all Bugzilla administrators read the Security Advisory for these releases, which is linked below in this email. Bugzilla 3.2.1 is our latest stable release. It contains various useful bug fixes in addition to major security improvements. Bugzilla 3.0.7 and Bugzilla 2.22.7 are security updates for their branches. Bugzilla 3.3.2 is an unstable development release. In addition to the security fixes that all the other releases contain, this release contains n...
[ANN] Security Advisory for Bugzilla 3.2.7, 3.4.7, 3.6.1, and 3.7.2
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Summary ======= Bugzilla is a Web-based bug-tracking system used by a large number of software projects. The following security issues have been discovered in Bugzilla: * It was possible to (at least partially) determine the membership of any group using the Search interface. * It was possible to use the 'sudo' feature without sending a notification to the user being impersonated. * The 'Reports' and 'Duplicates' pages let you guess the name of products you could not see, due to the error message ...
Connecting PB 7 to Oracle 7.3 #2
Hi I have a problem in connecting PB 7 to Oracle 7.3 database which is located in Denver and I am at NewYork. I get the following message when I try to connect "Please connect as the PowerBuilder Catalog Owner. This is necessary for the Initial connection to Oracle to GRANT priviliges on the repository". I give you below the connection information : // Profile prod SQLCA.DBMS = "O73 ORACLE 7.3" SQLCA.LogPass = <*****> SQLCA.ServerName = "@tns:pmprod" SQLCA.LogId = "admin" SQLCA.AutoCommit = False SQLCA.DBParm = "" I ...
Connecting PB 5.0 to Oracle 7.3.2.2.0
Hi Everyone, Would anybody help me figure out this problem? When trying to connect to the Oracle 7.3.2.2.0 database from PowerBuilder 5.0 (Windows NT 4.0) using the database profile I set up, I got the following error message: ORA-01031:Insufficient Privileges The database profile in PowerBuilder is set up as follows: Profile Name : Connect_DB (i.e any name) DBMS : 071 ORACLE v7.1 UserID : (i.e blank because they are not applicable) Password : ( " ) Data...
Connecting PB 7 to Oracle 7.3 #3
Hi I have a problem ...
PB5.0 Connectivity with Oracle 7.1 for Solaris 2.3
Hi , I am trying to connect PB5.0 on Win NT 4.0 with Oracle 7.1 for Solaris 2.3 using Native Drivers. When I am using an embedded SQL Select Statement , I am getting the following error: ORA-01006: Bind Variable does not exist. Could u help me ASAP Thanks and Regards. Amit Mail me at amita@mindware.soft.net Hi, Have you tried installing the latest version the sqlnet dlls from Oracle. You can also use DisableBind=1 in the dbParm of your transaction object before you connect. HTH -- - Met vriendelijke groet, Eric Aling [TeamPS], Cypres Informatisering bv, ...
[ANN] Release of Bugzilla 3.2.7, 3.4.7, 3.6.1, and 3.7.1
Today we have four new releases! One new development snapshot (3.7.1), two new stable releases (3.6.1 and 3.4.7) and one update for the legacy 3.2 branch (3.2.7). Bugzilla 3.6.1 is our latest stable release. It contains some significant bug fixes for the 3.6 branch. Bugzilla 3.4.7 is the last bug-fix release for the 3.4 series. After this, there will only be additional 3.4 releases if there are security issues discovered in the 3.4 series. Bugzilla 3.2.7 is a security update for the 3.2 branch. Bugzilla 3.7.1 is our first unstable development release on the road to ...
Connecting to Oracle 7.3 #2
Hello, Anybody!? My friend have trying to connect to Oracle 7.3 with ODBC, it is OK but when he connected with native driver and then he configure it, the driver is not in the DBMS list. What could be wrong anyway?!! Can anybody help me?? Anyhelp will be appreciated. Environment: - Windows 95 - PB 5.0 Best Regards, Mulyani Matrix@cbn.net.id You need to open the PB.INI file, find the VENDORS line and add the following to the end: ,O73 ORACLE V7.3 Andy Kurtz Matrix, You can type it yourself either: OR7 (the driver taken is pbor7050.dll) (I am using this one i...
[ANN] Release of Bugzilla 3.2.8, 3.4.8, 3.6.2, and 3.7.3
Today we have four new releases. One new development snapshot (3.7.3), one new stable release (3.6.2) and two security updates for the old stable releases (3.4.8 and 3.2.8). Bugzilla 3.6.2 is our latest stable release. It contains various useful bug fixes and security improvements for the 3.6 branch. Bugzilla 3.4.8 and 3.2.8 are security updates for the 3.4 branch and the 3.2 branch, respectively. Bugzilla 3.7.3 is our third unstable development release leading to Bugzilla 4.0. We have done a fair amount of QA on this release. However, QA found many bugs that have not ye...
[ANN] Security Advisory for Bugzilla 3.2.8, 3.4.8, 3.6.2, and 3.7.3
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Summary ======= Bugzilla is a Web-based bug-tracking system used by a large number of software projects. The following security issues have been discovered in Bugzilla: * There is a way to inject both headers and content to users, causing a serious Cross-Site Scripting vulnerability. * It was possible to see graphs from Old Charts even if you did not have access to a particular product, and you could browse a particular URL to see all product names. * YUI 2.8.1, which shipped with Bugzilla starting with 3.7.x, contain...
[ANN] Security Advisory for Bugzilla 3.2.1, 3.3.2, and 3.0.7
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Summary ======= Bugzilla is a Web-based bug-tracking system, used by a large number of software projects. Bugzilla 3.2.1, 3.0.7, and 3.3.2, when running under mod_perl, generated insufficiently random numbers, resulting in all random tokens being the same, all CSRF protection being defeated, and the new attachment_base functionality being compromised. Only these releases were affected--earlier releases are not affected. All affected installations are encouraged to upgrade as soon as possible. Vulnerability Details =========...
Connecting to Packages in Oracle 7.3.2
I am having a problem with powerbuilder recognizing stored procedures that have been created in a package. When I created the procedures individually powerbuilder had no problem finding them and using them, but when I removed the procedures and put them in a package powerbuilder cannot see them. I could not find any reference to packages in the help menu. Does powerbuilder support packages and if so how do I access them? Thank you in advance, Christopher Foutz Hi, Yes, PB does support that. You must dec...
VMware player 3 & PlayonLinux 3.7.2 Work 11.2!
Just A Quick Announcement for two Applications that are not installable through the software manager at this time. They are both working in Opensuse 11.2. Vmware player 3 installed and played a 7 vm. Playonlinux is a little tougher to get going but it works great once you have its dependencies installed. Here is a link to the playonlinux 3.7.2 howto for 11.2. 'Howto for Playonlinux' (http://tinyurl.com/ycbh2hm) -- J100 ------------------------------------------------------------------------ ...
pb5.0.01 connect to personal oracle 7.3.3
Hi, everybody: I try to connect pb5.0.01 to personal Oracle 7.3.3. When I use powerbuilder's native driver O72, Oracle support file 7.2x, and server set at @2:ORCL. I get connection, But oracle stored procedure return nothing.( I use package and procedure method, and only one return set, datawindow can see all the columns in return set but no return result. I use PB6.0 with O73 native driver to same procedure, I get result without any problem). I also try to download pb5.0.02 matainance release to get O73 native driver( I can not find matainance release for pb5.0.01), try manu...
Web resources about - Connecting to Oracle 7.2/7.3 with PB5 & SQL*Net 2.3 - sybase.powerbuilder.connection
List of Nebraska Connecting Link, Spur, and Recreation Highways - Wikipedia, the free encyclopediaNebraska Connecting Link , Nebraska Spur , and Nebraska Recreation Road highways are a secondary part of the Nebraska highway system . They connect ...
Israeli Hotel U Coral Beach Club Eilat Has a Unique Way of Connecting Guests to FacebookU Coral Beach Club Eilat, a hotel in Israel , is taking sharing vacation photos and checking in to the next level thanks to a collaboration between ...
Digital Media Wire - connecting people & knowledge —dmwnews : Anomaly, the ambitious graphic novel by Brittenham and Haberlin, features augmented reality. http://bit.ly/Iwrxjr Already optioned ...
Connecting 100 Million People in Africa„Facebook for Business“ liefert dir aktuelle Nachrichten, Tipps und Best Practices für den Einsatz von Facebook zur Erreichung deiner Unternehmensziele: ...
What stops users from connecting with an app through Facebook?... This equals 850 million users who connect with apps using Facebook at a 59 percent conversion rate. About 590 million users back out of connecting ...
Home - WHLT 22 Connecting the Pine Belt FanFacebook is a social utility that connects people with friends and others who work, study and live around them. People use Facebook to keep up ...
US IT Staffing Recruiters Group - Connecting Ideas !US IT Recruiter's Groups: IT Technical Recruitment. Its all about connecting to new Ideas !
Jewel Dots Puzzler - A Cool Connecting Dots Puzzle For Kids on the App Store on iTunesGet Jewel Dots Puzzler - A Cool Connecting Dots Puzzle For Kids on the App Store. See screenshots and ratings, and read customer reviews.
Connecting the community, my Twitter strategy, and American Airlines at DFW - Flickr - Photo Sharing ...I thought, to commemorate this entry on connecting people, that I'd include a photo of an airplane from one of the busiest airports in the world ...
Connecting to Community Graduation YouTube 1080p - YouTube(Sioux Falls, S.D.) Forty-six seniors have graduated from trying to find the power button to now being avid e-mail, Facebook, Pinterest and Tumblr ...
Resources last updated: 11/27/2015 10:12:46 AM