Re: ok this is embarrassing

ccasano_at_my-deja.com wrote:

> 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
>

In your connect line by omitting the UID and PWD you are telling the odbc mechanism that you want to be prompted to for information. If you already know what it is you can put it right in the connect statement. Received on Wed Dec 20 2000 - 13:47:01 CST