Can't access SQL Server with Qdesign

[Robert Edis]

To all good people who responded, this is the error
I'm getting in Qshow:

> sho records in DW
*E* SQL Access error (DW)
DMS-E-GENERAL, A general exception has occurred during
operation 'attach
database'.
[Microsoft][ODBC SQL Server Driver]Dialog failed

The weird thing is I was able to run a simple Quiz
against a specific table in this database and this
time I got data back without an error.

The PDL syntax for attaching to this database is:

Database DW    Type ODBC NULL VALUES ALLOWED Open
"DM_Common_UPD"

Blue


--- Glenn <glenn@baxterit.com.au> wrote:

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