Declaring SQL Server databases in PDL

Fri, 25 Jul 2003 14:28:48 -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_01C352E2.F8FD9240
Content-Type: text/plain;
	charset="iso-8859-1"

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.

------_=_NextPart_001_01C352E2.F8FD9240
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>Thanks 
for the replies Conrad and Christina</DIV>
<DIV>&nbsp;</DIV>
<DIV>I 
finally got it work using:</DIV>
<DIV>&nbsp;</DIV>
<DIV>Database&nbsp;DM_COMMON&nbsp;&nbsp;&nbsp;&nbsp; &amp; 
 &nbsp;&nbsp;&nbsp; Type 
ODBC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;&nbsp;</DIV>
<DIV>&nbsp;&nbsp;&nbsp; Owner dbo &amp; &nbsp;&nbsp;&nbsp; NULL VALUES ALLOWED&nbsp; &amp; &nbsp;&nbsp;&nbsp; Open "DM_COMMON" &amp; 
 &nbsp;&nbsp;&nbsp; Userid "cognos" &amp; &nbsp;&nbsp;&nbsp; Password "cognos" </DIV>
<DIV>&nbsp;</DIV>
<DIV>However I still got the following error in QDESIGN after typing the 
following:</DIV>
<DIV>&nbsp;</DIV>
<DIV>&gt;screen TEST html</DIV>
<DIV>&gt;file T_BRANDS in DM_COMMON</DIV>
<DIV>&gt;gen</DIV>
<DIV>&gt;go</DIV>
<DIV>&nbsp;</DIV>
<DIV>*E* Can't open the file specified on the AUTO program 
parameter. &nbsp; (test)</DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
 <DIV class=OutlookMessageHeader dir=ltr align=left>-----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 </DIV>
 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 &lt;database name&gt; 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 [<A 
 href="mailto:Robert.Edis@blistex.com">mailto:Robert.Edis@blistex.com</A>] 
 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.&nbsp; For SQL Server 2000 
 what do y'all recommend? 
 E.g. Database &lt;database 
 name&gt;&nbsp;&nbsp;&nbsp;&nbsp; &amp; &nbsp;&nbsp;&nbsp; Type SQLSERVER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 &amp; &nbsp;&nbsp;&nbsp; Owner &lt;owner 
 name&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 &amp; &nbsp;&nbsp;&nbsp; NULL VALUES ALLOWED&nbsp; 
 &amp; &nbsp;&nbsp;&nbsp; Open "&lt;server 
 name&gt;|&lt;database name&gt;@&lt;userid&gt;/&lt;password&gt;" 
 or 
 Database &lt;database name&gt;&nbsp;&nbsp;&nbsp;&nbsp; 
 &amp; &nbsp;&nbsp;&nbsp; Type 
 ODBC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp; &nbsp;&nbsp;&nbsp; Owner &lt;owner 
 name&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 &amp; &nbsp;&nbsp;&nbsp; NULL VALUES ALLOWED&nbsp; 
 &amp; &nbsp;&nbsp;&nbsp; Open "&lt;server 
 name&gt;|&lt;database name&gt;@&lt;userid&gt;/&lt;password&gt;" 
 or 
 Database &lt;database name&gt;&nbsp;&nbsp;&nbsp;&nbsp; 
 &amp; &nbsp;&nbsp;&nbsp; Type 
 ODBC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp; &nbsp;&nbsp;&nbsp; NULL VALUES ALLOWED&nbsp; &amp; &nbsp;&nbsp;&nbsp; Open "&lt;database name&gt; &amp; &nbsp;&nbsp;&nbsp; Userid "&lt;userid&gt;" &amp; &nbsp;&nbsp;&nbsp; Password "&lt;password&gt;" 
 etc. 
 Blue 
 = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 
 Join us at Cognos' biggest event of the year Enterprise 
 2003, The Cognos Business Forum.&nbsp; 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 <A 
 href="http://www.cognos.com/enterprise03" 
 target=_blank>http://www.cognos.com/enterprise03</A> for more details. 
 
 This message may contain privileged and/or confidential 
 information.&nbsp; 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.&nbsp; Thank 
 you.</BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C352E2.F8FD9240--