Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT ACCESS
HXTT mapped drive issue
Tat
2016-10-18 03:30:39.0
Hello.
I am using HXTT excel driver to get data from an excel file. File is in shared folder which asks username and password to access it's files. When I try to connect to it by HXTT driver after accessing folder by file explorer it connects successfully but when I try to connect, providing username and password, which I use to connect in file explorer it throws exception

java.sql.SQLException: \SharedFolder\HXTT\data.xlsx doesn't exist or can't be accessed. If you're using mapped drives to access database files, you may need to check the security permissions.

How can I solve this authentication issue?
Re:HXTT mapped drive issue
HXTT Support
2016-10-18 04:29:28.0
jdbc:excel:smb://[[[domain;]username[:password]@]server[:port]/[[share/[dir/]file]]][?[param=value]]
Re:HXTT mapped drive issue
HXTT Support
2016-10-18 04:30:40.0
It's at http://www.hxtt.com/excel/advanced.html#mining .

Re:Re:Re:HXTT mapped drive issue
Tat
2016-10-18 07:50:55.0
Thank you for your quick response!
Re:Re:Re:Re:HXTT mapped drive issue
Tat
2016-10-20 05:50:57.0
I have one more question and I can't find any solution for it. I successfully connect and read my excel file from machine by this way, providing username password for machine. But for those cases that excel file is in the folder which also requires username password, so I have to specify 2 credentials I can't find a way to connect to it. Is there any solution for this case?
Re:Re:Re:Re:Re:HXTT mapped drive issue
HXTT Support
2016-10-20 06:45:30.0
For instance,

jdbc:excel:smb://[[[domain;]username[:password]@]server[:port]/share/dir/[?[param=value]]

Then
select * from your excelfiles.sheetName .
Re:Re:Re:Re:Re:Re:HXTT mapped drive issue
Tat
2016-10-20 07:22:29.0
That is the way I connect to the machine and select from public file of it, this works fine.
My problem is when file is in the secured folder. To be more clear lets say machine name is MCH1 I connect to it by "machineUser" and "machinePassword" credential, and I have one shared folder in it - "securedfolder" which I connect by "folderUser", "folderPassword" credential.
I have successfully read from public file by this URL - jdbc:excel:smb://machineUser:machinePassword@MCH1/path/publicFolder/HXTT/Data.xlsx?maxScanRows=31
But for sequired folder I try like this
jdbc:excel:smb://machineUser:machinePassword@MCH1/path/securedfolder/HXTT/Data.xlsx?maxScanRows=31
and it throws exception - Failed to load database Data:jcifs.smb.SmbException: The network name cannot be found.

I guess It's because I nowhere provide "folderUser" and "folderPassword" so it can't get excel file from it. Is there any solution for this situation?
Re:Re:Re:Re:Re:Re:Re:HXTT mapped drive issue
HXTT Support
2016-10-20 07:43:33.0
>and I have one shared folder in it - "securedfolder" which I connect by "folderUser", "folderPassword" credential.

Because your securedfolder is used different credential to share, you have to
use
jdbc:excel:smb://folderUser:folderPassword@MCH1/path/securedfolder/HXTT/Data.xlsx?maxScanRows=31
to access it.

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap