| Oracle provider on VB.Net returning XML [message #112333] |
Thu, 24 March 2005 08:27 |
neffland
Messages: 1
Registered: March 2005
Location: Maryland, USA
|
Junior Member |
|
|
Greetings,
How do I use the Oracle .Net provider to return a resultset in XML form?
Previously I used the Microsoft provided OLEDB library, but it does not seem to work with my database now. No errors and the result I get back is an empty data set (like my SELECT query simply excluded all rows). But when I take that same query and run it in another application I get a nice result set. So I do not think it is the query. I think for some reason my MS OLEDB provider does not communicate with the DB anymore. (maybe a patch or change on the database?).
I'd rather try the Oracle provider anyways as I've heard it is faster. I've gotten that to work just fine and return a nice result set that I was expecting.
My problem is the Oracle provider does not have a nice GetXML method like the MS OLEDB one does.
So my question is how do I get that result back in an XML form using the Oracle provider?
Thanks,
Jim Neff
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
