LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 02-26-2008, 08:39 AM   #1
Normanjr
LQ Newbie
 
Registered: Sep 2003
Posts: 3

Rep: Reputation: 0
Samba 3, MS Access mdb files failures


Using Samba 3.0.23 on a Slackware 10.2 box, Im facing failures on a share which hosts an MS Access database.

After some time around 3 to 10 minutes using (with no problems) a Visual Basic application which uses the Access database, it fails with a run-time error 2147217865(80040e37), saying that MS Jet engine is not able to find the database or a table. The share itself, however, is still working nicely at this point, I can reach the .mdb and .ldb files from this machine.

I tried many combinations of locking schemas from Internet searches, with no success. My current [global] section of smb.conf follows:

guest account = guestuser
load printers = no
printcap name = /etc/printcap
printing =
log file = /var/log/samba/%m
socket options = SO_KEEPALIVE TCP_NODELAY SO_RCVBUF=8192 SO_SNDBUF=8192
max xmit = 16384
max connections = 100
max open files = 100000
max log size = 100
deadtime = 10
keepalive = 60
read raw = no
write raw = no
getwd cache = yes
dos filemode = yes
dos filetimes = yes
dos filetime resolution = yes
encrypt passwords = yes
case sensitive = no
default case = lower
preserve case = yes
short preserve case = no
dos charset = ISO8859-1
unix charset = UTF-8
display charset = UTF-8
defer sharing violations = true
fake oplocks = no
kernel oplocks = yes
level2 oplocks = yes
oplock break wait time = 0
oplock contention limit = 2
oplocks = yes
veto oplock files = /*.mdb/*.MDB/*.ldb/*.LDB/
posix locking = yes
blocking locks = yes
lock spin count = 30

The share is using 777 permissions on the filesystem, to be sure that Access have no problems to create its lock files (.ldbs).

If someone faced this kind of problem before and could help me on this, It will be greatly appreciated.

Thanks in advance,
Norman
 
Old 03-27-2008, 12:38 AM   #2
padrelinux
LQ Newbie
 
Registered: Mar 2008
Posts: 1

Rep: Reputation: 0
Hi Norman,

i have a problem that seems to be the same, at least, the error code is exactly the same: "2147467259" and seems to be about file locking, althought also it tries to use a file "mswinsck.ocx" that doesn't exist in the share (i think it should exist) so i will to do some tests after tomorrow, here leave you some changes i'm going to do about the file locking in my smb.conf:

For the global section:

locking = yes
share modes = yes
oplocks = yes


For the share:
create mask = 0777
directory mask = 0777


I hope some of that options could help you to solve the problem, but also if you get the solution before, it will be greatly appreciated too...


Thanks and we are in contact...

PadreLinux
 
  


Reply

Tags
access, samba


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access (mdb) file reader? logosys Linux - Software 2 08-31-2005 02:33 PM
password failures on samba access DaddyBad Linux - Newbie 5 09-08-2004 02:34 AM
Samba / XP login failures while tring to access shared files (works with win2k) Zero-0-Effect General 2 01-24-2004 09:27 PM
NFS and MS Access MDB Files ja_nch Linux - Networking 1 09-20-2003 01:53 PM
convert text File to Access MDB Corinne Linux - Software 2 09-24-2002 05:42 AM


All times are GMT -5. The time now is 01:38 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration