Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  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 DBF
JCIFS SmbException Login failure
Juan
2010-10-29 08:20:15.0
I have a strange situation and very much appreciate your guidance.

The dbf files are hosted on a WinXP machine. I can access those files OK using the smbclient from my Linux computer. But if I try to execute a query from the same machine, I receive the following exception:

jcifs.smb.SmbException: Logon failure: the user has not been granted the requested logon type at this computer.

Any idea?

Thanks.

Juan
Re:JCIFS SmbException Login failure
Juan
2010-10-29 13:45:55.0
I want to clarify that the SQL query is sent using to the XP machine through a connection using the HTTX DBF driver.
Re:Re:JCIFS SmbException Login failure
HXTT Support
2010-10-29 17:04:34.0
>jcifs.smb.SmbException: Logon failure: the user has not been granted
>the requested logon type at this computer.
What's your jdbc url or sql? You need to use your user/password in jdbc url or UNC path.
Re:Re:Re:JCIFS SmbException Login failure
Juan
2010-10-30 06:09:03.0
I am using the same user name and password that I use with the smbclient utility.
However, I am not including those on the URL but rather on the login box of the SQL utility, should this work?

The url is jdbc:dbf:smb://winpaq/adminpaq/ml

Thanks.
Re:Re:Re:Re:JCIFS SmbException Login failure
HXTT Support
2010-10-30 06:25:50.0
>The url is jdbc:dbf:smb://winpaq/adminpaq/ml
Try jdbc:dbf:smb://username:password6@winpaq/adminpaq/ml
Re:JCIFS SmbException Login failure
Juan
2010-10-30 09:41:23.0
The connection works using the method you suggested.

The question remains, does this mean that connecting passing parameters (like user name and password) to the Connection class is not supported by the DBF driver or is this a JCIFS issue?

Juan
Re:Re:Re:Re:Re:Re:JCIFS SmbException Login failure
HXTT Support
2010-10-30 18:27:14.0
>does this mean that connecting passing parameters (like user name and password)
>to the Connection class is not supported by the DBF driver
Supports. But that user/password in connection properties are used for database connection, not for SAMBA connection.
Re: JCIFS SmbException Login failure
Juan
2010-11-03 15:49:44.0
As far as I know, there is no such thing as a database connection when dealing with a DBF (its only a file), am I right?

If the above is true, wouln't it make sense to pass the user name and password to the JIFS driver for jdbc:dbf:smb URLs?, maybe only when it is not supplied as part of the URL (as in jdbc:dbf:smb://username:password@machine)?

Juan
Re:Re:Re:Re:Re:Re:Re:Re:JCIFS SmbException Login failure
HXTT Support
2010-11-03 16:07:47.0
>As far as I know, there is no such thing as a database connection when dealing
>with a DBF (its only a file), am I right?
Sorry. HXTT DBF supports server/client mode also, and will use user/password for remote login/remote control.
Re:JCIFS SmbException Login failure
Juan
2010-11-04 06:44:20.0
Even so, wouldn't it be possible/desirable to also pass the user/password to the JIFS driver (when not supplied in the URL)?
Re:Re:Re:Re:Re:Re:Re:Re:JCIFS SmbException Login failure
HXTT Support
2010-11-04 06:54:12.0
>Even so, wouldn't it be possible/desirable to also pass the user/password to the
> JIFS driver (when not supplied in the URL)?
We can. But it will give away user/password to samba server since samba url an use in jdbc url or sql. It will faile for anomyous samba access when provided wrong unnecessary user/pasword.
Re:JCIFS SmbException Login failure
Juan D��az
2010-11-04 07:48:06.0
I understand. Maybe it would be good to state this on the documentation (the difference on samba vs connection user/name password). It took me some time to figure it out. If it is already stated, then I skipped it.

Thanks again.

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