*W* SQL START DBE error with SQL Server

Edis, Robert Robert.Edis@blistex.com
Wed, 26 Feb 2003 12:43:29 -0600


G'day all

Environment:
PowerHouse 8.20
Windows 2000
SQL Server 2000 (via ODBC/DSN)

I am getting the following error in Quiz when trying to access a SQL Server
database:

*W* SQL START DBE error (SALES)
DMS-E-DBACCESS, It was not possible to access the 'SALES' database.
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified

The PDL database reference is:

DATABASE Sales &
  TYPE ODBC    &
  DESCRIPTION "Sales Reporting Data Mart" &
  NULL VALUES ALLOWED &
  OPEN DM_Sales@userid/password

The DSN has been created at both user and system levels in the ODBC
administrator and Axiant and Impromptu have no problem using it.

Any ideas?

Blue