Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Trying to Log into SQL Server server

Reply
Thread Tools

Trying to Log into SQL Server server

 
 
Alan
Guest
Posts: n/a
 
      09-05-2003
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
 
Reply With Quote
 
 
 
 
Curt_C [MVP]
Guest
Posts: n/a
 
      09-05-2003
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed) 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



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help. Getting a An error has occurred while establishing a connectionto the server. When connecting to SQL Server 2005, this failure may be causedby the fact that under the default settings SQL Server does not allow remote aboutjav.com@gmail.com ASP .Net 0 05-03-2008 12:43 PM
SQL Reference, SQL Queries, SQL help ecoolone ASP .Net 0 01-03-2008 10:58 AM
problem implementing log4j? not inserting data in new userlog.log other then server.log vj Java 0 12-04-2006 08:59 AM
Tools to extract data from SQL database and convert it into XML & insert XML data into SQL databases Harry Zoroc XML 1 07-12-2004 10:10 PM
How to read an SQL Server into a ASP page and then change, add, delete and write it back to SQL Server Belinda ASP General 4 06-11-2004 12:16 PM



Advertisments