Database Results Wizard Error

[Sajmon]

I wanted to do some changes on a web (sub)site so I've
made a copy (via "publish") from /web to /test/web. I've
also made a copy of database.mdb
(database_new.mdb) and changed Site Settings/Database
properly.
But now when I open example.asp (with custom query in
database results region) I'm getting this:

Database Results Wizard Error
The operation failed. If this continues, please contact
your server administrator.

I didn't change anything. Original page on the same server
is working properly. But strange thing is if I change sql
(see below) statement, it works!

original (working on /web, not on /test/web):
SELECT zps_sif as xzps_sif, ime as xime, telefon as
xtelefon, podrocje as xpodrocje, pravice as xpravice, '<a
href="?podrocje=:odrocje::&brisati=' & zps_sif
& '">Brisati!</a>' as xbrisati FROM dezurci where podrocje
= ':odrocje::' ORDER BY ime ASC

modified (working on /test/web!)
SELECT zps_sif as xzps_sif, ime as xime, telefon as
xtelefon, podrocje as xpodrocje, pravice as xpravice, 'A'
as xbrisati FROM dezurci


So, where is the catch?

I'm using Frontpage 2003, with IIS 5 on W2K server. Thanks
for answer. Simon

 

[PMC]

Did you check the database connection in the tools>site settings>database
menu in your test web?

Regards,

Peter

 

[Sajmon]

Sure I did. Connection is working. But I can't explain to
myself why the first (longer) command is not working, but
the second is OK. On the same page...

Any ideas? Thx! Simon

 

[dave]

Nice reply - youll go far.....
Its a reasonable fix, one I posted months back.