Provider problem in .asp page

Posted 2010-12-16 14:58
by Cedric BOREUX
in the Oracle Forum

Hi,

I've installed a Windows Server 2008, with Oracle 10g client...

The old provider in my ".asp" page doesn't work (Windows Server 2003 + Oracle 9i client):

conn.open "Provider=MSDAORA;Data Source=xxx;User ID=yyy;Password=zzz;"

Reading your article, i've replaced with the following :

conn.open "Provider=OraOleDB.Oracle;Data Source=xxx;User ID=yyy;Password=zzz;"

It works fine... But all the queries return only ONE ROW !

If i replace with

conn.open "Provider={Oracle dans Ora10G};Data Source=xxx;User ID=yyy;Password=zzz;"

It works fine...

What's the problem with OraOleDB.Oracle ????

Best Regards