Hello im having an issue with spss and sql server 2012
im tyring to run the following , been always working with sql 2005 and for a reason it is not on sql server 2012
'APP=Microsoft Data Access Components;'+
/KEEP = FirstName LastName
after running it i get the following error
>Warning # 6481
>The ODBC subsystem has issued a warning which may affect the processing of
>SAVE TRANSLATE ODBC request
>[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table
>'dbo.test2', because it does not exist or you do not have permission.
>Error # 6489. Text: dbo.test2
>Create table failed.
>Execution of this command stops.
>[Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named
>'test2' in the database.
>Error # 6487
>Write request failed - couldn't write any data.
>Error # 6452
>An error occurred while the output file was being written.
any clues? i tried everything i can think off and no solution yet