1. Prasad Pati
  2. PowerBuilder
  3. Wednesday, 08 May 2019

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


Accepted Answer
Prasad Pati Accepted Answer Pending Moderation

it is a silly mistake, resolved it myself. Just for anyone who come across the similar situation.

install 32bit version of office in Citrix.


There are no comments made yet.
  1. Thursday, 9 May 2019
  2. PowerBuilder
  3. # Permalink

There are replies in this question but you are not allowed to view the replies from this question.