Code:
<%@ Import Namespace="System.data.odbc" %>

<script runat = "server">

sub page_load
	dim con as odbcconnection
	dim cmd as odbccommand
	'dim dtr as oledbdatareader
	
	con = new OdbcConnection ("DSN=ASPNET")
	con.open
	
	cmd = new odbccommand ("select count(*) from besluit", con)
	
	LBLaantal.text = cmd.executescalar()
	
	con.close()
end sub

</script>

<html>
<head><title>titeltje</title></head>
<body>

<asp:label
 ID = "LBLaantal"
 Runat = "server" />
 
</body>
</html>
gives me the error:

ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

when i use ("DSN=ASPNET;uid=testclient;pwd=test") for a connection string, the same error occurs... I'd rather do it without the uid and pwd...

does anyone know what i'm doing wrong? I just want to make a connection with my sql server through a DSN...

help or advice would be greatly appreciated...