ASP pages not working on @2k Workstation

[Scott]

Technical Information (for support personnel)

Error Type:
Provider (0x80004005)
Unspecified error
/ihome.asp, line 313


thanks

[Aaron Bertrand [MVP]]

> /ihome.asp, line 313

So, what is on line 313?

And does a single ASP file really need 313 lines?

[Scott]

I typed most of the message in Word and then did not cut
it into the post.

Sorry about that.

I have a set of ASP that link to an access 97 DB.

They run fine on my W2000 Server.

I have moved the pages and the DB to my workstation so I
can do some updates and add some functioanlity.

On My workstation the pages work, but I can not instanly
move from one page to the next. It is like I have to
whate for somthing to timeout to free up the database so I
can query again.

I get the folowing error:

>-----Original Message-----
>Technical Information (for support personnel)
>
>Error Type:
>Provider (0x80004005)
>Unspecified error
>/ihome.asp, line 313
>
>
>thanks
>.
>

[scott]

I hope you saw my second post that has a bit more detail
then the first.

strQuery="SELECT * FROM SalesMan WHERE ((([active]) = -1))
ORDER BY Salsman"
Set rst = Server.CreateObject("ADODB.recordset")
rst.Open strQuery, strProvider

The last line is 313

And if the programer knows what he is doing an asp page
probably does not need 313 lines, but this programer does
not always know the best way to hack through a problem!

thanks!

>-----Original Message-----

>> /ihome.asp, line 313

>
>So, what is on line 313?
>
>And does a single ASP file really need 313 lines?
>
>
>.
>

[Aaron Bertrand [MVP]]

> strQuery="SELECT * FROM SalesMan WHERE ((([active]) = -1))

> ORDER BY Salsman"
> Set rst = Server.CreateObject("ADODB.recordset")
> rst.Open strQuery, strProvider

How about

strQuery = "SELECT <column_list> FROM SalesMan WHERE active <> 1 ORDER BY
SalesMan" ' assume typo here?
set rst = connectionObject.execute(strQuery)


Also, what is the connection string you're using, and what version of MDAC
do you have?