Declaring SQL Server databases in PDL
Whittall, Conrad
Conrad.Whittall@Cognos.COM
Fri, 25 Jul 2003 15:14:39 -0400
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_01C352E0.FE7BBD20
Content-Type: text/plain;
charset="iso-8859-1"
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]
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 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_01C352E0.FE7BBD20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.89">
<TITLE>RE: Declaring SQL Server databases in PDL</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Hi Blue,</FONT>
</P>
<P><FONT SIZE=3D2>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=3D2>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=3D2>Best regards,</FONT>
<BR><FONT SIZE=3D2>Conrad</FONT>
</P>
<P><FONT SIZE=3D2>Conrad Whittall</FONT>
<BR><FONT SIZE=3D2>Solutions Architect, Global Customer Services</FONT>
<BR><FONT SIZE=3D2>Cognos Incorporated, 3755 Riverside Drive, Ottawa, =
Ontario, K1G 4K9, Canada</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Edis, Robert [<A =
HREF=3D"mailto:Robert.Edis@blistex.com">mailto:Robert.Edis@blistex.com</=
A>]</FONT>
<BR><FONT SIZE=3D2>Sent: 25 July 2003 14:56</FONT>
<BR><FONT SIZE=3D2>To: Powerh-L (E-mail)</FONT>
<BR><FONT SIZE=3D2>Subject: Declaring SQL Server databases in =
PDL</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>G'day all</FONT>
</P>
<P><FONT SIZE=3D2>It seems there are a number of ways to declare SQL =
Server databases in a</FONT>
<BR><FONT SIZE=3D2>dictionary. For SQL Server 2000 what do y'all =
recommend?</FONT>
</P>
<P><FONT SIZE=3D2>E.g.</FONT>
<BR><FONT SIZE=3D2>Database <database =
name> &</FONT>
<BR><FONT SIZE=3D2> Type =
SQLSERVER &</FONT>
<BR><FONT SIZE=3D2> Owner <owner =
name> &nbs=
p; &</FONT>
<BR><FONT SIZE=3D2> NULL VALUES ALLOWED & =
</FONT>
<BR><FONT SIZE=3D2> Open "<server =
name>|<database =
name>@<userid>/<password>"</FONT>
</P>
<P><FONT SIZE=3D2>or</FONT>
</P>
<P><FONT SIZE=3D2>Database <database =
name> &</FONT>
<BR><FONT SIZE=3D2> Type =
ODBC &</FONT>
<BR><FONT SIZE=3D2> Owner <owner =
name> &nbs=
p; &</FONT>
<BR><FONT SIZE=3D2> NULL VALUES ALLOWED & =
</FONT>
<BR><FONT SIZE=3D2> Open "<server =
name>|<database =
name>@<userid>/<password>"</FONT>
</P>
<P><FONT SIZE=3D2>or</FONT>
</P>
<P><FONT SIZE=3D2>Database <database =
name> &</FONT>
<BR><FONT SIZE=3D2> Type =
ODBC &</FONT>
<BR><FONT SIZE=3D2> NULL VALUES ALLOWED & =
</FONT>
<BR><FONT SIZE=3D2> Open "<database name> =
&</FONT>
<BR><FONT SIZE=3D2> Userid "<userid>" =
&</FONT>
<BR><FONT SIZE=3D2> Password =
"<password>"</FONT>
</P>
<P><FONT SIZE=3D2>etc.</FONT>
</P>
<P><FONT SIZE=3D2>Blue</FONT>
</P>
<P><FONT SIZE=3D2>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>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=3D"http://www.cognos.com/enterprise03" =
TARGET=3D"_blank">http://www.cognos.com/enterprise03</A></U> for more =
details. </FONT></P>
<P><FONT SIZE=3D2>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>
</BODY>
</HTML>
------_=_NextPart_001_01C352E0.FE7BBD20--