i want to make a connection to a sql server 6.5 by useing the following code

DBEngine.DefaultType = dbUseODBC
Dim cConn As Connection
Dim rs as Recordset
    Set cConn = OpenConnection("Cnew", dbDriverNoPrompt, False,
"ODBC;user1;pwd;DSN=x1")
 sql = "select * from adressenstamm"
Set rs = cConn.OpenRecordset(sql, dbOpenDynaset, 0, dbOptimistic)

when the dsn is using nt authentication then it is not possible to make a
recordset. i allways get the error 3124 on row set rs...
i was logged on as administrator so there was no security problem on the sql
server

with the same code and dsn using sql server authentication there is no
problem
what can i do