Sql to Access question

[Guest_imported]

I'm trying to open a Oracle 8i table in access....My host and cleint machine are on the same CPU...When I first loaded Oracle and tried to start the database I got a no listner error...I figured this was due to having the host/cleint on the same machine. I can log into Oracle with the error(I don't even start the listner any more) and create my tables but i'm triying to figure out how to get them MS Access....I'm connected to a LAN but that should not matter since the my machine is both hostand cleint???? When I try to open a table I get the no listner error I'm not even sure I'm doing the right steps....Does anybody have any info....Thanks..

 

[lfoata]

You have the modify the listener.ora file to include your instance and then start the listener. You can test your listener setup by using the utility tnsping or tnsping80 depending if you are using dqlnet v2 or net8.
Then you have to install the ODBC for oracle (on the oracle CD) and set it up. Then Ms Access should be able to access the database. Too bad I.T. is not cash business

Luc Foata
Unix sysadmin, Oracle DBA