I can see an IIS Server but connot see as SQL Server on same PC thru ODBC. Why?

Why is it that I can see a remote server in the browser on a workstation by typing in

ftp://MY_IIS_SERVER

but I cannot see an SQL Server 7.0 database on that same remmote PC. In other words, I cannot manually set up a Data Source Name for that SQL Server.

This happens only on WIN NT 4.0 boxes.First from your workstation can you ping MY_IIS_SERVER, if so then check that you have TCP/IP enabled using the 'Client Network Utility' that comes with SQL Server.

If you can not ping MY_IIS_SERVER, can you ping the IP address, xxx.xxx.xxx. If so then again make sure TCP/IP is enabled and then do 1 of 2.

1) Add an entry in LMHOST for MY_IIS_SERVER xxx.xxx.xxx
or
2) Use SQL Server Client Network Utility and add an alias to MY_IIS_SERVER

Hyperlink to file on shared drive

1. No, hosting the file on a web/ftp server is not possible.
2. Yes I know about the Jump-to-URL section.
3. Only http. https, ftp, mailto and news work. file does not.
4. Embedding Javascript (window.open('file://foo/bar.txt')) works, but
only if hardcoded, which is useless.
Is there a particular reason for this? Is this going to be fixed? My
client has thousands of files that lie on shared drive. I need to
create links to these in a manner such as:
<a href="http://links.10026.com/?link=file://s:\directory\file.txt">link</a>
I don't understand why you would limit the anchor tag? According to
RFC http://www.ietf.org/rfc/rfc1738.txt (This document specifies a
Uniform Resource Locator (URL), the syntax and semantics of formalized
information for location and access of resources via the Internet.)
You can state the following:
...
ftp File Transfer protocol
http Hypertext Transfer Protocol
mailto Electronic mail address
news USENET news
file Host-specific file names
...
Yes, I know that:
"The file URL scheme is used to designate files accessible on a
particular host computer. This scheme, unlike most other URL schemes,
does not designate a resource that is universally accessible over the
Internet"
But the thing is, MS Reports are for private networks, as well as
public ones. Why were the specs not followed?
Regards,
Roy AssalyAnyone? Bueller? Bueller? So I take it's impossible. Nobody in
Microsoft land knows if this will be fixed?
Roy Assaly wrote:
> 1. No, hosting the file on a web/ftp server is not possible.
> 2. Yes I know about the Jump-to-URL section.
> 3. Only http. https, ftp, mailto and news work. file does not.
> 4. Embedding Javascript (window.open('file://foo/bar.txt')) works, but
> only if hardcoded, which is useless.
> Is there a particular reason for this? Is this going to be fixed? My
> client has thousands of files that lie on shared drive. I need to
> create links to these in a manner such as:
> <a href="http://links.10026.com/?link=file://s:\directory\file.txt">link</a>
> I don't understand why you would limit the anchor tag? According to
> RFC http://www.ietf.org/rfc/rfc1738.txt (This document specifies a
> Uniform Resource Locator (URL), the syntax and semantics of formalized
> information for location and access of resources via the Internet.)
> You can state the following:
> ...
> ftp File Transfer protocol
> http Hypertext Transfer Protocol
> mailto Electronic mail address
> news USENET news
> file Host-specific file names
> ...
> Yes, I know that:
> "The file URL scheme is used to designate files accessible on a
> particular host computer. This scheme, unlike most other URL schemes,
> does not designate a resource that is universally accessible over the
> Internet"
> But the thing is, MS Reports are for private networks, as well as
> public ones. Why were the specs not followed?
> Regards,
> Roy Assaly