[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Access linked via ODBC to Oracle

Posted on 2004-11-12
2
Medium Priority
?
276 Views
Last Modified: 2008-03-06
Hey fellas,

Ok I have an Access database connected via ODBC to an Oracle database. 99.9 sure that the ODBC is Oracle b/c it says so in the ODBC administrator,
and it says its an Oracle8 ODBC.

When I open up the table in design view and go to properties I see this

ODBC;DSN=EPSPRD1;DBQ=EPSPRD1;DBA=W;APA=T;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;FRL=F;MTS=F;CSR=F;PFC=10;TLO=0;;TABLE=TRU_CMP.VALIDTRANSACTION


?Can somebody give me a breakdown of what each part means above & what the acronyms stand for?
I know DSN=Data Source Name & EPSPRD1 is my database's name but would like to know the others

?What does the double semicolons  ;;  do towards the end before table?

I am wanting to automate my user name and password so that it will not have to entered all the time so any help on that would be great also.

thx ken


0
Comment
Question by:kengi2
  • 2
2 Comments
 
LVL 1

Accepted Solution

by:
frukio earned 2000 total points
ID: 12569845
This should tell you everything you need to know (except perhaps what the double semi-colon indicates, if anything)

http://www.oracle.com/technology/docs/tech/windows/odbc/htdocs/817help/sqoraFormat_of_the_Connection_String_.htm
0
 
LVL 1

Expert Comment

by:frukio
ID: 12569928
Basically, you should be able to use
ODBC;DSN=EPSPRD1;DBQ=EPSPRD1;UID=your_user_name;PWD=your_password

You may also need to keep the TABLE=TRU_CMP.VALIDTRANSACTION

The others you can take out of the string if you want to since they are all set to the defaults.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question