Jump to content
schotja

services wanted FMP12 to cpanel SQL dbase (DSN connections)

Recommended Posts

Looking for someone to help setup a simple connection to a sql database on cpanel for our Ranch to connect to cattle listings on our website..  I'll be using fmp12 server or content for now just establishing a connection via fmp12 client on windows 7 pro machines.

Specifically I am having trouble establishing a DSN connection from any of my machines and have opened ports / given access in cpanel to my static IP.

I have also updated MS ODBC drivers on one of the machines to see if that made a difference.  It may be something quick for an expert with experience or it might end up being a gremlin.

I have set up some test databases for troubleshooting purposes and willing to do alot of the legwork if i'm able but also willing to pay someone for their expertise as well.

thx.

Share this post


Link to post
Share on other sites

Did you ever get this figured out?

Share this post


Link to post
Share on other sites

Much depends on whether you want to use FM's External SQL Sources (ESS) feature or whether you just want push and pull data through the "Import from ODBC source" and "execute sql" script steps.

The setup is fairly simple.

1) you need an ODBC driver for your SQL database.  The ESS requirements here are fairly strict so check them out careful.  To use those two script steps then any ODBC driver will do.

2) you need to set up a Data Source Name (DSN) in your OS ODBC contol panel, this is where you specify what driver to use and where your SQL database is, specify credentials,...

If the file is hosted on FMS and you want to use ESS then the DSN needs to be set up on the FMS machine.

So let's first figure out whether you want to use ESS or not?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Similar Content

    • By sal88
      Hi all
      Apologies in advance if this is a vague question, or if it's been extensively documented, but I could do with some basic advice on moving filemaker tables to SQL. In terms of database development, I have only really known FileMaker.
      We have a 60 table, 25 user FileMaker database which takes care of most if not all of the company's operations. 
      There is now talk of allowing other platforms (such as PowerApps/PowerBI) access to the data. One such reason is other people are interested in making apps/applets that serve specific functions. This would be simple if the data were held on a SQL database.
      So if all the FileMaker tables were to be moved to SQL, what sort of a task is that in terms of keeping the existing FileMaker gui functioning?
      Or. is there a simpler way to grant other platforms access to filemaker tables?
      And of course, what are the downsides?
      Thanks
    • By Stickybeak
      I have a pretty simple document generation and management solution to which I would like to add an email capability.  I would like to be able to have my email attachments dealt with FileMaker so as to be given a unique name and allow me to save them to my HD all in Macintosh.
      Any body interested in taking on this task for me?
      I will buy whichever plugin will do the best job or suits the successful consultant.
      Management_Clone.fmp12
    • By Jay Hensen
      Good day,
      We are currently looking for a Filemaker developer who can work for us as an independent freelancer/contractor. We are a mid-level Filemaker Developer who needs assistance with maintenance and limited customization on our solutions.
      Our headquarters is based in northern NJ. However, this is a position that can be remote.
      Looking forward to hearing from this community, and thank you for the help.
    • By PCIPal
      San Diego, CA – November 9, 2018 - Productive Computing, Inc., a Platinum member of the FileMaker Business Alliance, is proud to announce a new Maintenance Support Program for FileMaker users.
      This program is intended to provide FileMaker customers a low-cost alternative to time and materials billing when performing “fix it” type programming and regular maintenance on their systems. 
       
      Support plans are designed to improve the performance of a FileMaker app by fixing nagging issues that users create workarounds for, reducing the costs associated with upgrading from one version of FileMaker to the next, providing a means to clean up and modernize legacy code, improving a solution’s user interface, and regularly meeting with and getting advice from a certified FileMaker development team.
       
      This program allows its users unlimited access to FileMaker experts without worrying about the bill.
      Productive Computing’s FileMaker Support Program includes:
      Unlimited support on small development and support requests Unlimited support on FileMaker Pro usage/training Free consulting sessions on programming best practices and workflow recommendations Free Health Assessment ($1,000 value) One free subscription to Productive Computing University ($149/yr value) Annual customer workflow audit, FileMaker new features overview, and system recommendation report "We just completed a massive upgrade in our FileMaker system and, now that we’re on the maintenance program, we’re able to reduce ongoing costs for any remaining open issues as a result of the deployment. The maintenance program has unquestionably delivered a tremendous value for an affordable price." Alana W., 25 Users, Historic and Fine Art Industry Representatives

      Clients who also purchase their FileMaker licensing through Productive Computing will be provided with the following services at no additional charge:
      Discounted hourly billing rates for larger custom development projects Unlimited FileMaker Pro client and server installation support Unlimited SSL Certificate installation for security of FileMaker Server Unlimited support on issues related to FileMaker upgrades and conversions This support program is designed for customers who: 
      Are considering making changes to their system but are concerned about the cost Have recently invested in major custom development to expand their solution’s functionality  Would like to have an on-call FileMaker support resource who knows and cares about their business and specific workflow Like programming themselves but occasionally need a little bit of help or advice Are interested in outsourcing their FileMaker development to free up staff time Do not have an internal employee maintaining their system  Value annual system checkups and would benefit from regular service to keep their solution working at maximum efficiency Are interested in continuing to improve their system and business processes Want to capitalize on FileMaker’s newest features to benefit their company Productive Computing’s FileMaker Maintenance Support Program is available for $200/mo for up to five users, additional users can be added for $40/mo. For more information on plan details and restrictions please visit https://www.productivecomputing.com/filemaker-maintenance-support-program/.
    • By Andy Wolf Bell
      Good day looking for local filmmaker developer , not sure if i should be asking in here though , I'm based in  north west uk liverpool area
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.