1. Prasad Pati
  2. PowerBuilder
  3. Wednesday, 8 May 2019 23:47 PM

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
  1. Thursday, 9 May 2019 16:00 PM
  2. PowerBuilder
  3. # Permalink
4
Votes
Undo

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

install 32bit version of office in Citrix.

 

Comment
There are no comments made yet.


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