Re: Import from Oracle - ODBC basics

I've had to go through this stuff a couple of times and still don't
really get it. I've made myself some notes and can tell you this works
for FM6 stand alones connecting to Oracle. I don't know if it will
still work with Server 7 / 8 or CITRIX.

- using Oracle's "Net 8 Configuration Assistant" or some
equivalent create a Local Net Service Name Configuration to the Oracle
database eg.;
Service Name: ABC
Standard Port
Host Name: eg. oracle.test.ca
Net Service Name: ABC
Connection Test may NOT work


Setup ODBC
- add an ODBC Data Source from the screen
Start-> Control Panel -> Administrative Tools -> ODBC Data Source ->
System DSN Tab
- add a System DSN using the "Oracle ODBC Driver" (MUST be this
driver, other drivers are NOT acceptable, this driver is installed with
a full installation of Oracle)
- enter the following on the driver setup screen:
Data Source Name: DEF
Service Name: ABC

A FULL installation of Oracle was required on the computer in order for
the "Oracle ODBC Driver" to be available. There were 2 versions of
Oracle, the one that installed the client software and then the one
that installed everything as if this machine was going to run Oracle
(this is the installation you need). I had a few techies tell me
that's not necessary, the client version is enough... THEY'RE WRONG. I
don't know how many hours I wasted because of that.

In FileMaker when you import records from Oracle you reference the DEF
name. If you Oracle server changes names etc. you simply update the
ODBC connection but no change is required in FileMaker.

Hope that helps.

.

Relevant Pages

  • Re: Import from Oracle - ODBC basics
    ... My instinct would have been to install the driver on the ... equivalent create a Local Net Service Name Configuration to the Oracle ... A FULL installation of Oracle was required on the computer in order for ... the "Oracle ODBC Driver" to be available. ...
    (comp.databases.filemaker)
  • Compiling and running DBD for Oracle 10g without installing Oracle
    ... I recently had to compile the DBD modules for Oracle 10g on machines, ... perl, DBI etc. of recent enough version ... Oracle 10g installation disk for your architecture (available at ...
    (perl.dbi.users)
  • Compiling and running DBD for Oracle 10g without installing Oracle
    ... I recently had to compile the DBD modules for Oracle 10g on machines, ... perl, DBI etc. of recent enough version ... Oracle 10g installation disk for your architecture (available at ...
    (perl.dbi.users)
  • Asp.net/vb and Oracle
    ... setup on other machines where I have installed the Oracle 9i client, ... Oracle 9.0 odbc drivers will connect to my oracle database when debugging. ... Oracle client and networking components were not found. ... later client software installation. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Asp.net/vb and Oracle
    ... Oracle Provider for OLE DB components, as well as the orcle Data Provider for ... setup on other machines where I have installed the Oracle 9i client, ... Oracle client and networking components were not found. ... later client software installation. ...
    (microsoft.public.dotnet.framework.aspnet)
Loading