bfonnemann

Hello, Currently I am having an issue displaying remote container fields with interactive content (PDFs) on an FMS 13 Server box. JPEGS/PNG display just fine. To describe the issue in detail: A local database will display the interactive PDFs in a remote container field. When the the database is hosted with FMS 13 the container field displays an IIS error message. IIS (v7) hosts a website that is unrelated to this database I have stopped the websites hosted with IIS without any success. Has anybody encountered anything like this is before? I will gladly describe in more detail if the information is insufficient. -B

Wim, Powershell solved my problem. Thanks!

Specifically, I am attempting to execute an INSERT from SQL Management Studio 2012 using a linked server. I have a MS SQL database that will execute stored procedures to populate records within FM. You have indicated that a linked server likely isn't the way to go and based on my experience thus far, I can confirm that. Powershell seems like a promising alternative should this not be possible...

Wim, Have you ever successfully connected MS SQL to FileMaker with Filemaker being the data source? Specifically I'm most interested in inserting records from the context of MS SQL to FM.

Thanks for the reply. Forgive my ignorance but I am unsure of how to query FM using the DSN w/o a linked server. I've done this before using JDBC but not from MS SQL.

Sorry for the confusion. I have set a System DSN up using FM as the name. However when I add the linked server to SQL, I must choose a provider. The only provider that I have successfully added was Microsoft OLE DB Provider for ODBC drivers. FM ODBC is not listed. Perhaps I am choosing the wrong provider? FYI, SELECT works fine using the OLE DB Provider

Greetings all, I am attempting to insert a record into a Filemaker 13 Solution hosted by FMSA 13 from the context of a MS SQL 2012 Server. Thus far I have been unsuccessful using openquery and also attempting to do a standard insert using a fully qualified db name. I have the linked server setup using the Microsoft OLE DB Provider for ODBC Drivers. The linked server will return SELECT queries successfully. Has anybody had any luck inserting from SQL? Any help would be greatly appreciated.