In article <36553d54.24020317_at_news.origin-it.com>,
paul.moore_at_uk.origin-it.com (Paul Moore) wrote:
> 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.
>
>
Thanks, Paul. I tried the 2: and it worked.
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Nov 19 1998 - 13:19:07 CST
