Connecting to a Oracle Database with Filemaker 1

[jtflex]

I am trying to connect to our Orcale Database to extract some fields needed for our FM audio log file.

I started creating the SQL statement by selecting Importing/ODBC. I have no problem with the ODBC connection and can see views and tables. After selecting the fields I want to import I get a error message stating:

[oracle][ODBC]{Ora}Ora-00942:table or view does not exist(-1)

I know the connection is good as I try importing the table & fields using Access and I get the results.

Any idea what FM is looking for that Access finds and returns?

Thanks,

Joe

 

[JeanW]

Shot in the dark....and FWIW...

Didn't had that error, but with other problems at Oracle level I found that:

FileMaker must be running in Multi-User mode with the Local and Remote Data Access Companions enabled.
The ODBC Max Text Length parameter needs to be increased from 255 to 65000.(was also for SQL)
The name of the FileMaker database must not contain spaces or special characters.

...and that the Oracle ODBC driver must be installed on the computer running FM.

 

[DeMann]

I also received that error. Our Oracle guy created a view for me, and when I connected to filemaker, I could see everything. When I just took the fields available from the "view," it worked fine, but when I tried to select fields that weren't included in the view, I received that error.

It seems that on the Oracle end, a view must be created for every field selection you want.

(BTW, I know nothing about Oracle)

_______________
conceptNEXT.com
[cN]

 

[TStriker]

When I have encountered this problem in the past the cause has often been security within Oracle and not connected to FileMaker at all. If your DBA is creating views for you he MAY be creating them under different ownership. Make sure he GRANTS you access to the views.

-Striker

 

[DeMann]

so for me, I have access to the view, but I don't have design privileges for the view, correct?

_______________
conceptNEXT.com
[cN]

 

[TStriker]

Right. You need to have 'select' privliges to do queries. Your DBA may also have to create a Public Synonym for the view.

-Striker