|
| |
|
|
rrnml
Posts: 197
Joined: 9/20/2004
Status: offline
 |
DRW error/ server error - 3/10/2005 16:54:47
I am getting a database connection error. This is the error I get. Any ideas?
Server error: Unable to connect to a database from the web server using the connection string 'DSN=ProxyDB;DRIVER={SQL Server}'.
The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217843 (0x80040e4d)
Thanks
|
|
|
|
BeTheBall
Posts: 6355
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: DRW error/ server error - 3/10/2005 16:59:44
This is a bit of a guess as I don't use SQL Server. However, I believe you need to include the username and password for the SQL server DB in the connection string.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
rrnml
Posts: 197
Joined: 9/20/2004
Status: offline
|
RE: DRW error/ server error - 3/10/2005 17:04:19
Unfortunately, I have tried that and I still get the same error. It looks like it's trying to logon with NT Authority and Anonymous Logon. Not sure why though.
| |
|
|
|
BeTheBall
Posts: 6355
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: DRW error/ server error - 3/10/2005 17:11:37
What is your full connection string?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
rrnml
Posts: 197
Joined: 9/20/2004
Status: offline
|
RE: DRW error/ server error - 3/10/2005 17:13:18
Do you mean the UID and PWD?
| |
|
|
|
BeTheBall
Posts: 6355
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: DRW error/ server error - 3/10/2005 17:21:17
I mean the full connection string. You can edit the username and password if you wish. For example, one of my connection strings looks like this:
sDSN ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("fpdb\login32774.mdb")
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
rdouglass
Posts: 9202
From: Biddeford, ME USA
Status: offline
|
RE: DRW error/ server error - 3/11/2005 10:58:51
quote:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
You will need to setup a user in your DSN for this to work. I wouldn't suggest using the "sa" or "dbo" passwords though. I use the syntax a little differently. It should look something like this:
myDSN = "DSN=ProxyDB;uid=XXXX;pwd=XXXX;database=XXXX"
Of course you need to be sure there is a DSN set up as well but if you replace those XXXX's with your stuff, I think you may have better luck. Hope it helps.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
rrnml
Posts: 197
Joined: 9/20/2004
Status: offline
|
RE: DRW error/ server error - 3/11/2005 14:24:05
Server error: Unable to connect to a database from the web server using the connection string 'DSN=ProxyDB;DRIVER={SQL Server};UID=XXXXXX;PWD=XXXXX'.
Has something to do with the SQL connections because all the others work(access, as400, etc..)
| |
|
|
|
rrnml
Posts: 197
Joined: 9/20/2004
Status: offline
|
RE: DRW error/ server error - 3/11/2005 14:39:39
It is set up correctly. At least I would think so. It was done by the Net Admin. I checked it myself as well. Not sure about a DSN less connection or how I would go about doing that.
| |
|
|
|
rrnml
Posts: 197
Joined: 9/20/2004
Status: offline
|
RE: DRW error/ server error - 3/11/2005 15:04:17
Ok not too familiar with all this so I'll let you know what I'm doing. I found the info on querying a db on your tutorials. Not sure this is where I should start though. What I am doing is creating a form to display all websites that have been viewed by employees. This query will pull info from a db on an SQL server. I want to add a search box to the form to search by keyword so the db can be searched that way as well. Am I in the right place or am I way off? If I'm way off can you help me?
| |
|
|
|
rdouglass
Posts: 9202
From: Biddeford, ME USA
Status: offline
|
RE: DRW error/ server error - 3/11/2005 15:30:00
quote:
DRIVER={SQL Server};
Maybe I'm off base, but when I use DSN's, I never have to specify that - just the DSN name hence my earlier post. If I put that in my connection string (when using a DSN) it fails every time. Win2K3 server.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
rrnml
Posts: 197
Joined: 9/20/2004
Status: offline
|
RE: DRW error/ server error - 3/11/2005 15:39:32
Yes
| |
|
|
|
rrnml
Posts: 197
Joined: 9/20/2004
Status: offline
|
RE: DRW error/ server error - 3/11/2005 15:46:54
No I went to Insert, Database, Results and then just went from there. It never worked.
| |
|
|
|
rrnml
Posts: 197
Joined: 9/20/2004
Status: offline
|
RE: DRW error/ server error - 3/11/2005 17:57:48
I tried to verify using that tool and I still get the same error. I searched the error on Microsoft.com and this is what I found. Not sure how to go about doing this though.
http://support.microsoft.com/default.aspx?scid=kb;en-us;253500
| |
|
|
|
rrnml
Posts: 197
Joined: 9/20/2004
Status: offline
|
RE: DRW error/ server error - 3/31/2005 13:39:28
Hey Spooky sorry I never got back to this. I was out of town at a conference. Anyway I wanted to know what you meant by checking the host. Do you mean the SQL server that I am trying to connect to? Also what would I have to check?
< Message edited by rrnml -- 3/31/2005 15:43:01 >
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 