Problems with SQL server 6.5?

[Keith]

When trying to use the free and evaluation versions of aspdb, I get sql errors. When checking the "current activity" in enterprise manager, I see that that it tries to execute a command in form "Select TOP 5 * from ...."
This command works in version 7.0, but not in 6.5 Does this mean that asp-db will only work with version 7.0?

[Mark]

Keith,

I would guess that you are trying to read a SQL Server database and do NOT
have the statement:

Mydb.dbDBType = "SQL"

in your asp file.

This is a REQUIRED property. See DOC at:
http://www.aspdb.com/docs/aspdbman.htm#dbDBType

Mark.

------------
Keith at 7/18/00 6:30:52 AM

When trying to use the free and evaluation versions of aspdb, I get sql errors. When checking the "current activity" in enterprise manager, I see that that it tries to execute a command in form "Select TOP 5 * from ...."
This command works in version 7.0, but not in 6.5 Does this mean that asp-db will only work with version 7.0?