The OLAP provider is not properly resolving the IP address; instead, it expects the server name to be specified. OLAP handles the Data Source name with a dot in it as a file name, rather than an IP address.

Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

This functionality is documented in the OLAP Books Online topic, as follows:

DBPROP_INIT_DATASOURCE Property:
Name of the server computer or local cube file.
Remarks:
This property's name, which is used in the connection string, is Data Source.
The property's value depends on the intended operation mode:
To work with an OLAP server, specify the name of the server computer, or LOCALHOST, or LOCAL, or an IP address.