Can't access SQL Server with Qdesign

[Joe Boyle]

a couple more options.

1.

try editing your license so that it contains only the two feature lines
below, this is usually ok for temporary keys; I recall that there was an
issue with the syntax in one of the first two lines and they arn't needed
anyway. Also you don't need the licence manager running when you have
temporary keys.

  FEATURE PH8-TEMPORARY cognos1d 1.000 31-DEC-2004 0 CZOGOCODFE
"0057190090COGNOS INC. NI DEMO" DEMO 
  FEATURE PHWEB-TEMPORARY cognos1d 1.000 31-DEC-2004 0 ZWDREVOWKB
"0057190090 COGNOS INC. NI DEMO" DEMO

2.

If the problem is case related you could add a table with tablename and
columnnames all in upper case and try to access that; or try the command
below which avoids typing any object name, 

  qshow subdict=search
  > show file detail
  > show database detail
or 
  quiz subdict=search
  > show file
  > show database

and then attempt access using the case as output from the above.


P.S. I think I had to setup the System DSN for access when running batch
files via the windows AT command to call quick, quiz, qtp or axiant in batch
queues. Also needed if you run a netd or dispatcher.


Regards, Joe.

This e-mail and all information contained in it is confidential and may be
legally privileged. If you are not the intended recipient, your access to
this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. The content of this 
e-mail and any attachments sent with it may have been altered without the
consent or knowledge of the author.

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Robert Edis
Sent: 10 November 2004 04:12
To: PH List
Subject: RE: Can't access SQL Server with Qdesign

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.
>


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.