Trying to Log into SQL Server server

A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top