<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:D="DAV:" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.boldbodycopy
{mso-style-name:boldbodycopy;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>You might try starting IronPython with –X:ExceptionDetail to get
the full stack trace and the CLR exception info. That’s likely to be more
useful in this case than the python exception display you’re seeing here. Once
you’ve got the right exception name a search on the web might tell you what
causes that specific error.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
users-bounces@lists.ironpython.com [mailto:users-bounces@lists.ironpython.com] <b>On
Behalf Of </b>jane janet<br>
<b>Sent:</b> Wednesday, August 29, 2007 10:24 AM<br>
<b>To:</b> users@lists.ironpython.com<br>
<b>Subject:</b> [IronPython] IronPython and Oracle<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<div>
<p>Dear Everybody,<o:p></o:p></p>
<p> I installed <span class=boldbodycopy>Oracle Database 10<i>g</i>
Express Edition (Universal) on the Server Host.</span><o:p></o:p></p>
<p><span class=boldbodycopy>And then, I used Ironpython access this database on
server host by Microsoft OLE DB Provider for Oracle. It's work.</span><o:p></o:p></p>
<p style='margin-left:.5in'><b><span style='font-size:10.0pt;color:#FF0080'>import
clr<o:p></o:p></span></b></p>
<p style='margin-left:.5in'><b><span style='font-size:10.0pt;color:#FF0080'>import
System<o:p></o:p></span></b></p>
<p style='margin-left:.5in'><b><span style='font-size:10.0pt;color:#FF0080'>clr.AddReference("System.Data")<o:p></o:p></span></b></p>
<p style='margin-left:.5in'><b><span style='font-size:10.0pt;color:#FF0080'>from
System.Data import DataSet <o:p></o:p></span></b></p>
<p style='margin-left:.5in'><b><span style='font-size:10.0pt;color:#FF0080'>from
System.Data.OleDb import OleDbConnection, OleDbDataAdapter, OleDbCommand<o:p></o:p></span></b></p>
<p style='margin-left:.5in'><b><span style='font-size:10.0pt;color:#FF0080'>conStr
= "Provider=MSDAORA.1;User ID=name;Password=pwd;Persist Security
Info=False"<o:p></o:p></span></b></p>
<p style='margin-left:.5in'><b><span style='font-size:10.0pt;color:#FF0080'>con
= OleDbConnection(conStr)<o:p></o:p></span></b></p>
<p style='margin-left:.5in'><b><span style='font-size:10.0pt;color:#FF0080'>query
= "SELECT * FROM TEST"<o:p></o:p></span></b></p>
<p style='margin-left:.5in'><b><span style='font-size:10.0pt;color:#FF0080'>adapter
= OleDbDataAdapter(query,con)<o:p></o:p></span></b></p>
<p style='margin-left:.5in'><b><span style='font-size:10.0pt;color:#FF0080'>ds
= DataSet()<o:p></o:p></span></b></p>
<p style='margin-left:.5in'><b><span style='font-size:10.0pt;color:#FF0080'>con.Open()<o:p></o:p></span></b></p>
<p style='margin-left:.5in'><b><span style='font-size:10.0pt;color:#FF0080'>adapter.Fill(ds,"t1")<o:p></o:p></span></b></p>
<p style='margin-left:.5in'><b><span style='font-size:10.0pt;color:#FF0080'>for
i in range(ds.Tables["t1"].Rows.Count -1 ):<o:p></o:p></span></b></p>
<p style='margin-left:.5in'><b><span style='font-size:10.0pt;color:#FF0080'>print
ds.Tables["t1"].Rows[i][0]<o:p></o:p></span></b></p>
<p style='margin-left:.5in'><b><span style='font-size:10.0pt;color:#FF0080'>print
ds.Tables["t1"].Rows[i][1]<o:p></o:p></span></b></p>
<p style='margin-left:.5in'><b><span style='font-size:10.0pt;color:#FF0080'>print
ds.Tables["t1"].Rows[i][2]<o:p></o:p></span></b></p>
<p><b><span style='font-size:10.0pt;color:#FF0080'>con.Close()<o:p></o:p></span></b></p>
<p>But my problem is I can't access Oracle Server side from client side by the
same provider.<o:p></o:p></p>
<p>I changed conStr to this<o:p></o:p></p>
<p>conStr = """Provider=MSDAORA.1;User ID=name;Password=pwd;<br>
(DESCRIPTION=(CONNECT_DATA=(SID =XE)<br>
(CID=(PROGRAM=C:\WINDOWS\system32\Rundll32.exe)<br>
(HOST=hostname)(USER=name)))<br>
(ADDRESS=(PROTOCOL=TCP)(HOST=xx.yy.zz.ww)<br>
(PORT=1521)))"""<o:p></o:p></p>
<p>I got EnvironmentError: ORA-12560: TNS:protocol adapter error<o:p></o:p></p>
<p>I don't know how to solve this problem.<o:p></o:p></p>
<p>Please help me everything i missed and everything i should know. What I
should do or change something, please tell me.<o:p></o:p></p>
<p>Thank you.<o:p></o:p></p>
<p><br>
<br>
<o:p></o:p></p>
<div>
<p align=center style='text-align:center'> <o:p></o:p></p>
</div>
</div>
</div>
<p class=MsoNormal><br clear=all>
<o:p></o:p></p>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=2 width="100%" align=center>
</div>
<p class=MsoNormal><a href="http://g.msn.com/8HMAENUS/2728??PS=47575"
target="_top">Puzzles, trivia teasers, word scrambles and more. Play for your
chance to win!</a> <o:p></o:p></p>
</div>
</body>
</html>