Solved

Problems connecting access database on network drive via ODBC. (UNC path is not an option)

Posted on 2010-08-18
12
2,345 Views
Last Modified: 2012-05-10
Network drive is ok and valid in explorer, but is not valid in odbc profile. When database is chosen again in ODBC profile it is ok, but only until next reboot.

(Server is WIN 2003 and the client is WINDOWS 7 32 bit.)
0
Comment
Question by:jes12345
  • 5
  • 5
  • 2
12 Comments
 
LVL 6

Accepted Solution

by:
robbe earned 200 total points
ID: 33462360
Hi the problem probably is you are using it to connect to a mapped network drive. As the mappings are not known at the ODBC level you should use UNC paths insted of the drive letter. If you don't know the UNC path you can see it by openening a command prompt and typing 'net use'. If you are already using UNC path's like \\servername\share give us some more info about the problem like error messages.
0
 

Author Comment

by:jes12345
ID: 33463378
UNC is unfortunately not an option. The error we get is: Error: directory or path is not valid (translated from Norwegian so maybe not correct) - this is not an issue on XP and seems to be a WIN7 issue only.
0
 
LVL 6

Assisted Solution

by:robbe
robbe earned 200 total points
ID: 33463577
Why can't you use UNC ? is it giving the error there ? The problem is that drive mappings are not made under that user context.
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 33463856
Win 7 is a 64 bit OS, running 64 Bit and 32 bit programs.  You probably need to update your ODBC drivers for Win 7.
use "C:\Windows\SysWOW64\odbcad32.exe" to see if the drivers are installed there.
If not, there is a link below for MDAC 2.8. Download & install it from http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en
and it should install the correct drivers to the correct location.
0
 

Author Comment

by:jes12345
ID: 33464127
This is probably not the issue because the odbc works fine until the next reboot. After a reboot the path is  not valid anymore and the mdb file needs to be selected again.
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 33464976
then,  probably all you need to do is  recreate the connection using the control panel .
0
 

Author Comment

by:jes12345
ID: 33509230
I have tried to recreate the ODBC profile an recreate the mapping to the network drive. Same result.
0
 
LVL 38

Assisted Solution

by:puppydogbuddy
puppydogbuddy earned 300 total points
ID: 33509879
try going to www.ConnectionStrings.com and see if there is updated connection string for the Win7 environment.

If that does not work, test disconnecting and remapping the network drive on one of the machines using Win 7.

If none of the above work, check user permissions.
0
 

Author Comment

by:jes12345
ID: 33564802
Can I please ask you to advise which user permissions that should be checked?
0
 
LVL 38

Assisted Solution

by:puppydogbuddy
puppydogbuddy earned 300 total points
ID: 33566345
Per your previous comments, users on win7 are the only ones with the issue.  See if there is a commonality in their profiles vs non-problematic users.  Maybe they have or do not have roaming profiles?
0
 

Author Comment

by:jes12345
ID: 33566921
It seems like the solution was to deactivate user control on the client machines.
0
 
LVL 38

Assisted Solution

by:puppydogbuddy
puppydogbuddy earned 300 total points
ID: 33567166
Not advisable to completely deactivate.  try changing the settings instead.  See the following link:
               http://technet.microsoft.com/en-us/magazine/2009.07.uac.aspx
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question