I have web server and data server running it two DIFFERENT boxes.<BR>On the web server I have created a system DSN and used Uid= sa and blank password to log into the data server.<BR>After I clciked the TEST DSN Connection..it was successful but when I run my code (from ASP page) it is giving me the following error...<BR>Error Type:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80004005)<BR>[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found.<BR><BR>What could be the reason?<BR><BR>Here is my code.<BR> strTemp="DSN=DFWGolfmall;UId=sa;pwd=;" <BR>oConn.Open strTemp<BR><BR>Thanks for the help!!