BUG: Error Creating Data Source Name (DSN) in OLAP Manager (221996)


The information in this article applies to:

  • Microsoft SQL Server OLAP Services 7.0
This article was previously published under Q221996
BUG #: 570 (plato7x)

SYMPTOMS

While trying to create a data source in OLAP Manager, the data source is not created and the following error message occurs:
Server initializing Data Source 'ODBC-Default Dir=D temp;Driver=Microsoft..'
The error message displays when all of the following are true:
  • When a new data source with provider as "Microsoft OLE DB Provider for ODBC Drivers" is being defined.
  • A connection string is used to specify the source of data.
  • The initial catalog is not specified.

WORKAROUND

You can use either one of the following two workarounds:
  • Specify a value for the initial catalog field.

    -or-
  • Use the data source name instead of the connection string in the connection tab.

STATUS

Microsoft has confirmed this to be a problem in SQL Server OLAP Services version 7.0.
Modification Type:MajorLast Reviewed:10/16/2003
Keywords:kbBug kbpending KB221996
©2003 Microsoft Corporation. All rights reserved.