Re: ok this is embarrassing

thanks for your help. we have solved the problem, at least for now. we had set up a "User DSN" and not a "File DSN". The file DSN apparently draws on user windows login info or something, so it now works

In article <3a41217a$0$151_at_wodc7nh7.news.uu.net>,   "Jason Hiller" <jason.hiller_at_osage.com> wrote:
> 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/
>
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Dec 21 2000 - 11:57:08 CST