Thank you for your post!
What are you hosting the solution with? (FileMaker Pro 15/FileMaker Server 15)
Did you access the file with FileMaker Pro via the Remote Host, or did you open it like a local file (double click or Browse File)?
I am also going to move this thread from the FileMaker Community Feedback Space, which is specifically for input on the Community itself, to the Discussions Space where you should receive more views and potentially more feedback on this topic!
Thank you for moving thread. In response to your questions.
I am hosting the solution with FileMaker Pro 15 running on a Windows 7 machine.
MS SQL Server 2008 is also hosted on the Windows PC.
The problem occurs when I try and connect remotely (Remote Host) with either an iPad or my MacBook. Both running the latest versions of FileMaker. I can open program and I can even navigate to various pages. However, I can not access any data from the SQL server. For some reason that I do not understand, the remote connection to FileMaker is not being allowed to connect to draw the SQL data. The program works fine when I open and run it on the host machine.
Does the client machine need an ODBC driver?
Will I have the same problem when later on, I move the client on to using FileMaker Server?
This is a test program for a client who hosts their core data on an SQL server. Basic information is drawn from the server. Then after product testing, updated information is returned to the SQL Server.
Help in understanding the problem is much appreciated.
My understanding is that the workstation you are using is effecting the ODBC link. All Clients firing that script need to have the same named ODBC Connection in their local Data Sources. So, yes, each of the accessing devices must have exactly the same connection. Try setting up another PC with the same named connection and you'll see it works fine.
I think you are thinking that as it is a hosted file the ODBC data is drawn directly from the SQL source by the hosting PC.
I will load an ODBC driver on my mac and check that what you mention works (which I am sure it will).
It still begs two questions though.
The first being is this situation the same when file hosted on FileMaker Server.?
I had a feeling that the server looked after the ODBC connection.
Also, if what you say is correct are there any ODBC drivers available to allow an iOS device (my iPad) to connect. Or is it a case that FileMaker Go is no go when it comes to ODBC connections?
Thanks for your speedy reply
I am no Mac expert (understatement). We do a similar kind of thing daily, but not with a Server with Perform Script On Server (PSoS) capabilities,and not from an iPad. (We do it all Old Skool.)
I have just confirmed that PSoS is supported on iOS. You could run the import routine under that method. Specifically from 'Help':
Reasons to run a script on the server
•to improve performance by reducing the amount of network traffic between the client and server
•to offload long-running tasks from slower clients to a faster server
•to enable FileMaker Go clients to perform tasks that require , which are supported on FileMaker Server but not on FileMaker Go
•to use the Import Records or Execute SQL script steps with an that uses the server’s