I have just upsized an access db to SQL 7 and setup what I think is the correct DSN. However when I try and open from the ASP page I get the following error.<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e4d&#039 <BR><BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user.XXXXXXX(my machine details)<BR><BR>I have spent hours reading and trying various things but it doesn&#039t get any better. Basically I appear not to connect tothe server at all. Any ideas what I have stuffed to get me to this point and what&#039s the solution??<BR><BR>alan<BR>