Windows server 2003 wont connect to access DB using DSN

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

.

Relevant Pages

  • 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: 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)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Re: TNS could not resolve the connect identifier
    ... This database resides on Machine A. ... The Web server is running on Machine B. ... Using tnsping is not as good as using a real connection such as via ... client (note that this is terminology that appears in the 10g R2 ...
    (comp.databases.oracle.server)
  • Config for OLTP system
    ... extrenal disks fo the 60GByte database server. ... IBM Informix Dynamic Server Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
    (comp.databases.informix)
Loading