J
jblaze
OK. I've been pulling my hair out trying to get this work. I'm
working on my company's intranet. One of the main things we want to
acccomplish is viewing access and sql server data on some of these
pages.
The Intranet is stored under C:\inetpub\wwwroot\refintranet\ on a
Windows 2003 server configured with IIS 6.0. The SQL Server 2000
server is also a Windows 2003 server.
Here's the problem....
When i'm editing pages from my workstation (WIN XP / FrontPage 2003) I
can go through the Database results wizard using the following
settings.
-ASP.NET
-Connect to an external database
-SQL Server (database driver)
-Server (i enter the IP address of the SQL Server)
-Database Name
-Username and Password - left blank
I then get a drop-down with a list of the Tables within the database.
So it is getting to the SQL server. But when FrontPage creates the
page and i try to preview it returns - "To view all elements in this
page correctly, save or publish the page, and preview it in a Web
Browser.
I have tried publishing but that shouldn't make a difference because I
am directly editing the directory where the Intranet pages are stored
via a mapped drive.
Also, when i try going through Database Results wizard while i'm
editing pages (while sitting at the Intranet server) it gets to the
Record Source page and returns an error "The server encounterd an
error while processing a database request".
Is there a correct configuration for IIS in order to connect to
databases. I assumed that this shouldn't be so difficult since these
are microsoft products that are involved. Do I need to configure the
ODBC (under admin tools on the server) for connectivity to external
access and SQL server DB's???
If there's anyone out there that can help, I would really appreciate
it. Thanks
working on my company's intranet. One of the main things we want to
acccomplish is viewing access and sql server data on some of these
pages.
The Intranet is stored under C:\inetpub\wwwroot\refintranet\ on a
Windows 2003 server configured with IIS 6.0. The SQL Server 2000
server is also a Windows 2003 server.
Here's the problem....
When i'm editing pages from my workstation (WIN XP / FrontPage 2003) I
can go through the Database results wizard using the following
settings.
-ASP.NET
-Connect to an external database
-SQL Server (database driver)
-Server (i enter the IP address of the SQL Server)
-Database Name
-Username and Password - left blank
I then get a drop-down with a list of the Tables within the database.
So it is getting to the SQL server. But when FrontPage creates the
page and i try to preview it returns - "To view all elements in this
page correctly, save or publish the page, and preview it in a Web
Browser.
I have tried publishing but that shouldn't make a difference because I
am directly editing the directory where the Intranet pages are stored
via a mapped drive.
Also, when i try going through Database Results wizard while i'm
editing pages (while sitting at the Intranet server) it gets to the
Record Source page and returns an error "The server encounterd an
error while processing a database request".
Is there a correct configuration for IIS in order to connect to
databases. I assumed that this shouldn't be so difficult since these
are microsoft products that are involved. Do I need to configure the
ODBC (under admin tools on the server) for connectivity to external
access and SQL server DB's???
If there's anyone out there that can help, I would really appreciate
it. Thanks