Re: Windows server 2003 wont connect to access DB using DSN

<googlegroups@xxxxxxxxxxxxxxxx> wrote in message
news:1119275289.298698.255320@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi all. Please accept my apologies if this is the wrong place to post
> the question, just getting tired now.
>
> I have just finished building our new development webserver using
> Windows server 2003. I have installed SQL Server 200 and applied sp3a
> to it. I have fully 'windows updated' the machine and all seems to be
> going well. I have also managed the server to it is a file server,
> application sever and mail server. I have also allowed ASP, ASp.net,
> frontpage server extensions 2002, Internet Data Connector and server
> side includes in the Web Service Extensions section in IIS.
>
> My problem is this.
> When I create a DSN to an Access database which resides on a different
> server in our network I get the following error:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [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.
> /common/vbglobal.asp, line 14
>
> This line simply opens the DSN by name, like so:
>
> Oconn.Open "MyDSNName"
>
> It is worth noting that the location the database resides in is mapped
> to the webserver so the location of the database file would read as
> follows:
>
> Y:\projects\test\mydb.mdb
>
> I have checked the version of MDAC (not sure if this is what is being
> used or not) and the result comes back as:
>
> MDAC 2.8 SP2 on Windows Server 2003 SP1
>
> Any suggestions welcomed.
>
> Thanks
>

It may be a silly question, but have you checked both the file system
permissions AND the share permissions?

--
============
Frank Hickman
Microsoft MVP
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.


.

Relevant Pages

  • RE: copy permissions from one user to another?
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- ADD USER TO SERVER ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- SET COMMAND TO FIND USER PERMISSIONS HAS IN CURRENT DATABASE ...
    (microsoft.public.sqlserver.security)
  • Re: Effective Permissions Error with Domain User
    ... I set the database compatibility to 2005. ... server profile trace and found that it was calling the Execute As User. ... This leads me to believe it is some sort of permissions issue. ... Did you get these database from SQL Server 2000 by using a RESTORE command? ...
    (microsoft.public.sqlserver.security)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: How to prevent DELETEs in a table
    ... It is the dbo database USER, not server-level groups, that determins ... It has implicit permissions that can not be denied. ... SQL Server just skips any permission validation for sysadmins. ...
    (microsoft.public.sqlserver.server)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
Loading