Powerhouse 8.41B2 On Windows NT
Whittall, Conrad
Conrad.Whittall@Cognos.COM
Sun, 13 Oct 2002 19:02: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_01C2730C.A0F1FB10
Content-Type: text/plain
Hi Christian,
All you need in your PDL is a DATABASE statement like this...
DATABASE SurveyDB TYPE ODBC NULL VALUES ALLOWED OPEN SurveyDB
...and a valid ODBC Data Source Name corresponding to the name given in the
OPEN clause. I seem to remember that you might need to define this as a User
DSN, rather than a System DSN.
Best regards,
Conrad
Conrad Whittall
e-Learning Architect, Global Education Services
Cognos Incorporated, 3755 Riverside Drive, Ottawa, Ontario, K1G 4K9, Canada
-----Original Message-----
From: Hamel, Christian [mailto:chamel@ratiopharm.ca]
Sent: Friday 11 October 2002 20:27
To: 'powerh-l@lists.swau.edu'
Subject: Powerhouse 8.41B2 On Windows NT
Hello everyone,
I'm new to this list but and old user of Powerhouse on Risc/6000
(AIX/Unix) and also AS/400 (Currently). I just got the beta version of
Powerhouse that runs on Windows NT/2000/XP. I'm trying to configure it to
access my SQL Server (MSDE) installed locally on my desktop. Due to lack of
documentation for this version (which is normal because it's still in beta),
I have no idea how to define information in my dictionary to access my
tables included in my MSDE database via an ODBC. Anyone of you use PH with
the same setup than me? That would help a lot. Thanks !
Christian Hamel
==========
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_01C2730C.A0F1FB10
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word"><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META content=3DWord.Document name=3DProgId>
<META content=3D"MSHTML 5.50.4913.1100" name=3DGENERATOR>
<META content=3D"Microsoft Word 10" name=3DOriginator><LINK=20
href=3D"cid:filelist.xml@01C27164.9A8F5C30" rel=3DFile-List><!--[if gte =
mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:HyphenationZone>21</w:HyphenationZone>
<w:EnvelopeVis/>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]-->
<STYLE>@page Section1 {size: 595.3pt 841.9pt; margin: 70.85pt 70.85pt =
70.85pt 70.85pt; mso-header-margin: 35.4pt; mso-footer-margin: 35.4pt; =
mso-paper-source: 0; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
SPAN.StyleCourrierlectronique17 {
COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: =
personal-compose; mso-style-noshow: yes; mso-ansi-font-size: 10.0pt; =
mso-bidi-font-size: 10.0pt; mso-ascii-font-family: Arial; =
mso-hansi-font-family: Arial; mso-bidi-font-family: Arial
}
SPAN.GramE {
mso-style-name: ""; mso-gram-e: yes
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 10]>
<style>
/* Style Definitions */=20
table.MsoNormalTable
{mso-style-name:"Tableau Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";}
</style>
<![endif]--></HEAD>
<BODY lang=3DFR style=3D"tab-interval: 35.4pt" vLink=3Dpurple =
link=3Dblue>
<DIV><SPAN class=3D267375622-13102002><FONT size=3D2>Hi=20
Christian,</FONT></SPAN></DIV>
<DIV><SPAN class=3D267375622-13102002><FONT =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D267375622-13102002><FONT size=3D2>All you need in =
your PDL is a=20
DATABASE statement like this...</FONT></SPAN></DIV>
<DIV><SPAN class=3D267375622-13102002><FONT size=3D1><FONT=20
size=3D2></FONT> </DIV>
<DIV><FONT size=3D2><STRONG><SPAN class=3D267375622-13102002>DATABASE=20
</SPAN>SurveyDB <SPAN class=3D267375622-13102002>TYPE </SPAN>ODBC =
NULL VALUES=20
ALLOWED <SPAN class=3D267375622-13102002>OPEN=20
</SPAN>SurveyDB</STRONG></FONT></DIV>
<DIV>
<P><SPAN class=3D267375622-13102002><FONT size=3D2>...and a valid ODBC =
Data Source=20
Name corresponding to the name given in the OPEN clause. I seem to =
remember that=20
you might need to define this as a User DSN, rather than a System=20
DSN.</FONT></SPAN></P><SPAN class=3D267375622-13102002>
<P><FONT face=3DVerdana size=3D2>Best regards,</FONT> <BR><B><I><FONT=20
face=3D"Times New Roman" color=3D#000080 =
size=3D6>Conrad</FONT></I></B><I></I> </P>
<P><B><FONT face=3DArial color=3D#808080 size=3D1>Conrad =
Whittall</FONT></B>=20
<BR><B><FONT face=3DArial color=3D#808080 size=3D1>e-Learning =
Architect, Global=20
Education Services</FONT></B> <BR><B><FONT face=3DArial color=3D#808080 =
size=3D1>Cognos Incorporated, 3755 Riverside Drive, Ottawa, Ontario, =
K1G 4K9,=20
Canada</FONT></B></P></SPAN></FONT></SPAN></DIV>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Hamel, Christian=20
[mailto:chamel@ratiopharm.ca]<BR><B>Sent:</B> Friday 11 October 2002=20
20:27<BR><B>To:</B> 'powerh-l@lists.swau.edu'<BR><B>Subject:</B> =
Powerhouse=20
8.41B2 On Windows NT<BR><BR></FONT></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN lang=3DEN-CA=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-ansi-language: =
EN-CA">Hello=20
everyone,<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN lang=3DEN-CA=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-ansi-language: =
EN-CA"><SPAN=20
style=3D"mso-tab-count: =
1"> =20
</SPAN>I'm new to this list but and old user of Powerhouse on Risc/6000 =
(AIX/Unix) and also AS/400 (Currently). <SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>I just got the beta version of =
Powerhouse=20
that runs on Windows NT/2000/XP.<SPAN style=3D"mso-spacerun: =
yes"> =20
</SPAN>I'm trying to configure it to access my SQL Server (MSDE) =
installed=20
locally on my desktop.<SPAN style=3D"mso-spacerun: yes"> =
</SPAN>Due to lack=20
of documentation for this version (which is normal because it's still =
in beta),=20
I have no idea how to define information in my dictionary to access my =
tables=20
included in my MSDE database via an ODBC.<SPAN style=3D"mso-spacerun: =
yes"> =20
</SPAN>Anyone of you use PH with the same setup than me? <SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>That would help a lot.<SPAN=20
style=3D"mso-spacerun: yes"> </SPAN><SPAN class=3DGramE>Thanks=20
!</SPAN><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN lang=3DEN-CA=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-ansi-language: =
EN-CA"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial><SPAN lang=3DEN-CA=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-ansi-language: =
EN-CA">Christian=20
Hamel</SPAN></FONT><FONT face=3DArial><SPAN lang=3DEN-CA=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-no-proof: =
yes"> <SPAN=20
class=3D267375622-13102002><FONT=20
face=3DVerdana> </FONT></SPAN></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial><SPAN lang=3DEN-CA=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-no-proof: yes"><SPAN=20
class=3D267375622-13102002></SPAN></SPAN></FONT> </P>
<P class=3DMsoNormal><FONT face=3DArial><SPAN lang=3DEN-CA=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-no-proof: yes"><SPAN=20
class=3D267375622-13102002><FONT=20
face=3DVerdana>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT></SPAN></SPAN></FONT=
></P>
<P class=3DMsoNormal><FONT face=3DArial><SPAN lang=3DEN-CA=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-no-proof: yes"><SPAN=20
class=3D267375622-13102002> </SPAN></SPAN></FONT><FONT =
face=3DArial><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-no-proof: =
yes"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: =
12pt"><o:p> </o:p></SPAN></FONT></P></DIV></BODY></HTML>
<BR>
<P><FONT SIZE=3D2 FACE=3D"Arial">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>
------_=_NextPart_001_01C2730C.A0F1FB10--