By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,589 Members | 1,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,589 IT Pros & Developers. It's quick & easy.

Trying to Log into SQL Server server

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.