Hi there,

I hope this is the right category as my problem sounds a bit starnge.
I have written an app to copy data from my VFP-DB to a SQL Server-DB (Express Version)
I use SQL-Passthough with VFP9 and issue a command like "truncate table kunarede",
after I have checked that I got a valid handle with sqlstringconnect.

The first time it ran on my Win-XP-PC everything worked fine. I copied it to a Win-7-PC and
the truncate-command failed. I checked it with aerror and got an error message (translated from
german( like "object not found or not valid".
I tried to truncate the table within the SQL Server Management Studio and it failed to (No error, it says everything
ok, but nothing has happened)!
I went back to my XP-PCand here it failded now too. And here the SSMS failed too.
I changed the command to "truncate table galdata.dbo.kuanrede" and it worked within
SSMS. I changed my app and it worked with the WIN-XP-PC.
I copied it to the Win-7-PC and now I do not get an error-mesage but the truncate still fails.
I should although mention that it is Win7-32 Bit.
Has anyone any idea what is going wrong there?

Thanks in advance

Thomas