jimliston Posted February 3, 2010 Share Posted February 3, 2010 I am running FMP 10 and cannot access my company's Oracle 10 DB via ODBC. When I first loaded the new version of FM, I could. Then, all of a sudden, I can't. I have looked in the windows XP control panel at the ODBC tab. There is no driver for FM. Silly question, where do I go for this? Remember, it used to work. Link to comment Share on other sites More sharing options...
mr_vodka Posted February 3, 2010 Share Posted February 3, 2010 If you are trying to access the Oracle data from FileMaker then you need the Oracle driver setup as a System DSN. Link to comment Share on other sites More sharing options...
jimliston Posted February 3, 2010 Author Share Posted February 3, 2010 I have the Microsoft Driver for Oracle as a DNS for the target database. I next tried to relate the table in the relationship graph and get the error message DATABASE ERROR. What am I doing wrong? Link to comment Share on other sites More sharing options...
mr_vodka Posted February 3, 2010 Share Posted February 3, 2010 Sorry for not following here... Are you saying that you have the Oracle 10g or 11g driver installed as a SYSTEM DSN properly? Link to comment Share on other sites More sharing options...
jimliston Posted February 4, 2010 Author Share Posted February 4, 2010 Yes. My work around is to use Microsoft Query to hit the database,return the found set to Excel, and then import from there. Since I can hit the data from Access and Excel, I must have it configured properly. Link to comment Share on other sites More sharing options...
mr_vodka Posted February 4, 2010 Share Posted February 4, 2010 But perhaps not properly for FileMaker Pro's ESS. Again... Its definitely a System DSN not a User DSN right? Link to comment Share on other sites More sharing options...
jimliston Posted February 4, 2010 Author Share Posted February 4, 2010 How would I configure the Filemaker ESS any differently? Remember, out of the box, it worked great(as all Filemaker products do)but somewhere along the line it failed. Hence, these posts. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5219 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now