Can't access SQL Server with Qdesign
Robert Edis
robeconsult@sbcglobal.net
Wed, 10 Nov 2004 12:45:00 -0800 (PST)
Thanks Joe
If I have the DSN setup both at user and system levels
could PowerHouse somehow be getting confused?
Blue
--- Joe Boyle <joeboyle_adt@hotmail.com> wrote:
> 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.
>