Forum Stats

  • 3,827,674 Users
  • 2,260,803 Discussions


Provider problem in .asp page

824547 Member Posts: 14
edited Dec 16, 2010 10:27AM in Oracle Provider for OLE DB

The actual provider in my ".asp" page on Windows Server 2003 + Oracle 9i client is : "Provider=_MSDAORA_;Data Source=xxx;User ID=yyy;Password=zzz;"

I've installed a Windows Server 2008, with Oracle 10g client and this provider doesn't work...

I've replaced with the following : "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

* "Provider=_{Oracle in Ora10G}_;Data Source=xxx;User ID=yyy;Password=zzz;"* It works fine...

What's the problem with _OraOleDB.Oracle_ ????

Best Regards

Edited by: user8824402 on 16-déc.-2010 7:26

Edited by: user8824402 on 16-déc.-2010 7:26
This discussion has been closed.