Hi, I'm very new to Oracle and I've just installed Oracle Server on my computer and also set up a database.
I'm trying to set up Oracle such that I can link tables from Access or access it using ADODB. I'm not sure how to set up/create services on the listener so that I can do this....I have tried to change the listener.ora and the sqlnet.ora files, but it still doesn't work.
I was wondering what values in the files do I have to change to set up a new service?
in my tnsnames.ora file, I can access my database in SQL*Plus through this entry (made automatically when connecting through DBAStudio):
Also for your ODBC driver.... If you are using Oracle 184.108.40.206 or .1
there was a problem with it... You need to download Oracle ODBC 220.127.116.11 or .5 .... The problems were fixed there... Go to METALINK
and get the download ... They are a little over a meg zipped.... Unzip the file and run the exe ... It will place files so that you can run the Oracle installer again and load the new ODBC Drivers...
I changed my listener.ora and I am able to access the db in Excel and Access. But the tables that I want are missing from the list. The ones that are in it are $AURORA$JIS$UTILITY$.SNS$PERMISSIONS$, PUBLIC.SYN, etc...
From DBA Studio, I can see my tables under the Schema/Table/SYSTEM.
Is there something I should configure so I can see my tables in the list?
Did you install the "newer" ODBC drivers ??? If so, delete all DSN's and create 1 under system using 18.104.22.168 or better ODBC drivers.
Under the ODBC setup ... Are you using the same username/password
that the tables are created under (same schema name)??? If not,
then on the Oracle side, grant SELECT to ODBC_USERNAME on
your tables ...