Hello, I have a Filemaker Pro 6 datbase that the user runs a script to import a table from a sql database located on a different server. We are upgrading that sql database to a new server. I need to change the import command to point to the new sql server. But I have no experience with FMP at all and the peope who build this script are long gone. Can someone tell me how to edit the import command to point to the new server?

The command is: Import Records [Restore, No dialog , "DSN:olddatabase", "EXEC storedprocedure"]

I want to edit the DSN to the new database and keep everything else intact. But when I click on edit the script the only available option I can see is Specify File and it asks me to open a file. I'm not quite sure what I am supposed to do here. Is there a way to set the DSN to the new ip address or something?

I'm running Filemaker Pro 6. And we are using Filemaker Server 5.5.

Thanks!

Well first you would have to add the ODBC changes in your DSN in case you havent. Second, the ODBC option for the import script step is under the 'File Type' pulldown, when you go to select Specify File.