Can't access SQL Server with Qdesign

[Robert Edis]

Thanks Joe

I'll try that syntax though I believe I've tried it
before.  I want to use NT logons as well so putting a
specific user won't do in the run.

Blue
--- Joe Boyle <joeboyle_adt@hotmail.com> wrote:

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