Active Server Pages/ SQL logon failure 
Author Message
 Active Server Pages/ SQL logon failure

My ASP SQL logon just stopped working.

The VBScript is in the form:
Conn.Open ("DSN=hardSQL;DATABASE=hard;UID=user;PWD=password")

This was working a couple of hours ago. As far as I know, the database
has not been changed other than a couple of entries added & deleted.
Now it generates the following error message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near
the keyword 'set'.

Which is even more baffling, as there is no 'set' keyword.

If I remove the database name, the error stays the same. If I remove
the username/password, the error changes to "login failed"

I'm a little clueless as to where to start on this. Anyone have any
ideas?

Dan Sumption
Technical Director
Hard Reality
http://www.***.com/



Fri, 23 Jun 2000 03:00:00 GMT
 Active Server Pages/ SQL logon failure

It might help to run SQLTrace to see exactly what invalid SQL is being
passed to SQL/Server. That may give you some clues as to where the problem
lies.

Mike Abraham



Quote:
> My ASP SQL logon just stopped working.

> The VBScript is in the form:
> Conn.Open ("DSN=hardSQL;DATABASE=hard;UID=user;PWD=password")

> This was working a couple of hours ago. As far as I know, the database
> has not been changed other than a couple of entries added & deleted.
> Now it generates the following error message:

> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near
> the keyword 'set'.

> Which is even more baffling, as there is no 'set' keyword.

> If I remove the database name, the error stays the same. If I remove
> the username/password, the error changes to "login failed"

> I'm a little clueless as to where to start on this. Anyone have any
> ideas?

> Dan Sumption
> Technical Director
> Hard Reality
> http://www.hardnet.co.uk/dan



Fri, 23 Jun 2000 03:00:00 GMT
 Active Server Pages/ SQL logon failure

Did you turn on "mixed security" and turn off "Trusted security" ?

The set is referring to

set Conn = Server.CreateObject(ADODB.Connection)

Hope it helps
Percy

Quote:

>My ASP SQL logon just stopped working.

>The VBScript is in the form:
>Conn.Open ("DSN=hardSQL;DATABASE=hard;UID=user;PWD=password")

>This was working a couple of hours ago. As far as I know, the database
>has not been changed other than a couple of entries added & deleted.
>Now it generates the following error message:

>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near
>the keyword 'set'.

>Which is even more baffling, as there is no 'set' keyword.

>If I remove the database name, the error stays the same. If I remove
>the username/password, the error changes to "login failed"

>I'm a little clueless as to where to start on this. Anyone have any
>ideas?

>Dan Sumption
>Technical Director
>Hard Reality
>http://www.hardnet.co.uk/dan



Mon, 26 Jun 2000 03:00:00 GMT
 Active Server Pages/ SQL logon failure

Look for any database activity in global.asa. It may not be a problem in
the "Conn.Open" statement.

Bibhas.

Quote:
> > The VBScript is in the form:
> > Conn.Open ("DSN=hardSQL;DATABASE=hard;UID=user;PWD=password")

> > This was working a couple of hours ago. As far as I know, the database
> > has not been changed other than a couple of entries added & deleted.
> > Now it generates the following error message:

> > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near
> > the keyword 'set'.



Wed, 28 Jun 2000 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Java Server Pages/Servelets vs Active Server Pages

2. sql server failed to start due to a logon failure

3. Error 1069 (SQL Server Service Did Not Start Due to a Logon Failure)

4. logon failure with SQL Server 2K

5. SQL Server couldnot start due to logon Failure

6. Weird Error connecting to SQL Server from Active Server Pages

7. SQL Server Authentication via Active Server Pages

8. OLAP Logon Failure NT AUTHORITY\ANONYMOUS LOGON - HELP!

9. Active Server Pages and SQL Server Transactions

10. logon failure when logon as admin with service rights

11. Display an Image from SQL Server 7 in an Active Server Page

12. Converting Active/Active to Active/Passive on SQL Server 7.0


 
Powered by phpBB® Forum Software