*W* SQL START DBE error with SQL Server

[Peter Bateman]

Blue:

I would turn on ODBC logging to see what is being sent by both PowerHouse 
and Impromptu. DrDeeBee or some such trace facility
should help.

I believe the connect string is case sensitive for SQL Server.
I would try putting quotes around my connect string.

You may want to turn off upshifting of identifiers:-
SET SHIFT NOSHIFT or later I think SET NOSHIFT in PDL.

Some versions of PowerHouse allowed you put your connect string
in an environment variable.

SET MYCONNECT=DM_Sales@userid/password

DATABASE Sales &
    TYPE ODBC    &
    DESCRIPTION "Sales Reporting Data Mart" &
   NULL VALUES ALLOWED &
    OPEN $MYCONNECT

Good luck,

Peter Bateman









>From: "Edis, Robert" <Robert.Edis@blistex.com>
>To: "'powerh-l@lists.swau.edu'" <powerh-l@lists.swau.edu>
>Subject: *W* SQL START DBE error with SQL Server
>Date: 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
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.swau.edu
>Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
>Unsubscribe: "unsubscribe" in message body to 
>powerh-l-request@lists.swau.edu
>http://lists.swau.edu/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.


_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail