URGENT Connection Ctring help!

[jchris]

hello i'm newbie to sql server.

i'm using ms sql server 2000, i wish to establish a connection to localhost with the dsn name "LocalServe r"

here is my connection string which lead me to the error :

"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied."

=============== =============== =============== ==========
set objcon = server.CreateOb ject("ADODB.Con nection")

strConnection = "Provider=MSDAS QL;Driver={SQL Server};Server= localhost;Data Source=LocalSer ver; Initial Catalog=cycrm; User ID=cying; Password=admin"

objcon.open, strConnection


is there anything wrong with my connection string data source and server value?
should i put domain\user id?

thanks everyone