Re: Networking with Personal Oracle

On Mon, 16 Nov 1998 18:20:27 +0100, bdickey_at_my-dejanews.com wrote:

>I'm trying to connect a package called Business Objects to a Personal Oracle
>database, using SQL*Net 2.2. The Business Objects database connection dialog
>box asks for Username, Password, and Database. I'm connecting to the default
>database that is supplied with Personal Oracle 7.2, where the username is
>"scott" and the Password is "tiger". I don't know what to enter for the
>Database parameter, so I'm leaving it blank. Business Objects help indicates
>that this Database parameter means hostname, server, and database as a
>connection string. The Oracle Personal database starts, but then I get
>message ORA-01017: "Invalid username/password. Logon denied." Does anyone
>have any ideas how I could establish this connection or create a connection
>string? Do I need a real Oracle server? Business Objects allows either
>SQL*Net or ODBC as driver choices. Thanks for your help
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

You could try 2: as the Database (connect string) field. I think that Personal Oracle 7.2 used this to imply connecting to the local database... But you may need to start the database manually.

Hang on - you say Business Objects is using SQL*Net - that implies that it needs to connect remotely, something which Personal Oracle doesn't support (I think network support exists in Personal Oracle (or whatever they call it now) from version 8 on, but not in version 7). So that may not work...

ODBC, as far as I am aware, runs across SQL*Net, too.

All of this sort of thing *should* be possible, but I never had much confidence in Personal Oracle prior to version 8. It all seemed harder than it needed to be (which you seem to be finding out :-)

Hope some of this helps...

Paul Moore.

Paul. Received on Thu Nov 19 1998 - 09:55:18 CST