Problem with Custom Query in Database Connections

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I'm having a problem doing a custom query for the database connection part in data view. I'm able to connected to the database (HEAT) but I want to do a query from two tables (STORE and STORE1) in the database. I've tried different types of SQL statements but none of them seem to work. I've even tried simple SQL statements like "Select * from STORE" and that doesn't work either. I keep getting this error "The Data Source does not contain valid XML data" and that the data source returned a non-specific error while trying to execute this query. I'm running Microsoft SQL Server 2000 and when I do queries from the server it works fine but for some reason when doing it on custom query for Frontpage 2003 it fails.

So if anyone could help me out with my problem on trying to query multiple tables from the database using custom query or suggest another way of doing it I would appreciate it.

Thanks,

Kevin
 
Hi Kevin,

It sounds like you have not enabled pass-through queries on the server.
When you write custom SQL there is a pretty big danger that your query will
actually damage the database, so to protect against that possibility, the
server admin has to enable you to use custom SQL.

This can be enabled from the SharePoint admin pages on the server.

--
Thanks!
John Jansen
Micosoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.


Kevin said:
Hello,

I'm having a problem doing a custom query for the database connection part
Click to expand...
in data view. I'm able to connected to the database (HEAT) but I want to do
a query from two tables (STORE and STORE1) in the database. I've tried
different types of SQL statements but none of them seem to work. I've even
tried simple SQL statements like "Select * from STORE" and that doesn't work
either. I keep getting this error "The Data Source does not contain valid
XML data" and that the data source returned a non-specific error while
trying to execute this query. I'm running Microsoft SQL Server 2000 and when
I do queries from the server it works fine but for some reason when doing it
on custom query for Frontpage 2003 it fails.
So if anyone could help me out with my problem on trying to query multiple
Click to expand...
tables from the database using custom query or suggest another way of doing
it I would appreciate it.
 
Back
Top