Powerbuilder application deployed to Citrix works great, except connecting to Excel file. I am using ODBC to connect to excel file to import data into datawindow, this works great on desktop but in Citrix client C: drive becomes \\Client\c$. getting error as
Error connecting to Excel file \\Client\C$\temp\Final - Upload Template.xlsx
Powerbuilder: 2017R2
Citrix presentation server: 7.15
Citrix receiver: 4.9
I guess issue is with the ODBC connection, I am getting file path by calling GetFileOpenName.
Not able to connect in Citrix, do you think it is related to permissions?
Works great in desktop ls_PathFileName = C:\Temp
But in Citrix ls_PathFileName = \\Client\C$\Temp
SQLCA.DBParm = "ConnectString='DSN=Excel Files;DBQ="+ls_PathFileName+"',CommitOnDisconnect='No'"
Connect using sqlca