Runtime problem - Import data from SQL server 2000

[ryanzon]

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!

[Wim Decorte]

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

[ryanzon]

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

[mguernse]

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

Thanks,

Mike

[Reed]

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.

[ryanzon]

Thats a good idea, thnx