Solved

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

Posted on 2010-08-18
12
2,228 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
 
LVL 38

Expert Comment

by:puppydogbuddy
Comment Utility
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
Comment Utility
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
Comment Utility
then,  probably all you need to do is  recreate the connection using the control panel .
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:jes12345
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
OfficeMate Freezes on login or does not load after login credentials are input.
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now