Although I am using Saxon.Net in my VB.Net project, my question doesn't relate directly to Saxon.Net. I am having trouble finding a mailing list for Oracle .Net support.
My question is 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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Sorry for the *VERY* late reply on this. As of yet I havent found a good way to integrate the SF.net forums into my normal routine and as such find that I dont check here as often as I should.
To be honest I dont know the answer to this but will look into it a bit further and try to get back to you ASAP. In the mean time if you have found the answer please post this back for future reference benefit.
Cheers :)
<M:D/>
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Greetings,
Although I am using Saxon.Net in my VB.Net project, my question doesn't relate directly to Saxon.Net. I am having trouble finding a mailing list for Oracle .Net support.
My question is 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
Hi Jim,
Sorry for the *VERY* late reply on this. As of yet I havent found a good way to integrate the SF.net forums into my normal routine and as such find that I dont check here as often as I should.
To be honest I dont know the answer to this but will look into it a bit further and try to get back to you ASAP. In the mean time if you have found the answer please post this back for future reference benefit.
Cheers :)
<M:D/>