test1111
<%
'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
%>