DB connection via en system dsn

Du skal søge for at den mappe / drev hvor databasen ligger ikke er skrivebeskyttet eller på anden måde password beskyttet...

Du skal søge for at den mappe / drev hvor databasen ligger ikke er skrivebeskyttet eller på anden måde password beskyttet...

<%
Set rs =  Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM users"
rs.open StrSQL, "DSN=mail2"
...
%>

Set rs =  Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM users"
rs.open StrSQL, "DSN=mail2"
giver samme resultat.
mappen som er delt på den anden server er delt med everyone med full control, så der skulle ikke være problemer med den delte mappe.
Men lige efter jeg har prøvet at køre min asp kode går den til:
Disconnected K: \\fe001\test Microsoft Windows Network

jeg fandt selv fejlen :-)

Fra http://support.microsoft.com/default.aspx?scid=kb;en-us;189408
SYMPTOMS
Failures occur when Active Server Pages (ASP) code accesses a file-based resource over the network. Examples include the following:
If you Scripting.FileSystemObject to access a file that is stored on a network share, you receive the following error message:

Server object error 'ASP 0177:800a0046'
Server.CreateObject Failed
...
The operation completed successfully.
If you access a local Microsoft Access database that is linked to a table where the table linked to is in an Access database on a network server, you receive the following error message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet
Database engine cannot open the file '******'. It is already opened
exclusively by another user, or you need permission to view its data.
CAUSE
This behavior occurs when password synchronization is enabled for the IIS 4.0 application. For IIS 5.0, password synchronization is called "Allow IIS to control password."

When you connect to an Access database or that Access database is linked to Access tables across the network, this problem can be caused by a combination of password synchronization being enabled and a bug in the Odbcjt32.dll version 3.51.1029 (Microsoft Data Access Components 1.5). That particular problem has been fixed in MDAC version 2.0 and later.
RESOLUTION
Disable password synchronization for the Internet Information Server 4.0 application. For IIS 5.0, do not allow IIS to control the password. To do this, perform the following steps:
Open the Internet Services Manager.
Edit the Properties of the application.
On the Directory Security tab, edit Anonymous Access and Authentication Control.
Edit the Account used for Anonymous Access.
In IIS 4.0, clear the Enable Automatic Password Synchronization check box.

In IIS 5.0, clear the Allow IIS to control password check box.
STATUS
This behavior is by design.

This problem does not occur for IIS 5.0/Windows 2000 networks that are set up to use Kerberos authentication.

Nu kan den både med system dsn
<%
strDSN = "Provider=MSDASQL; DSN=mail2;"
Const adOpenKeyset = 1
Const adLockOptimistic = 3
Set rs =  Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM users"
rs.open StrSQL, strDSN, adOpenKeyset, adLockOptimistic
Response.Write rs("Alias")
rs.Close
Set rs = Nothing
%>
og DSNLess:
<%
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=k:\mail.mdb"
Const adOpenKeyset = 1
Const adLockOptimistic = 3
Set rs =  Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM users"
rs.open StrSQL, strDSN, adOpenKeyset, adLockOptimistic
Response.Write rs("Alias")
rs.Close
Set rs = Nothing
%>