Can't access SQL Server with Qdesign
Joe Boyle
joeboyle_adt@hotmail.com
Wed, 10 Nov 2004 21:39:35 -0000
I'm pretty certain that I had them both set all of the time, and I did'nt
see any problem. I think that who you are logged in as determines which DSN
is used.
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 20:45
To: PowerHouse List
Subject: RE: Can't access SQL Server with Qdesign
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.
>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.