Accessing SQL server through SQLXML...

J

Jéjé

Hi,

I want to access my SQL Server database through SQLXML 3 queries.

I've setup my virtual folder and mapped my stored procedure to an end point
FP 2003 see my webservice and I create a new entry in my catalogs which
consume my method.

but when I want to display the result in FP, I receive an error "the data
source doesn't contain valid XML data"

so... first... does it possible to access a stroredprocedure like this in FP
?
if yes, what are the constraint and config to made at the server side?

Actually my SP is a simple select statement filtered with a varchar
parameter.

any idea?

thanks.

Jerome.
 
J

Jim Buyens

Howdy.

I take it you're using Windows SharePoint Services, If so,
please try the following newsgroup:
microsoft.public.sharepoint.windowsservices

For example, browse:
http://groups.google.com/groups?
group=microsoft.public.sharepoint.windowsservices
and search for
SQL "stored procedure"

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------


-----Original Message-----
Hi,

I want to access my SQL Server database through SQLXML 3 queries.

I've setup my virtual folder and mapped my stored procedure to an end point
FP 2003 see my webservice and I create a new entry in my catalogs which
consume my method.

but when I want to display the result in FP, I receive an error "the data
source doesn't contain valid XML data"

so... first... does it possible to access a
Click to expand...
stroredprocedure like this in FP
 
J

Jéjé

well... I'll go back to SP I think.

thanks.

Jim Buyens said:
Howdy.

I take it you're using Windows SharePoint Services, If so,
please try the following newsgroup:
microsoft.public.sharepoint.windowsservices

For example, browse:
http://groups.google.com/groups?
group=microsoft.public.sharepoint.windowsservices
and search for
SQL "stored procedure"

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------



stroredprocedure like this in FP
Click to expand...
 
Top