Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

General error: Invalid file dsn 'nextnetwork.dsn' 


Does anyone know how to fix this error?

Thanks

How about creating a new file DSN?

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Eric Mulartrick" <emulartr@v...>
Subject: [asp_databases] Microsoft OLE DB Provider for ODBC Drivers error
'80004005'


: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
:
: General error: Invalid file dsn 'nextnetwork.dsn'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~.

I thought I did it properly.  Here is what I did.

Under ODBC Databases in the control panel, I went to System DSN -> Add -> 
Microsoft Access Driver -> Named it and selected the access database file 
I downloaded for this project.  Is there anything else I am supposed to 
do?  Obviously, I'm not doing this correctly.

Thanks again,
Eric  


> How about creating a new file DSN?

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Eric Mulartrick" <emulartr@v...>
Subject: [asp_databases] Microsoft OLE DB Provider for ODBC Drivers error
'80004005'


: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
:
: General error: Invalid file dsn 'nextnetwork.dsn'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~.

If you create a "File DSN" then the connection information is stored in a
file on your hard disk. In your ASP page you need to tell ADO to use the DSN
file to work out where the Access database is.

eg:
<%
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "DSN=c:\myDSNs\myAccessDSN.dsn"
%>

If you create a "System DSN" then the connection information is held in the
registry. You just pass the DSN name to the ADO object:

eg:
<%
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "DSN=mySystemDSN"
%>

If you created a System DSN, update the code in the ASP page to reflect
that.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Eric Mulartrick" <emulartr@v...>
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, March 17, 2003 12:11 AM
Subject: [asp_databases] Re: Microsoft OLE DB Provider for ODBC Drivers
error '80004005'


: I thought I did it properly.  Here is what I did.
:
: Under ODBC Databases in the control panel, I went to System DSN -> Add ->
: Microsoft Access Driver -> Named it and selected the access database file
: I downloaded for this project.  Is there anything else I am supposed to
: do?  Obviously, I'm not doing this correctly.
:
: Thanks again,
: Eric
:
:
: > How about creating a new file DSN?
:
: Cheers
: Ken
:
: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: From: "Eric Mulartrick" <emulartr@v...>
: Subject: [asp_databases] Microsoft OLE DB Provider for ODBC Drivers error
: '80004005'
:
:
: : Microsoft OLE DB Provider for ODBC Drivers error '80004005'
: :
: : General error: Invalid file dsn 'nextnetwork.dsn'
:
: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~.
: