Thank you very much.
But I have found out that there are many different connection using SQL SERVER.
With DNS
<% dbconn="Provider=SQLOLEDB.1;UID=user;Password=password;Initi al Catalog=DSNname;Data Source=IPaddressoftheSQLserver,PortNumber" %>
OLEDB
<%
Set cnn = Server.CreateObject("ADODB.Connection")
cnn.open "PROVIDER=SQLOLEDB;DATA SOURCE=sqlservername;UID=username;PWD=password;DATABASE=myda tabasename "
%>
WITH DNS
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSN=DSNname;UID=user;PWD=password;DATABASE=mydatabasename"
%>
WITH OUT DNS
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSNtest="DRIVER={SQL Server};SERVER=ServerName;UID=USER;PWD=password;DATABASE=myd atabasename"
Conn.open DSNtest
%>
which one is the best to choose?
Plz, help!
padoxky