Hi<BR> I have written a simple ASP page to retrieve values from the SQL Server DB. Its Desktop version of MS-Sqlserver7.0.<BR>I created a table temp_tab and a database called Harish and ODBC name was harish. <BR>My asp code looks like following<BR>%<BR> Dim objcon<BR> Set objcon = Server.CreateObject ("ADODB.Connection")<BR> objcon.Open "Harish",strconnect<BR> MySql="SELECT * FROM TEMP_TAB ORDER BY NAME"<BR> Set recordset = Conn.Execute(MySql)<BR> Do while not recordset.EOF <BR> Response.Write("name") <BR> recordset.Movenext <BR> Loop<BR><BR><BR> objcon.Close<BR> set objcon = Nothing<BR><BR>Strconnect variable is in the file datastore.txt<BR>strconnect = "Driver={SQL Server}; Server=local; Database=Harish;<BR>UID=sa; <BR><BR><BR>WHILE TRY TO EXECUTE THIS PAGE IT TELLS LIKE THE FOLLOWING ERROR MESSAGE<BR>strconnect = "Driver={SQL Server}; Server=local; Database=Harish; UID=sa; <BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user &#039(null)&#039. Reason: Not associated with a trusted SQL Server connection. <BR><BR>/DBProj/Newrec.asp, line 15 <BR><BR><BR><BR>PLEASE HELP ON THIS<BR>THANX FOR YOUR HELP<BR>HARISH H<BR>