Hello,

I am successfully connecting Excel to a local SPSS file but when I try the same with the same file on the corporate file server the connection fails.

What is going wrong? do i need to specify the UNC path in a different way?

Thanks in advance

Alex

here is the connection string for the local SPSS file which works great

= Odbc.DataSource( 
        "DRIVER=IBM SPSS Statistics 28 Data File Driver - Service Client(x64);
		SDSN=SAVDB;
		HST=localhost;
		PRT=18886;
		CP_CONNECT_STRING=c:\folder\spssfile.sav;
		CP_UserMissingIsNull=0",
		[HierarchicalNavigation=true]
)

Here is the same connection string - the only difference being, that I point to a file on the fileserver.

= Odbc.DataSource( 
        "DRIVER=IBM SPSS Statistics 28 Data File Driver - Service Client(x64);
		SDSN=SAVDB;
		HST=localhost;
		PRT=18886;
		CP_CONNECT_STRING=\\fileserver\folder\spssfile.sav;
		CP_UserMissingIsNull=0",
		[HierarchicalNavigation=true]
)

here is the error message I am receiving

DataSource.Error: ODBC: ERROR [HY000] [IBM][ODBC IBMSPSSOEM driver][OpenAccess SDK SQL Engine]File:<\\fileserver\folder\spssfile.sav> could not be opened

Here is the solution: In order to open SAV files located on a file server the SPSS statistics data driver needs to be installed also on the file server.

= Odbc.DataSource(         "DRIVER=IBM SPSS Statistics 28 Data File Driver - Service Client(x64);		SDSN=SAVDB;		HST=localhost;		PRT=18886;		CP_CONNECT_STRING=c:\folder\spssfile.sav;		CP_UserMissingIsNull=0",		[HierarchicalNavigation=true])

= Odbc.DataSource(         "DRIVER=IBM SPSS Statistics 28 Data File Driver - Service Client(x64);		SDSN=SAVDB;		HST=localhost;		PRT=18886;		CP_CONNECT_STRING=\\fileserver\folder\spssfile.sav;		CP_UserMissingIsNull=0",		[HierarchicalNavigation=true])

DataSource.Error: ODBC: ERROR [HY000] [IBM][ODBC IBMSPSSOEM driver][OpenAccess SDK SQL Engine]File:<\\fileserver\folder\spssfile.sav> could not be opened