Trying to Log into SQL Server server

[Alan]

I'm new to ASP, so I'm sorry if this is a dumb question.
I'm trying to log into our SQL Server using ASP. Here's what I've got
so far.

Set objConn=Server.CreateObject("ADODB.Connection")
objConn.Open "Provider SQLOLEDB.1;Integrated Security=SSPI;Persist
Security Info=False;User ID=tester;Password=tester;Initial
Catalog=patyo;Data Source=WEB04WIN"

The error I get is:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified
/projects/project_search_results.asp, line 72

I've tried every hook up I can think of and nothing works. Is there
something wrong with the code or our server. We set it up ourselves
so I wouldn't be surprised.

Let me know,
Alan

[Curt_C [MVP]]

www.darkfalz.com/1059
--
----------------------------------------------------------
Curt Christianson (Software_AT_Darkfalz.Com)
Owner/Lead Designer, DF-Software
http://www.Darkfalz.com
---------------------------------------------------------
...Offering free scripts & code snippits for everyone...
---------------------------------------------------------
"Alan" <al**@ugtv.org> wrote in message
news:a0**************************@posting.google.c om...

I'm new to ASP, so I'm sorry if this is a dumb question.
I'm trying to log into our SQL Server using ASP. Here's what I've got
so far.

Set objConn=Server.CreateObject("ADODB.Connection")
objConn.Open "Provider SQLOLEDB.1;Integrated Security=SSPI;Persist
Security Info=False;User ID=tester;Password=tester;Initial
Catalog=patyo;Data Source=WEB04WIN"

The error I get is:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified
/projects/project_search_results.asp, line 72

I've tried every hook up I can think of and nothing works. Is there
something wrong with the code or our server. We set it up ourselves
so I wouldn't be surprised.

Let me know,
Alan