>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

How do you connect to SQL Server?
SQL Server or Windows authentication?