SPSS 18 - 23 and SQL 2012

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

alshawwa
Posts: 2
Joined: Thu Oct 10, 2013 9:00 pm

SPSS 18 - 23 and SQL 2012

Postby alshawwa » Thu Mar 10, 2016 8:42 pm

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
SAVE TRANSLATE
/CONNECT='DRIVER=SQL Server;'+
'DATABASE=explore;'+
'SERVER=db01;'+
'Trusted_Connection=Yes;'+
'APP=Microsoft Data Access Components;'+
'Network=DBMSSOCN;'+
'UID='
/TABLE="dbo.test2"
/KEEP = FirstName LastName
/REPLACE
/TYPE=ODBC.


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

Who is online

Users browsing this forum: No registered users and 1 guest

cron