Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Connection Error

Thread Tools

Connection Error

Spencer Hurst
Posts: n/a

Hi, I have currently found an ASP based website that i developed about 3
years ago and am very keen to get it up and running, it's quite a simple
site, however when i try to do anything with the database i have a
problem with the DSN (I Think).

The error i get is something like the following:
[Microsoft][ODBC Driver Manager]
Drivers SQLSetConnectAttr failed.
/homepage/takeregistration.asp line 10.

The code from which this error is obtained is:

<% pageTitle = "Login -" %>
<!--#include virtual="/homepage/pagetop.txt"-->

<% p_userid = Request.form ("p_userid")
p_pass = Request.form ("p_pass")
p_save = Request.form ("p_save")

set spencerDB = Server.CreateObject ("ADODB.Connection")
spencerDB.Open "spencer" <<<<< LINE 10

sqlText = "select * from members where username = '" & p_userid & "'"

set userSet = spencerDB.Execute(sqlText)
if userSet.EOF then
'No such username so the recordSet is empty
Response.Redirect "/homepage/login.asp?retry=username"
'The username is good, now lets check the password
real_password = trim (userSet("password"))
if p_pass = real_password then
'Password is good

Response.Cookies ("isLoggedInAs")("username") =
Response.cookies("isLoggedInAs") ("first_name") =
Response.cookies("isLoggedInAs") ("last_name") =

if p_save = "yes" then
Response.cookies("isLoggedInAs").expires = #December 31,
2003 00:00:00#
end if

set spencerDB = Nothing

if Request.ServerVariables("HTTP_REFERER") =
"/homepage/chat.asp" then
Response.Redirect "/homepage/chat.asp"
end if

Response.Write "<h2 class='heading'>Login successfull!</h2>"
Response.Write "<p>You are now successfully logged in, use the
menus at the top or bottom to navigate through this site."

'Username is not good, but password is wrong
Response.Redirect "/homepage/login.asp?retry=password"
end if
end if
<!--#include virtual="/homepage/pagebottom.txt"-->

This baffles me as i have created the DSN in the advanced tools within
the control panel and selected an appropriate database. I am running
Windows 2003 server edition, using a Microsoft Access database. The same
error occurs with other pages trying to interact with the database.

Any help on this issue will be much appreciated.



*** Sent via Developersdex ***
Reply With Quote
Bob Barrows [MVP]
Posts: n/a
Spencer Hurst wrote:
> Hi, I have currently found an ASP based website that i developed

Already answered over in .db

Please do not multipost Spencer. This is definitely a database-related
question so .asp.db was the perfect group in which to post it. Posting it
here as well did not increase your chances of getting an answer (most of us
subscribe to both groups). On the contrary, if somebody had taken his time
to answer it here, only to find that it was already resolved in the other
group, that person may have been annoyed enough to ignore any future posts
from you, thereby decreasing your chances of getting help in the future.

There are times when you will not be sure which group is most appropriate
(again, this was not one of them), and you will want to post a question to
both groups. In that situation, you should use the cross-posting technique,
rather than posting the same message multiple times. To crosspost, put
a semicolon-delimited* list of the newsgroups to which you wish to post in
the To: header of your post and post it once. It, and any replies to it,
will appear in all the newsgroups in your list. So, if I reply in .asp.db,
my reply will also appear here in .asp.general.

* ... or whatever delimiter is recognized by your news client

Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the

Reply With Quote

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
Internal connection fatal error and other random db connection err =?Utf-8?B?cGF0cmlja2RyZA==?= ASP .Net 0 06-14-2007 09:44 AM
Webservice He!p - Response error: "An existing connection was forcibly closed by the remote host" even when no error in web method iKiLL ASP .Net 0 12-20-2006 04:14 PM
ERROR CLOSING CONNECTION: mysql connection close johnny Python 1 12-08-2006 09:42 PM
The connection to the server has failed. Account: '', Server: '', Protocol: POP3, Port: 110, Secure(SSL): No, Socket Error: 10061, Error Number: 0x800CCC0E Michael Bower Computer Support 3 10-01-2006 03:44 PM
VPN 3005 Error updating group for LAN-to-LAN connection (Too Many Entries Error. Delete an entry before adding a new one). Jan Cisco 1 08-26-2006 04:56 AM