Can't access SQL Server with Qdesign

[Joe Boyle]

one other thing, I found the database syntax format below in some old notes,

   database pubs  type odbc   null values allowed   open   "pubs" 
   owner dbo userid "test"  password "test"

whereas your syntax is below,

   Database DW    Type ODBC NULL VALUES ALLOWED Open "DM_Common_UPD"

Unless you have left out details, it might be worth adding more syntax


-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Robert Edis
Sent: 09 November 2004 20:22
To: PowerHouse List
Subject: Re: Can't access SQL Server with Qdesign

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

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