Hi - My question concerns whether or not I can output my .htm page to a networked server that is not a SQL Server server. I am using SQL Server 7 and NT 4.
The following was copied from the Books OnLine documentation for the Web Assistant Wizard :
Using Web Assistant Wizard Publishing Options
There are four dialog boxes to help you publish your Web page and identify file locations, titles, reference text, and reference links.
The Publishing screen offers these options.
Option Description
Where do you want to publish this Web page? Specifies where to publish the Web Page. The path name and file name entered here is relative to where Microsoft® SQL Server™ is running. The default file specification is C:\MSSQL7\WebPage1.htm. You need adequate privileges to create files in the specified directory.
Facts: If I tell it to write the web page to a location on the server that is actually running the Web Task, everything is fine, the htm page is written to this server.
Problem: I need the .htm file to be written to another server (it is a networked web server but one that is not running SQL Server). When I attempt to change the file location setting to
"\\APPS_SERVER2\WEB\DIRSHIP\LoadStatuses.htm" I get an error from the Web Assistant.... "Could not create the file \\APPS_SERVER2\WEB\DIRSHIP\LoadStatuses.htm Please enter a different file name".
This is a valid path that exists. What could be the problem?
Thanks for any and all ideas. John
The following was copied from the Books OnLine documentation for the Web Assistant Wizard :
Using Web Assistant Wizard Publishing Options
There are four dialog boxes to help you publish your Web page and identify file locations, titles, reference text, and reference links.
The Publishing screen offers these options.
Option Description
Where do you want to publish this Web page? Specifies where to publish the Web Page. The path name and file name entered here is relative to where Microsoft® SQL Server™ is running. The default file specification is C:\MSSQL7\WebPage1.htm. You need adequate privileges to create files in the specified directory.
Facts: If I tell it to write the web page to a location on the server that is actually running the Web Task, everything is fine, the htm page is written to this server.
Problem: I need the .htm file to be written to another server (it is a networked web server but one that is not running SQL Server). When I attempt to change the file location setting to
"\\APPS_SERVER2\WEB\DIRSHIP\LoadStatuses.htm" I get an error from the Web Assistant.... "Could not create the file \\APPS_SERVER2\WEB\DIRSHIP\LoadStatuses.htm Please enter a different file name".
This is a valid path that exists. What could be the problem?
Thanks for any and all ideas. John