Hi, I would like the operator to view some pdf files from both vision and perspective.
These files can either be saved on the gateway, or share drives (google drive, dropbox).
What’s the easiest way to realize this function?
My understanding that the vision file explorer and pdf viewer looks for the files at the local vision client station, and perspective app looks at gateway URL.
I just tried to upload pdf files to SQLServer, then download&display it on pdf viewer.
I can manage to upload the pdf file.
But when download and display in pdf viewer, it should following error:
The SQL Server data table structure is as followed:
I used the following script to upload the pdf to the database:
The following script is used to display the data on pdf viewer:
I followed the video below. I found the only difference is the database, in the video mysql is used, here I use sqlserver.
Could it be the data type causing the issue? I used varbinary(max).
I think it should be of type ‘blob’
Just sorted it out. The data type is fine with varbinary(max), it was the wrong table name used.
I am facing the same error with mySQL where i have used datatype as blob, what could be the mistake?
EDIT:
Instead of uploading directly from db, i tried uploading from application and it worked properly.