DRW error/ server error (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

rrnml -> 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 -> 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.



rrnml -> 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 -> RE: DRW error/ server error (3/10/2005 17:11:37)

What is your full connection string?



rrnml -> RE: DRW error/ server error (3/10/2005 17:13:18)

Do you mean the UID and PWD?



BeTheBall -> 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")



rdouglass -> 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.



Spooky -> RE: DRW error/ server error (3/11/2005 14:20:47)

Failing that - what does your current connection string look like? (You can xxx out the login and password ;-)



rrnml -> 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..)



Spooky -> RE: DRW error/ server error (3/11/2005 14:36:27)

Have you confirmed the DSN is setup correctly on the web server?
Do you have the ability to change to a DSN'less connection?



rrnml -> 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.



Spooky -> RE: DRW error/ server error (3/11/2005 14:46:49)

It depends where the current connection is stored - inline, or in an include file.
Obviously, its easier to do if in an include.

One example :
dbConn = "DRIVER={SQL Server};SERVER=localhost;DATABASE=DatabaseName;UID=xxxxxx;PWD=xxxxxxx"

Does the server allow windows and sql authentication or just windows?



rrnml -> 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 -> 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.



Spooky -> RE: DRW error/ server error (3/11/2005 15:36:21)

That was for a DSN'less connection - something to try instead of the DSN which isnt working



Spooky -> RE: DRW error/ server error (3/11/2005 15:37:35)

So you are using Frontpage DRW for this query?



rrnml -> RE: DRW error/ server error (3/11/2005 15:39:32)

Yes



Spooky -> RE: DRW error/ server error (3/11/2005 15:42:07)

Did you create the original connection by using tools > site settings > database > ?
Did it originally work - or is this the first attempt?



rrnml -> 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.



Spooky -> RE: DRW error/ server error (3/11/2005 17:42:56)

I would first create and verify the database connection using the FP tool above, jsut so FP is aware of the connection



rrnml -> 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



Spooky -> RE: DRW error/ server error (3/11/2005 18:15:45)

If thats the case - youll need to go back to the host as its not set up correctly it seems



rrnml -> 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?



Spooky -> RE: DRW error/ server error (3/31/2005 14:36:14)

Different hosts? Check the SQL server allows SQL authentication opposed to NT Uth only.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.09375