<html><div style='background-color:'><DIV>
<P>Dear Everybody,</P>
<P> I installed <SPAN class=boldbodycopy>Oracle Database 10<I>g</I> Express Edition (Universal) on the Server Host.</SPAN></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><BR></P>
<DIR><B><FONT color=#ff0080 size=2>
<P>import clr</P>
<P>import System</P>
<P>clr.AddReference("System.Data")</P>
<P>from System.Data import DataSet </P>
<P>from System.Data.OleDb import OleDbConnection, OleDbDataAdapter, OleDbCommand</P>
<P>conStr = "Provider=MSDAORA.1;User ID=name;Password=pwd;Persist Security Info=False"</P>
<P>con = OleDbConnection(conStr)</P>
<P>query = "SELECT * FROM TEST"</P>
<P>adapter = OleDbDataAdapter(query,con)</P>
<P>ds = DataSet()</P>
<P>con.Open()</P>
<P>adapter.Fill(ds,"t1")</P>
<P>for i in range(ds.Tables["t1"].Rows.Count -1 ):</P>
<P>print ds.Tables["t1"].Rows[i][0]</P>
<P>print ds.Tables["t1"].Rows[i][1]</P>
<P>print ds.Tables["t1"].Rows[i][2]</P></DIR>
<P>con.Close()</P>
<P></B></FONT>But my problem is I can't access Oracle Server side from client side by the same provider.</P>
<P>I changed conStr to this</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)))"""</P>
<P>I got EnvironmentError: ORA-12560: TNS:protocol adapter error</P>
<P>I don't know how to solve this problem.</P>
<P>Please help me everything i missed and everything i should know. What I should do or change something, please tell me.</P>
<P>Thank you.</P>
<P><BR><BR> </P>
<DIV>
<P align=center> </P></DIV></DIV></div><br clear=all><hr> <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> </html>