HELP! ODBC worked great on my desktop, but now on server doesn't work?

[BowDown]

I was developing on my WinXP Pro desktop. I have 2 ODBC entries registered in my Windows Data Source Control Panel. (ALPINEODBC & SBTODBC)

I have a couple scripts that import data from these 2 data sources, and they work fine when I have the database running locally... but now that I have put the database on a trial version of FM8SVR it wont import from the databases. It gives me an error of:

"There are less records in the data source than in the target table. Not all records were updated"

Any ideas?

[BowDown]

I tried adding the 2 data source entries on the computer thats running the server software. But that didn't help. If I edit the query or create a new one in query builder I can see the tables.

Permissions thing?

[BowDown]

Got it. Was totally unrelated. I made a change that did a search prior to the import. That's what was messing it up.