Can't access SQL Server with Qdesign

Glenn Glenn" <glenn@baxterit.com.au
Wed, 10 Nov 2004 06:16:34 +1100


Hi Blue,
What is the extact error message?
While you set the database types to Sql for script creation from within
Axiant, it/they must be set to ODBC for the dictionary build and subsequent
access to the data.
If running thin client, only the Server requires each database to have an
ODBC registration.
Once working, you can export the server registry entries from the server and
import them to a client machine for Axiant IDE development.
>From the server or client, you must then use either environment variables or
command line "dict = " to path the dictionary, for command line work.
I have used Sql Version 7 and 2000 in this manner.
Command line quiz/qtp/qdesign use also requires full qualification of the
table as per
Access dbo.table in database which is optional from within Axiant when
building compiled objects.

In short, without the error message it's a bit hard to say.
If Axiant operates Ok, you could assume that the license is Ok.
Sincerely,
Glenn Baxter
Baxter IT Solutions
=======================
456 Victoria Parade, East Melbourne
Victoria Australia 3002
=======================
telephone: +61-3-9415-8733
mobile: 0412-826-503
fax: +61-3-9415-8911

----- Original Message ----- 
From: "Robert Edis" <robeconsult@sbcglobal.net>
To: "PowerHouse List" <powerh-l@lists.sowder.com>
Sent: Wednesday, November 10, 2004 3:03 AM
Subject: Can't access SQL Server with Qdesign


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