Intranet Set up with SQL server and ASP

Dear all,

I am trying to make a Intranet connection with SQL 2000 and ASP,
but a serious problem in connection string. Please can you help me in this issue

I am using following connection string.

(windows authontication)

Set conn=Server.CreateObject("ADODB.Connection")

conn.Mode=adModeReadWrite
conn.Open="PROVIDER=SQLOLEDB;Integrated Security=SSPI;Initial cataloge =nrth;DataSource=server"

System dsn =nrth
server name =server

This string makes following error

Microsoft OLE DB Provider for SQL Server error '80040e4d'

Invalid connection string attribute

//global.asa, line 17

Microsoft OLE DB Provider for SQL Server error '80040e4d'

Invalid connection string attribute

/test2.asp, line

can you correct this or suggest a valid connection string

Thank youThe DSN probably only exists on the one server. Try replacing it with
Server=servername.|||Originally posted by Satya
The DSN probably only exists on the one server. Try replacing it with
Server=servername.

still having error,

I am checking it in server itself