Declaring SQL Server databases in PDL
Edis, Robert
Robert.Edis@blistex.com
Fri, 25 Jul 2003 14:42:35 -0500
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C352E4.E5EB9AB0
Content-Type: text/plain;
charset="iso-8859-1"
Thanks,
I using the beta version PH 8.41 B2. This has a copy of QUICK with it.
Blue
-----Original Message-----
From: Fortin, Jean-Pierre [mailto:Jean-Pierre.Fortin@cognos.com]
Sent: Friday, July 25, 2003 2:42 PM
To: 'Edis, Robert'; Powerh-L (E-mail)
Cc: Hasse, Christina; Whittall, Conrad
Subject: RE: Declaring SQL Server databases in PDL
Hi
There a version of PH for NT where you build the screen in order to execute
it.
/JP
-----Original Message-----
From: Edis, Robert [mailto:Robert.Edis@blistex.com]
Sent: Friday, July 25, 2003 3:29 PM
To: Powerh-L (E-mail)
Subject: RE: Declaring SQL Server databases in PDL
Thanks for the replies Conrad and Christina
I finally got it work using:
Database DM_COMMON &
Type ODBC &
Owner dbo &
NULL VALUES ALLOWED &
Open "DM_COMMON" &
Userid "cognos" &
Password "cognos"
However I still got the following error in QDESIGN after typing the
following:
>screen TEST html
>file T_BRANDS in DM_COMMON
>gen
>go
*E* Can't open the file specified on the AUTO program parameter.
(test)
-----Original Message-----
From: Whittall, Conrad [mailto:Conrad.Whittall@cognos.com]
Sent: Friday, July 25, 2003 2:15 PM
To: 'powerh-l@lists.swau.edu'
Subject: RE: Declaring SQL Server databases in PDL
Hi Blue,
For Microsoft SQL Server 2000 the recommended connection is ODBC. The
SQLSERVER type uses the old DB-LIB API and should only really be used for
SQL Server 6.5.
The final format of the DATABASE statement you show is probably most
appropriate, with the <database name> parameter being the ODBC DSN for the
database, as configured through the ODBC Administrator (in which case
username and password parameters can be omitted from the dictionary if they
are specified in the ODBC Administrator).
Best regards,
Conrad
Conrad Whittall
Solutions Architect, Global Customer Services
Cognos Incorporated, 3755 Riverside Drive, Ottawa, Ontario, K1G 4K9, Canada
-----Original Message-----
From: Edis, Robert [ mailto:Robert.Edis@blistex.com
<mailto:Robert.Edis@blistex.com> ]
Sent: 25 July 2003 14:56
To: Powerh-L (E-mail)
Subject: Declaring SQL Server databases in PDL
G'day all
It seems there are a number of ways to declare SQL Server databases in a
dictionary. For SQL Server 2000 what do y'all recommend?
E.g.
Database <database name> &
Type SQLSERVER &
Owner <owner name> &
NULL VALUES ALLOWED &
Open "<server name>|<database name>@<userid>/<password>"
or
Database <database name> &
Type ODBC &
Owner <owner name> &
NULL VALUES ALLOWED &
Open "<server name>|<database name>@<userid>/<password>"
or
Database <database name> &
Type ODBC &
NULL VALUES ALLOWED &
Open "<database name> &
Userid "<userid>" &
Password "<password>"
etc.
Blue
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Join us at Cognos' biggest event of the year Enterprise 2003, The Cognos
Business Forum. Taking place in over 25 cities around the world, it's an
opportunity for Business and IT leaders to learn about strategies for
driving performance. Visit http://www.cognos.com/enterprise03
<http://www.cognos.com/enterprise03> for more details.
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
Join us at Cognos' biggest event of the year Enterprise 2003, The Cognos
Business Forum. Taking place in over 25 cities around the world, it's an
opportunity for Business and IT leaders to learn about strategies for
driving performance. Visit http://www.cognos.com/enterprise03 for more
details.
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
------_=_NextPart_001_01C352E4.E5EB9AB0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: Declaring SQL Server databases in PDL</TITLE>
<META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=983314219-25072003><FONT face=Arial color=#0000ff
size=2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=983314219-25072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=983314219-25072003><FONT face=Arial color=#0000ff size=2>I
using the beta version PH 8.41 B2. This has a copy of QUICK with
it.</FONT></SPAN></DIV>
<DIV><SPAN class=983314219-25072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=983314219-25072003><FONT face=Arial color=#0000ff
size=2>Blue</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Fortin, Jean-Pierre
[mailto:Jean-Pierre.Fortin@cognos.com]<BR><B>Sent:</B> Friday, July 25, 2003
2:42 PM<BR><B>To:</B> 'Edis, Robert'; Powerh-L (E-mail)<BR><B>Cc:</B> Hasse,
Christina; Whittall, Conrad<BR><B>Subject:</B> RE: Declaring SQL Server
databases in PDL<BR><BR></FONT></DIV>
<DIV><SPAN class=546384019-25072003><FONT face=Arial color=#0000ff
size=2>Hi</FONT></SPAN></DIV>
<DIV><SPAN class=546384019-25072003><FONT face=Arial color=#0000ff
size=2>There a version of PH for NT where you build the screen in order to
execute it.</FONT></SPAN></DIV>
<DIV><SPAN class=546384019-25072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=546384019-25072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=546384019-25072003><FONT face=Arial color=#0000ff
size=2>/JP</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Edis, Robert
[mailto:Robert.Edis@blistex.com]<BR><B>Sent:</B> Friday, July 25, 2003 3:29
PM<BR><B>To:</B> Powerh-L (E-mail)<BR><B>Subject:</B> RE: Declaring SQL
Server databases in PDL<BR><BR></FONT></DIV>
<DIV><SPAN class=938102519-25072003><FONT face=Arial color=#0000ff
size=2>Thanks for the replies Conrad and Christina</FONT></SPAN></DIV>
<DIV><SPAN class=938102519-25072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=938102519-25072003><FONT face=Arial color=#0000ff size=2>I
finally got it work using:</FONT></SPAN></DIV>
<DIV><SPAN class=938102519-25072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=938102519-25072003><FONT
size=2>Database DM_COMMON &<FONT size=3>
<BR></FONT><FONT size=2> Type
ODBC &</FONT><FONT
size=3> </FONT></FONT></SPAN></DIV>
<DIV><SPAN class=938102519-25072003><FONT size=2><FONT size=3><FONT
size=2> Owner dbo &</FONT><BR></FONT><FONT
size=2> NULL VALUES ALLOWED & </FONT><BR><FONT
size=2> Open "DM_COMMON" &</FONT><FONT size=3>
<BR></FONT><FONT size=2> Userid "cognos" &</FONT><FONT
size=3> <BR></FONT><FONT size=2> Password
"cognos"</FONT><FONT size=3> </FONT></FONT></SPAN></DIV>
<DIV><SPAN class=938102519-25072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=938102519-25072003><FONT face=Arial color=#0000ff
size=2>However I still got the following error in QDESIGN after typing the
following:</FONT></SPAN></DIV>
<DIV><SPAN class=938102519-25072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=938102519-25072003><FONT face=Arial color=#0000ff
size=2>>screen TEST html</FONT></SPAN></DIV>
<DIV><SPAN class=938102519-25072003><FONT face=Arial color=#0000ff
size=2>>file T_BRANDS in DM_COMMON</FONT></SPAN></DIV>
<DIV><SPAN class=938102519-25072003><FONT face=Arial color=#0000ff
size=2>>gen</FONT></SPAN></DIV>
<DIV><SPAN class=938102519-25072003><FONT face=Arial color=#0000ff
size=2>>go</FONT></SPAN></DIV>
<DIV><SPAN class=938102519-25072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><FONT size=2>*E* Can't open the file specified on the AUTO program
parameter.<BR> (test)</FONT></DIV>
<DIV><SPAN class=938102519-25072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Whittall, Conrad
[mailto:Conrad.Whittall@cognos.com]<BR><B>Sent:</B> Friday, July 25, 2003
2:15 PM<BR><B>To:</B> 'powerh-l@lists.swau.edu'<BR><B>Subject:</B> RE:
Declaring SQL Server databases in PDL<BR><BR></FONT></DIV>
<P><FONT size=2>Hi Blue,</FONT> </P>
<P><FONT size=2>For Microsoft SQL Server 2000 the recommended connection
is ODBC. The SQLSERVER type uses the old DB-LIB API and should only really
be used for SQL Server 6.5.</FONT></P>
<P><FONT size=2>The final format of the DATABASE statement you show is
probably most appropriate, with the <database name> parameter being
the ODBC DSN for the database, as configured through the ODBC
Administrator (in which case username and password parameters can be
omitted from the dictionary if they are specified in the ODBC
Administrator).</FONT></P>
<P><FONT size=2>Best regards,</FONT> <BR><FONT size=2>Conrad</FONT> </P>
<P><FONT size=2>Conrad Whittall</FONT> <BR><FONT size=2>Solutions
Architect, Global Customer Services</FONT> <BR><FONT size=2>Cognos
Incorporated, 3755 Riverside Drive, Ottawa, Ontario, K1G 4K9,
Canada</FONT> </P>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From:
Edis, Robert [<A
href="mailto:Robert.Edis@blistex.com">mailto:Robert.Edis@blistex.com</A>]</FONT>
<BR><FONT size=2>Sent: 25 July 2003 14:56</FONT> <BR><FONT size=2>To:
Powerh-L (E-mail)</FONT> <BR><FONT size=2>Subject: Declaring SQL Server
databases in PDL</FONT> </P><BR>
<P><FONT size=2>G'day all</FONT> </P>
<P><FONT size=2>It seems there are a number of ways to declare SQL Server
databases in a</FONT> <BR><FONT size=2>dictionary. For SQL Server
2000 what do y'all recommend?</FONT> </P>
<P><FONT size=2>E.g.</FONT> <BR><FONT size=2>Database <database
name> &</FONT> <BR><FONT
size=2> Type
SQLSERVER &</FONT> <BR><FONT
size=2> Owner <owner
name>
&</FONT> <BR><FONT size=2> NULL VALUES ALLOWED
& </FONT><BR><FONT size=2> Open "<server
name>|<database name>@<userid>/<password>"</FONT>
</P>
<P><FONT size=2>or</FONT> </P>
<P><FONT size=2>Database <database name>
&</FONT> <BR><FONT size=2> Type
ODBC &</FONT> <BR><FONT
size=2> Owner <owner
name>
&</FONT> <BR><FONT size=2> NULL VALUES ALLOWED
& </FONT><BR><FONT size=2> Open "<server
name>|<database name>@<userid>/<password>"</FONT>
</P>
<P><FONT size=2>or</FONT> </P>
<P><FONT size=2>Database <database name>
&</FONT> <BR><FONT size=2> Type
ODBC &</FONT> <BR><FONT
size=2> NULL VALUES ALLOWED & </FONT><BR><FONT
size=2> Open "<database name> &</FONT>
<BR><FONT size=2> Userid "<userid>" &</FONT>
<BR><FONT size=2> Password "<password>"</FONT>
</P>
<P><FONT size=2>etc.</FONT> </P>
<P><FONT size=2>Blue</FONT> </P>
<P><FONT size=2>= = = = = = = = = = = = = = = = = = = = = = = = = = =
=</FONT> </P><BR>
<P><FONT size=2>Join us at Cognos' biggest event of the year<I> Enterprise
2003, The Cognos Business Forum</I>. Taking place in over 25 cities
around the world, it's an opportunity for Business and IT leaders to learn
about strategies for driving performance. Visit<U> <A
href="http://www.cognos.com/enterprise03"
target=_blank>http://www.cognos.com/enterprise03</A></U> for more details.
</FONT></P>
<P><FONT size=2>This message may contain privileged and/or confidential
information. If you have received this e-mail in error or are not
the intended recipient, you may not use, copy, disseminate or distribute
it; do not open any attachments, delete it immediately from your system
and notify the sender promptly by e-mail that you have done so.
Thank you.</FONT></P></BLOCKQUOTE></BLOCKQUOTE><BR>
<P><FONT face=Arial size=2>Join us at Cognos' biggest event of the year<I>
Enterprise 2003, The Cognos Business Forum</I>. Taking place in over 25 cities
around the world, it's an opportunity for Business and IT leaders to learn
about strategies for driving performance. Visit<U>
http://www.cognos.com/enterprise03</U> for more details. </FONT></P><BR>
<P><FONT face=Arial size=2>This message may contain privileged and/or
confidential information. If you have received this e-mail in error or are not
the intended recipient, you may not use, copy, disseminate or distribute it;
do not open any attachments, delete it immediately from your system and notify
the sender promptly by e-mail that you have done so. Thank
you.</FONT></P></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C352E4.E5EB9AB0--