Runtime problem - Import data from SQL server 2000

July 7, 200520 yr

Hi!

I use an import scrip step to import data from MS SQL 2000. It works fine when NOT in a runtime solution. But when i converted it using FM DEV 7 to a runtime solution, i get a "Import script cancelled". Any idea why? Thanks!

July 7, 200520 yr

compare the files in the runtime folder with those in your FM app folder. could be that you need to copy some translators over.

July 8, 200520 yr

Author

i tried to copy everything even the dictionaries folder inside the extensions folder. but it didnt work.

July 12, 200520 yr

Newbies

We are currently experiencing the same issue with importing any data ONLY when using the runtime solution. Any help would be great!!

Thanks,

Mike

July 12, 200520 yr

It seems to me that runtime files do not have the ODBC capabilities built into Filemaker Pro. The File->Import menu contains no ODBC option under a runtime. Also, the Execute SQL script step doesn't work under a runtime.

This is in keeping with runtimes not having any networking abilities.

You may have to have your SQL server push something onto the web, and use the runtime to import XML from the web server.