Sql connection error

Hi;

I have the following error and cannot find why?
Please help me!
Thank you......
Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

/gokmen/g1.asp, line 18

ASP Code:

<%
Dim num,ad,soyad,bolum,conn,SQLstmt,rs
num=request.form("num")
ad=request.form("ad")
soyad=request.form("soyad")
bolum=request.form("bolum")

set conn=server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB;Data Source=gokmen;Database=gokmen;"
'User Id=administrator;Password=;

SQLstmt="INSERT INTO deneme1 (num,adi,soyadi,bolumu) VALUES ('" &num& "','" &ad& "','" &soyad& "','" &bolum& "')"
Rs.Open Strstmt, conn, adOpenKeyset, adLockOptimistic
set rs=nothing
conn.close

%>

You probably need to add "Server=xxxxxx;" in there.

Hi;

I am getting error again:

Microsoft OLE DB Provider for SQL Server error '80004005'

Invalid connection string attribute

/gokmen/g1.asp, line 18


Line 18:

conn.Open "Provider=SQLOLEDB;DataSource=gokmen;Database=gokme n;Server='10.1.0.74';User Id=administrator;Password=;"

I am getting the same error if I do not put ' (no matter)


If you help me I would be reaaly happy thanks...

try this:

Hi;

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

/gokmen/g1.asp, line 18

What is the aim of the User Id here ??
I think the error is related with this

No - the error is saying it can't find the server/database.
You need to specify where the database can be found (server)
Do not put your IP address (or server name) in quotes.