Dear All
how can I connect to a database in SQL SERVER 2000 in a local computer
please help me

__________________
I Really Love to learn ASP

Hi there,

Maybe this helps??

http://www.catb.org/~esr/faqs/smart-questions.html

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.

I did not get ur mean!!!!!!!
mybe i am asking wrong question?
i say it like this
I wanna connect to a sql server 2000 data base with asp pages but i cant
how can i connect?????

Yes, that's what I was trying to say. You need to ask better questions to get good answers....

Still, you may need to provide more information. What is it exactly what you're having problems with? Don't you know where to start? Don't you know how to build a proper connection string? Don't you know how to setup SQL Server? Don't you know how to write ASP pages? And so on and so on. We can't guess it so you have to tell us.

Tell us what you already do know, what you don't know and what you're having problems with. Also, tell us what you have already done to figure this out yourself (Google, books and so on) You can't expect us to write a full-blown beginners guide to ASP with SQL Server, only to find out that wasn't what you were asking for... ;)

In short: read the article I linked to and follow its recommendations...

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.

i installed SQL SERVER and make this
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)

in asp page
but when i run this it gives me this 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

do u get it now

Did you use Google for this??

The first or second hit brings you here:

http://support.microsoft.com/kb/889615/en-us

You probably want to go for the option of "Windows account with insufficient permissions" and look here as well:

http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=287
http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=290

I don't want to sound rude or unfriendly, but I guess you also need to reread the article I linked to earlier.

Not only are you cross-posting your question here without a good reason, but you also ask questions that you can solve yourself in a split second using Google.

There's nothing wrong with asking questions here, just as you don't try to let us do your work...

Cheers,

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.

thansk