ASP AND SQL SERVER 2005

i cannot connect to my local server.my code is

<%
ad=request.form("ad")
soyad=request.form("soyad")
email=request.form("email")
dim conn
set conn=CreateObject("ADODB.Connection")
conn.open "Server=./SQLEXPRESS;Database=NEWSWORLD;Trusted_Connection=True;"
sqlifadesi="insert into user_info(ad,soyad,email) values('"&ad&"','"&soyad&"','"&email&"')"
conn.execute(sqlifadesi)
conn.close
set conn=nothing
response.write "bilgileriniz kayit edildi,Ilginiz i?in tesekkür ederiz"
%>

it shows error page in

conn.open "Server=./SQLEXPRESS;Database=NEWSWORLD;Trusted_Connection=True;"

i dont use native client because i dont use .net i want to make a connection to sql server 2005 with classic ASP.

Thanks for replies

Hi Ibrahim,

which error are you getting ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

thnx for reply Jens Suessmeyer

when i use this code i get this error .... Microsoft OLE DB Service Components (0x80040E21) Work isnt done

<%

ad=request.form("ad")

soyad=request.form("soyad")

email=request.form("email")

dim conn

set conn=CreateObject("ADODB.Connection")

conn.open "data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|NEWSWORLD.mdf;User Instance=true"

sqlifadesi="insert into user_info(ad,soyad,email) values('"&ad&"','"&soyad&"','"&email&"')"

conn.execute(sqlifadesi)

conn.close

set conn=nothing

response.write "bilgileriniz kayit edildi,Ilginiz i?in tesekkür ederiz"

%>

when i use this code i get this error...Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

<%

ad=request.form("ad")

soyad=request.form("soyad")

email=request.form("email")

dim conn

set conn=CreateObject("ADODB.Connection")

conn.open "Server=.\SQLEXPRESS;Database=NEWSWORLD;Trusted_Connection=True;"

sqlifadesi="insert into user_info(ad,soyad,email) values('"&ad&"','"&soyad&"','"&email&"')"

conn.execute(sqlifadesi)

conn.close

set conn=nothing

response.write "bilgileriniz kayit edildi,Ilginiz i?in tesekkür ederiz"

%>

i have been working on it cant find a solution.when i use vb.net i can connect to sql server 2005 by using this "Server=.\SQLEXPRESS;Database=NEWSWORLD;Trusted_Connection=True;" but in classic asp i cant connect

Thank u

|||

i have solved my problem thank u i have done like this

<%
ad=request.form("ad")
soyad=request.form("soyad")
email=request.form("email")
dim conn
set conn=CreateObject("ADODB.Connection")
conn.open "Provider=SQLNCLI;Server=.\SQLEXPRESS;Database=NEWSWORLD;Tru sted_Connection=yes;"
sqlifadesi="insert into user_info(ad,soyad,email) values('"&ad&"','"&soyad&"','"&email& ; ;"')"
conn.execute(sqlifadesi)
conn.close
set conn=nothing
response.write "bilgileriniz kayit edildi,Ilginiz i?in tesekkür ederiz"
%>

i have done it with SQL Native Client with no username and password.

Thanks for replies

sql