Re: ok this is embarrassing

Try the default passwords for Oracle:

User: SYSTEM
Password: manager

User: SYS
Password: change_on_install

I find that 50% - 60% of shops still have one of these users set to the default. If that doesn't work, you can try logging locally to the server that houses the Oracle Database and connecting to Oracle in this fashion:

For 8i:

sqlplus /nolog
connect internal

For 8 and below:

Unix:
svrmgrl
connect internal

Windows:
svrmgr30
connect internal

After you get in, you can create a user with the proper access.

<ccasano_at_my-deja.com> wrote in message news:91qsdm$cj6$1_at_nnrp1.deja.com...
> i'm the access person and i'm trying to set up our ODBC on a windows
> 2000 server.
>
> 1. at the end of running the ODBC sources program i'm presented a
> dialog box with these questions:
>
> - Username:
> - Password:
> - Server:
>
> however our ORACLE dba is no longer around and i don't know the answers
> to these questions. is there an easy way to find this info out from
> snooping around on the Oracle Server? (unfortunately there's no as
> email mailback option as there is online when you forget a password!)
>
> i mean access is somehow getting past to security to read the oracle
> data - there is this line that apparently runs when the menu main form
> is opened.
>
> Connect = "ODBC;DATABASE=FRANK;UID=;PWD=;DSN=FRANK2"
>
> (i've changed the names to protect the innocent)
>
> but this suggests there's no username or password(?) and it seems to
> me i've gotten into oracle without this line.
>
> 2. also i assume i want it to set this up as a File DSN? i want all
> workstations to use it
>
> btw i'm connecting Access to Oracle through this ODBC
>
> thanks for any ideas
>
> - cg
>
> ===
>
> seemp
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Wed Dec 20 2000 - 15:10:45 CST