April 26, 200619 yr 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?
April 26, 200619 yr Author 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?
April 26, 200619 yr Author Got it. Was totally unrelated. I made a change that did a search prior to the import. That's what was messing it up.
Create an account or sign in to comment