Extracting one column from Database

[mikeporter]

In the interest of keeping things up-to-date, here are the same drivers I posted all those years ago, converted to LV2012. Enjoy.

Mike..

[Raydur]

Mike - possible to get those in LV2011? I haven't made the jump to 2012 yet, and from the previous comments it sounds like these are a great asset!

Much appreciated!

[mikeporter]

You can download one of the previous versions and resave it, LV2011 will load V8.x code. That will give you everything but the project library, and that can be left as "an exercise for the reader".

Mike...

[woodbadger]

Hi Mike,

Have you ever run this code on a Windows server 2008 R2 ?

(Connected to an Oracle database).

My connection string on multiple windows platforms is:
Driver={Microsoft ODBC for Oracle};
Provider=MSDAORA.1;

But this appears to not be supported on this OS.

-Scott

PS: love your code.

[rolfk]

I don't have Windows Server 2008 R2 to check, but are you sure it comes with these drivers preinstalled? The Windows Server line is in many ways streamlined with not only some registry settings changed to provide better server performance but also various software drivers and utilities not being installed, that the desktop versions come with. It may be necessary to install the MS ADO Drivers separately on those systems.

Better yet would be to actually install the latest ODBC driver from Oracle. They are after all the creators of the database and should know best how to communicate with their database. You will have to change the driver name though to refer to the Oracle driver, if you do that.

[nlhnt]

I know this topic is 5 years old by now, but I am creating my OOP API to use with PGSQL and Mikes work has been most helpful.
I learned about the existance of ADO haha.
Thank you so much 🙂