ok this is embarrassing

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 - 12:05:48 CST