How to connect to the Oracle server from Microsoft Access

  • Thread starter Thread starter James
  • Start date Start date
J

James

I'm using Access 2000 on Windows Me.I'm trying to link to the tables on the
Oracle server from Access.the DSN setup dialog requires the server
name,can I find the server name in NetHood folder? Do I need to install the
Oracle client or components ? My system uses a static IP address and is
connected to the Oracle server through a gateway.

Thanks
 
You may not have to install the Oracle client, but it is possibly the
easiest way to get the ODBC driver and DSN set up. That said, ask your
system administrator for the specific information for the database that you
are trying to connect to, as there may be several of them, and you may also
need to have him set up permissions for you to connect to the Oracle DB.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to connect to Oracle server from within microsoft access 1
Access 2003 not linked to Oracle 11g 3
Insert Record into Oracle Table 1
Error: Cannot add MS ODBC for Oracle 1
Linking Access and Oracle Database 2
Force .NET cide to pick up 64 bit Oracle Client in a 32 bit WindowsProcess (related to AutoSys) 0
DSN-Less connections with MS Oracle Driver 4
ASP connection with Oracle 1

Back
Top