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