Difference between revisions of "JDBC"
Jump to navigation
Jump to search
(Created page with "The 360Works JDBC plugin for FileMaker Pro allows execution of arbitrary SQL statements on one or more JDBC databases, iterating result sets, and importing from any database w...") |
|||
| Line 5: | Line 5: | ||
You will need a JDBC driver to connect to the data source. If you already have a driver, point the plug-in to it using either a URL or uploading it to a container field. If you do not have a driver, the website of the database company will have the .jar file you need. Download a driver using these URLs: | You will need a JDBC driver to connect to the data source. If you already have a driver, point the plug-in to it using either a URL or uploading it to a container field. If you do not have a driver, the website of the database company will have the .jar file you need. Download a driver using these URLs: | ||
| − | For JConnect | + | *For JConnect: http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect |
| − | For PostgreSQL | + | *For PostgreSQL: http://jdbc.postgresql.org/download |
| − | MySQL: http://dev.mysql.com/downloads/connector/j/3.1.html / | + | *MySQL: http://dev.mysql.com/downloads/connector/j/3.1.html / |
| − | MS SQL Server: http://msdn.microsoft.com/en-us/library/ms378672.aspx | + | *MS SQL Server: http://msdn.microsoft.com/en-us/library/ms378672.aspx |
| − | Oracle: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html | + | *Oracle: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html |
| − | FileMaker Server: http://java.net/projects/woof/ | + | *FileMaker Server: http://java.net/projects/woof/ |
For a good list of drivers of many technologies: | For a good list of drivers of many technologies: | ||
http://developers.sun.com/product/jdbc/drivers | http://developers.sun.com/product/jdbc/drivers | ||
Revision as of 16:00, 6 August 2012
The 360Works JDBC plugin for FileMaker Pro allows execution of arbitrary SQL statements on one or more JDBC databases, iterating result sets, and importing from any database which supports the JDBC protocol.
Drivers
You will need a JDBC driver to connect to the data source. If you already have a driver, point the plug-in to it using either a URL or uploading it to a container field. If you do not have a driver, the website of the database company will have the .jar file you need. Download a driver using these URLs:
- For JConnect: http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect
- For PostgreSQL: http://jdbc.postgresql.org/download
- MySQL: http://dev.mysql.com/downloads/connector/j/3.1.html /
- MS SQL Server: http://msdn.microsoft.com/en-us/library/ms378672.aspx
- Oracle: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
- FileMaker Server: http://java.net/projects/woof/
For a good list of drivers of many technologies: