test1111 IIS7
<% 'Define the OLE DB connection string. strConnectionString = "Provider=SQLOLEDB.1;Password=;Persist Security Info=True;User ID=sa;Initial Catalog=seetracker;Data Source=IGORHOME;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=IGORHOME;Use Encryption for Data=False;Tag with column collation when possible=False" 'Instantiate the Connection object and open a database connection. Set cnn = Server.CreateObject("ADODB.Connection") cnn.Open strConnectionString 'Define SQL SELECT statement. strSQL = "select * from tblLocation" 'Use the Execute method to issue a SQL query to database. cnn.Execute strSQL,,adCmdText + adExecuteNoRecords %>