From what application would the Windows PCs access the database?
SQL Server Management Studio.... Basically trying to set-up the ODBC driver on a pc and can't make the connection.
Here is an update of my current problem. I can share a db from windows using FileMaker sharing and using the ODBC drivers connect to the db from another pc. If I move this same db to a mac I cannot make a connection. Why can I not connect when shared from a mac?
As I understand it, Filemaker server (not advanced) does not support ODBC. FileMaker Server Advanced supports ODBC.
Please note that FileMaker Pro, installed on the PC's would make for a simpler way to connect to the hosted database.
Why your efforts with ODBC and Filemaker Pro as the host aren't working isn't something that I can help you with much here.
Yes I have come across this statement that FileMaker Advanced is needed to run ODBC. But many places you read tells how to set up or connect using ODBC and never really mention that Advance is used. My simple demo confirmed that I can use Filemaker sharing only on a pc and use another pc connection to it with ODBC. My IT dept wants to connect to our Filemaker db hosted on a Mac and pull some of the information into their MS SQL Server.
Going back to my original post I'm trying to confirm if Advanced server is really needed or...
Can I use FileMaker Pro 11 sharing on a Mac and expect Win pcs to access the db with ODBC?
Can I use FileMaker Pro 11 Server (Not Advanced) on a Mac and expect Win pcs to access the db with ODBC?
These are just simple yes or no questions that if someone has experience with Filemaker and ODBC, they could give me a direct answer.