Posted: Thu Feb 22, 2007 6:51 pm Post subject: odbc link to database is unable to connect?
Hello,
Here we have a win2k3 server which holds our network drive and on this drive resides an access database.
All our client computers use and odbc link with the Microsoft access driver to this database so that they can pull data from it in other programs.
On a test server, also win2k3 sitting on the same domain and with access to the network drive we have created the same link.
However whenever we try to connect we are told,
UNABLE TO CONNECT TO DATABASE
[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
This is strange because we are able to create odbc links to locally stored databases on the test server but we are just unable to access ones elsewhere.
We don't have any permissions preventing access to this database so why won't it connect?
Joined: 19 May 2004 Posts: 9 Location: Centerville, South Dakota
Posted: Thu Feb 22, 2007 8:19 pm Post subject:
Not that I am too familiar with how Microsoft doesthings in the database world, but it appears from the error message that the path to the driver is not specified. (I'm sure you already figured that out on your own).
From Microsoft:
Quote:
The path that the Web server is reading is not a valid path. Often, this occurs when the Global.asa file is being used, and the connection string is created on a computer other than the Web server. If the path is a mapped drive letter, it is probably only valid for the client computer that created the connection string.
When you say you have all permissions enabled, are you talking about domain permissions, or database permissions?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Featured Links*
Looking for more Windows Networking info?
Sign up to the WindowsNetworking.com Monthly Newsletter, written by Enterprise Security MVP Deb Shinder, containing news, the hottest tips, Networking links of the month and much more. Subscribe today and don't miss a thing! View a sample newsletter.
Become a WindowsNetworking.com member!
Discuss your Windows Networking issues with thousands of other Windows Newtorking experts. Click here to join!