Re: Acccess --> Oracle (unix Solaris)

From: marga (marga_at_ono.com)
Date: 05/02/04


Date: Sun, 02 May 2004 19:39:45 GMT

Thanks a lot

"MGFoster" <me@privacy.com> escribió en el mensaje
news:lx1dc.1015$A_4.542@newsread1.news.pas.earthlink.net...
> JJZZ wrote:
>
> > Hi,
> > Anybody kows how connect a acccess (mdb) to oracle BBDD over unix
(solaris).
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Just a guess: Use the Oracle ODBC driver. In place of the server name,
> put the IP address and the port the Oracle server is "watching" (if
> required) E.g. (connection string - partial):
>
> "...;Server=192.168.0.2:1422;Database=Accounting;..."
>
> Port is designated by ":1422" as port 1422. Be sure to user whatever
> your Oracle DBA has set for the IP address & port.
>
> If you're using SAMBA to connect Windows PCs to Unix server, just link
> to Oracle tables using ODBC, in the usual manner (see Access help
> articles on Linking Tables). Make sure the Windows O/S PCs can use
> SAMBA connections. Read the README file that comes w/ SAMBA
> installation packages.
>
> --
> MGFoster:::mgf00 <at> earthlink <decimal-point> net
> Oakland, CA (USA)
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP for Personal Privacy 5.0
> Charset: noconv
>
> iQA/AwUBQHSk2oechKqOuFEgEQIoOQCeOJbLKklWyhbByc2zhQ19sZw9h2QAoKHu
> n7q+a6HwV3jw8Ey95wZMwCO7
> =3pBr
> -----END PGP SIGNATURE-----
>



Relevant Pages

  • Re: Acccess --> Oracle (unix Solaris)
    ... Use the Oracle ODBC driver. ... In place of the server name, ... Port is designated by ":1422" as port 1422. ...
    (microsoft.public.access.queries)
  • Re: Oracle 10g
    ... if you have "any" Oracle OLE DB driver or Oracle ODBC driver you can use it. ... so install the oracle client manager on the AS server ...
    (microsoft.public.sqlserver.olap)
  • [NEWS] Multiple Vulnerabilities in Oracle Database (Character Conversion, Extproc, Password Disclosu
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Multiple vulnerabilities were discovered in the (Oracle database server ... password is required to exploit this vulnerability. ...
    (Securiteam)
  • Re: How to make your report run faster
    ... I've done no work with Oracle as the Server DB, ... > if they click the listbox then "Preview report" button is enabled. ... > -I was try to make the old queries for subreport, ...
    (microsoft.public.access.reports)
  • Re: I cant find a SETUP.EXE in the SQL Plus Client ??
    ... someone else's server for testing some SELECT statements I'm ... free client because I don't own the Oracle license. ... SQL statements. ... There is no documentation with that download. ...
    (comp.databases.oracle.tools)