Can't access SQL Server with Qdesign

Robert Edis robeconsult@sbcglobal.net
Tue, 9 Nov 2004 22:11:55 -0600


Thanks Jeff

To my knowledge and in my experience SQLServer is case insensitive unless
explicitly set so.  I my case it is not.

Blue

> -----Original Message-----
> From: powerh-l-admin@lists.sowder.com
> [mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Jeff Hoffman
> Sent: Tuesday, November 09, 2004 3:56 PM
> To: powerh-l@lists.sowder.com
> Subject: Re: Can't access SQL Server with Qdesign
>
>
> Hi
>
> Could it have something to do with case, as table & field names are case
> sensitive? There is a setting on the DB specification and in the
> dictionary.
>
> Jeff
>
> At 08:03 AM 09-11-04 -0800, you wrote:
> >G'day all
> >
> >Env: PH 8.4D1, Win2K, SQL Server 8.
> >
> >I can't read the same SQL Server database in Quiz,
> >Qdesign, etc as I can in Axiant.  The dictionary was
> >created by Axiant.
> >
> >Is this because I'm missing something from the
> >license?
> >
> >This is the contents of the license file:
> >
> >SERVER myserver ANY  1701
> >DAEMON cognos1d C:\PROGRA~1\Cognos\POWERH~1
> >FEATURE PH8-TEMPORARY cognos1d 1.000 31-DEC-2004 0
> >CZOGOCODFE "0057190090 COGNOS INC. NI DEMO" DEMO
> >FEATURE PHWEB-TEMPORARY cognos1d 1.000 31-DEC-2004 0
> >ZWDREVOWKB "0057190090 COGNOS INC. NI DEMO" DEMO
> >
> >Any ideas?
> >
> >Blue
> >
> >= = = = = = = = = = = = = = = = = = = = = = = = = = = =
> >Mailing list: powerh-l@lists.sowder.com
> >Subscribe: "subscribe" in message body to
> powerh-l-request@lists.sowder.com
> >Unsubscribe: "unsubscribe <password>" in message body to
> powerh-l-request@lists.sowder.com
> >http://lists.sowder.com/mailman/listinfo/powerh-l
> >This list is closed, thus to post to the list you must be a subscriber.
> >
> +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
> +-+-+-+-+-+
> + Jeff Hoffman                          + e-mail:
> wonicon@optushome.com.au  +
> + Director                              +
>           +
> + WoniCon Pty Ltd   (ABN 93 083 502 630)+
>  ,-_|\    +
> + 21 Prices Circuit                     + voice: +61 2 9542 1527
> /     \   +
> + Woronora    NSW     2232              + fax:   +61 2 9576 7029
> \_,-._*   +
> + AUSTRALIA                             + mobile: 040 790 3929
>      v    +
> +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
> +-+-+-+-+-
> +
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.sowder.com
> Subscribe: "subscribe" in message body to
> powerh-l-request@lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message body to
> powerh-l-request@lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
>