Modifying a Connection

security Supervisor (4.x - 6.x)
1

Hi!

We are using BO 4.1.2, Oracle 8 and SQL*NET 2.3

We are experiencing some problems with running Oracle (on different nodes) and using SQL*NET 2.3. We would like to upgrade all of the BO connections to NET 8 connections. We can successfully create a new BOMain.key file using NET 8 and connect to our current repo. We can successfully change the connect string inside of the universe to be a NET 8 connect string to get to the data. But what we don’t seem to be able to do is modify the connections between the security domain and the document and universe domains. Our procedure is this:

  1. Using the NET 8 bomain.key, log into supervisor module as the General Supervisor.
  2. Under Tools, Repository, select one of the connections to modify. 3) Click on the modify button.
  3. Select Net8 client as the network layer, and click on the setup button. 5) Enter the user id, password and database name. Click on the test button, and we get the server is responding. But when we get back to the Repository panel, the connection has not been modified. ( We tried it on another PC with less than favorable results. The action of testing created a DR Watson error!)

So, the questions are:

  1. Can you really modify a connection?
  2. Is this a bug in version 4.1.2?
  3. How would you update your connections without rebuilding your repository (i.e. when you update your DB from Oracle 7 to Oracle 8)?

Thanks,
Sandy Brotje
Roadway Express

Listserv Archives (BOB member since 2002-06-25)

2

FYI — Follow up to my original message:

At 03:41 PM 9/11/98 -0400, you wrote:

We can successfully create a new BOMain.key file using NET 8 and connect to our current repo. We can successfully change the connect string inside of the universe to be a NET 8 connect string to get to the data. But what we don’t seem to be able to do is modify the connections between the security domain and the document and universe domains.

We were using 4.1.2. Seems there is a bug in that version. We upgraded one PC to 4.1.3, that also had NET 8 on it and we could successfully modify the connection between the security domain and the document and universe domains. Yeah! Thanks for all of the responses!

Sandy Brotje
Roadway Express

BUSOB-L-Request@listserv.aol.com

For old 3.1 info: Penn: Page not found
Search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’ Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’

Listserv Archives (BOB member since 2002-06-25)