Hi
I`ve installed SQl server 2000 and try to use a database in asp with this connection string :

SET objConn=Server.CreateObject("ADODB.Connection")
conStr="Provider=SQLOLEDB;data Source=(local);Initial catalog=testdb;user ID=alireza;Password=12345;"
objConn.open conStr
name=REQUEST.FORM("name")
MAIL=REQUEST.FORM("MAIL")
COMMENT=REQUEST.FORM("COMMENT")
STRSQL="INSERT INTO CONTACT (NAME,E_MAIL,COMMENT) VALUES('"&name&"','"&MAIL&"','"&COMMENT&"')"
SET RS=objConn.EXECUTE(STRSQL)



but when i run this
i got the error :

Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'alireza'. Reason: Not associated with a trusted SQL Server connection.
/irinventory1/CONTACT.asp, line 3

so please help me on this
thansk

__________________
I Really Love to learn ASP

Cross-post of http://p2p.wrox.com/topic.asp?TOPIC_ID=48295

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

HI
thanks alot teh problem solved
and special thanks for the smart question page i love it