How do I display data from an SQL server in SharePoint?

[DoxDanP]

I currently have an .asp page that uses VBScript to connect to an SQL server
and run reports based on form fields on the page. The .asp page is served by
IIS on a server that also hosts SharePoint Portal Server, but it is a
separate site from all of the SharePoint stuff.

What is the best way to put this reporting script within SharePoint?

I can currently link to it, but it comes up with its own style and with no
SharePoint navigation around it. Or I can place it in a pageview webpart,
but it doesn't fit and we get scrollbars everywhere.

I thought it would make sense to create a new basic .aspx page on a WSS site
and then edit it in FrontPage, where I could hopefully transcribe the
VBScript code to C# to recreate the same functionality and display the report
with a data view. However, I can't even get past the first step, which is to
connet to the SQL server. Is this not the way MS wants us to do things?
FrontPage 2003 can't connect an .aspx page to an SQL server? When I try to
create a database connection in the Data Source Catalog, it gives me the
infamous error:

"Server Error: An error occurred while retrieving the list of Databases from
SERVER: The data retrieval service encountered an error during connection to
the data source. Contact the server administrator for more information."

And I can find no help on what that error means. The MS KB article
http://support.microsoft.com/default.aspx?scid=kb;en-us;831092 mentions it,
but doesn't explain what it means and none of the resolutions listed apply.

 

[Tom [Pepper] Willett]

You may wish to ask the experts in the Share Point Newsgroups:

news://msnews.microsoft.com/microsoft.public.sharepoint.windowsservices

news://msnews.microsoft.com/microsoft.public.sharepoint.teamservices
(Usability)

news://msnews.microsoft.com/microsoft.public.sharepoint.teamservices.caml
(Custom Development)
--
===
Tom [Pepper] Willett
Microsoft MVP - FrontPage
---
FrontPage Support:
http://www.frontpagemvps.com/

About FrontPage 2003:
http://office.microsoft.com/home/office.aspx?assetid=FX01085802
===
|I currently have an .asp page that uses VBScript to connect to an SQL
server
| and run reports based on form fields on the page. The .asp page is served
by
| IIS on a server that also hosts SharePoint Portal Server, but it is a
| separate site from all of the SharePoint stuff.
|
| What is the best way to put this reporting script within SharePoint?
|
| I can currently link to it, but it comes up with its own style and with no
| SharePoint navigation around it. Or I can place it in a pageview webpart,
| but it doesn't fit and we get scrollbars everywhere.
|
| I thought it would make sense to create a new basic .aspx page on a WSS
site
| and then edit it in FrontPage, where I could hopefully transcribe the
| VBScript code to C# to recreate the same functionality and display the
report
| with a data view. However, I can't even get past the first step, which is
to
| connet to the SQL server. Is this not the way MS wants us to do things?
| FrontPage 2003 can't connect an .aspx page to an SQL server? When I try
to
| create a database connection in the Data Source Catalog, it gives me the
| infamous error:
|
| "Server Error: An error occurred while retrieving the list of Databases
from
| SERVER: The data retrieval service encountered an error during connection
to
| the data source. Contact the server administrator for more information."
|
| And I can find no help on what that error means. The MS KB article
| http://support.microsoft.com/default.aspx?scid=kb;en-us;831092 mentions
it,
| but doesn't explain what it means and none of the resolutions listed
apply.