| Urgent help needed: Connecting MS Access from Developer 6i [message #81949] |
Thu, 03 April 2003 06:29  |
Serdar Oktem
Messages: 4
Registered: September 2002
|
Junior Member |
|
|
Dear friends,
I am really struggling to solve this connection issue. I am working with forms 6i, oracle 8i, in Windows XP pro environment. Developing programs using oracle 8i tables is ok, but there are tables in Access 2000, which I have to add the program that I am developing. The things I have done are
- I have already tables in MS Access databse.
- I Installed ODBC for microsoft and for Oracle as well(which . I added the MS Access Database there and I can perfom SQL from Oracle ODBC.
- I also installed OCA for developer from the CD.
From this point I followed the instructions in Developer Help menu and I was not able to connect and still trying, I will appreciate if anyone provide me sometips. Thanks in advance
Best Regards
|
|
|
|
| Re: Urgent help needed: Connecting MS Access from Developer 6i [message #81995 is a reply to message #81949] |
Tue, 08 April 2003 09:27  |
shadow
Messages: 15
Registered: April 2003
|
Junior Member |
|
|
CSIS4490/02 - Connecting MS-ACCESS to ORACLE
For ORACLE/FORMS (Developer/2000), you only need to do step 1, below.
1) ORACLE's SQL NET EASY CONFIG (Windows software usually distributed with Oracle enterprise manager)
Set up an alias for your DATABASE
Database Alias (Net Service Name): CSIS // could be any name you want
Protocol: TCP/IP
Host Name: unicoi.kennesaw.edu
Database Instance (Database SID or Service Name): CSIS // must be CSIS
2) Set up ODBC connection with
You must set up your ODBC connection with MS-ODBC Driver for Oracle or Oracle ODBC Data Source Administrator
Choose System DSN Panel Button
// open to all users who login to the machine
// User DSN is login specific
ADD Button
Select Microsoft ODBC Driver for ORACLE or
Oracle ODBC Driver
Finish
Data Source Name: CSIS // call anything
Description: Oracle on Unicoi //not important, comment
User Name: Your Oracle userid
Connect_String(or Server or Service Name): CSIS //name of database alias
or Net Service Name that you gave in item 1
3) call MS-ACCESS (golden key)
4) Go to File Menu
External Data
Link
Brings up a menu
Type ODBC for file type
Select Data Source WIndow appears
Click on machine data source tab on top of page
Select CSIS and hit okay
Type oracle user id/login
Click on Tables you want to link.
Obs.: if you want to be able to update the tables you link
To, you must select a primary key
OBS: FOR VISUAL BASIC, you can only connect it to ORACLE through MS-ACCESS
(go to connect).
VISUAL BASIC 6.0 Enterprise Edition or BORLAND DELPHI 3.0 or above may connect directly
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
