hi <BR>well i m pretty confused by a strange error<BR>i had prepare one application and till now i was running it on my pc which is winnt.thereafter i tried it to run on iis (through my pc only).All things run fairly except that it is not connectin with database.<BR>the code is as under<BR>Set rs=Server.CreateObject("ADODB.Recordset") <BR>Set conn=Server.CreateObject("ADODB.Connection")<BR>co nn.open="DSN=tempf;UID=nafisa;Pwd=nafisa"<BR>if i run it on pws it works nicely but as i attempted to run it on iis it fail.<BR>i first thought the prob might due to driver wherin i specified host name as the host string so i created another driver wherin i keep the service name as blank but it also didnt work .<BR>i m using odbc driver <BR>Can anyone help me out.<BR>TAI