Easysoft ODBC-ODBC Bridge

How do I access ODBC Databases such as Microsoft SQL Server, Microsoft Access, and Microsoft Excel from FileMaker Pro?

You can use the Easysoft ODBC-ODBC Bridge to access ODBC databases such as Microsoft SQL Server, Microsoft Access and Microsoft Excel from FileMaker Pro. For example, import data from SQL Server to FileMaker Pro on Mac OS X. Do this by using the ODBC-ODBC Bridge to access the Microsoft SQL Server ODBC driver on Windows.

Download the ODBC-ODBC Bridge Client for the platform on which FileMaker Pro is installed and install the ODBC-ODBC Bridge Client. Then download the ODBC-ODBC Bridge Server for the platform on which the ODBC driver for your database is installed and install the ODBC-ODBC Bridge Server. Set up and test an ODBC-ODBC Bridge Client data source that points to a System data source for the target ODBC driver.

The following example illustrates this process for FileMaker Pro on Mac OS X and SQL Server.

1. Download the Mac OS X ODBC-ODBC Bridge Client and the Windows ODBC-ODBC Bridge Server.
2. Install the ODBC-ODBC Bridge Client on the Mac OS X computer where FileMaker Pro is installed. Install the ODBC-ODBC Bridge Server on the Windows computer where the SQL Server ODBC driver is installed.

   For installation instructions, see the ODBC-ODBC Bridge documentation.

3. If you have not already done so, in the Windows ODBC Data Source Administrator, create a SQL Server System data source that connects to the SQL Server database you want to access from FileMaker Pro.
4. In the Mac OS X ODBC Administrator, use the ODBC-ODBC Bridge DSN dialog box to create an ODBC-ODBC Bridge Client data source.

   The following table shows some sample values for an example data source named ODBC-ODBC Bridgesqlserver. The example data source points to an ODBC-ODBC Bridge Server on a host named mywindowsserver where there is a SQL Server System data source called sqlserversystemdsn. The LogonUser and LogonAuth values are a valid Windows username and password that can be used to log on to mywindowsserver. The TargetUser and TargetAuth values are a valid SQL Server database login.

   Setting	Value
   Name (DSN tab)	ODBC-ODBC Bridgesqlserver
   Servers (Servers tab)	mywindowsserver:8888
   Username (Servers tab)	mywindowsusername
   Password (Servers tab)	mywindowspassword
   TargetDSN (TargetDSN tab)	sqlserversystemdsn
   TargetUser (TargetDSN tab)	sqlserverusername
   TargetAuth (TargetDSN tab)	sqlserverpassword

   For more information about ODBC-ODBC Bridge Client data source configuration, see the ODBC-ODBC Bridge documentation.

5. In Terminal, use iodbctest to test the ODBC-ODBC Bridge Client data source. For example:

   iodbctest "DSN=ODBC-ODBC Bridgesqlserver"
   SELECT 1 AS test_column

After you have created and tested the ODBC-ODBC Bridge Client data source, use it from FileMaker Pro to query the remote database, import data or create a new FileMaker Pro database file. The FileMaker Pro documentation contains information about how to do this.

As an example of using an ODBC-ODBC Bridge Client data source in FileMaker Pro, the following steps show how to create a new FileMaker file on Mac OS X by using data imported from a SQL Server database.

1. In FileMaker Pro, on the File menu, choose Open. In the Open dialog box, choose Show, and then choose ODBC Data Source from the list.
2. Choose the ODBC-ODBC Bridge Client data source, and then choose Continue.
3. When prompted, type the SQL Server database login username and password that you supplied when configuring the ODBC-ODBC Bridge Client. Then choose OK.
4. In the SQL Query Builder, use the SELECT, WHERE and ORDER BY tabs to generate a query that will retrieve the records you want to import. Then click Execute.
5. Save the new FileMaker file.

Applies To

• Products
  • Easysoft ODBC-ODBC Bridge
• Applications
  • FileMaker Pro

Knowledge Base Feedback

* Did this content help you?

Yes No Maybe

* Please select one option based on your first choice:

I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

Suggest new content or let us know how we can improve this content:

(* Required Fields)

• About Easysoft

• Contact Us
• About Us
• Clients
• Upgrade Offer
• Blog
• Careers

• Products

• ODBC Drivers
• JDBC Drivers
• Bridges and Gateways
• In Development

• Services

• Consultancy
• Training
• Custom Development

• Licensing

• Product Licenses
• Prices

• Support

• Support Home
• Solution Wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer Area
• Client Applications

• Legal

• Privacy Statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle® is a registered trademark of Oracle® Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
• 
•