Re: ASP.NET & Access Database!

From: Andy Lim (admin_at_infoteknika.com)
Date: 11/15/04 

Date: Tue, 16 Nov 2004 03:11:04 +0700

try to use DSN, and refer to it in your connection string instead of
hardcoding your MDB location path.

HTH,
andy

"blantz" <brian.lantz@asahq.com> wrote in message
news:18d35b42.0411151101.3df1766e@posting.google.com...
> I am trying to connect to an Access database on a network drive and
> the web server is on the same network, i.e. G:\sample\test.mdb and
> everytime I try to connect to it I get an error saying...
> 'G:\sample\test.mdb' 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. I then tried giving the full path to the server,
> i.e. \\webserver\c:\inetpub\... but got the same error.
>
> When I move the database to my local computer it works fine. Here is
> the connection string I am trying to use.
>
> Provider=Microsoft.Jet.OLEDB.4.0;
> Data Source=G:\sample\test.mdb;
>
>
> When I connect via regular ASP using this custom connection string,
> everything works correct... any ideas?
>
> "Driver={Microsoft Access Driver (*.mdb)}; Dbq=G:\sample\test.mdb"

Relevant Pages

  • Re: OLE DB connection string in SharePoint for Sybase ASA
    ... I wen to the Sybase site and found a reference to Connection String ... > where I WANT it to say Database Connections. ... > and up pops a Data Source Properties Window. ... > Server Error: An error occurred while retrieving the list of Databases ...
    (microsoft.public.frontpage.client)
  • Re: DBIx::DBH - Perl extension for simplifying database connectio ns
    ... Only one of the Informix notations has a host name in it, ... that's technically not a host name but a server name - the distinction ... under the illusion that people who use Perl to access a database know ... The connection string is system-specific -- end of sob story. ...
    (perl.dbi.users)
  • Re: help with changing some code from mdb to adp
    ... At the end of this post is an example of an ADO connection string to a SQL ... Server database, and '' to the UNC path/name of your instance of SQL ... Windows, you can't create a new UDL file directly, but you can create a new, ...
    (microsoft.public.access.adp.sqlserver)
  • RE: vb6 app no longer connects to Access DB on Term Server 2003
    ... we recently upgraded the Terminal Server from the 2000 version to ... we have tried simplifying the connection string by removing the ... Microsoft ActiveX Data Objects 2.8 Library ... We even tried it on Windows Server 2003 ...
    (microsoft.public.data.oledb)
  • Re: problems with my web application
    ... An application error occurred on the server. ... This <customErrors> tag should then have its ... connection string is registered in web.config. ...
    (microsoft.public.dotnet.csharp.general)
Loading