How do I install database drivers in Lumira? Doesn’t seem to be much there by default and I want drivers for oracle and SQL Server. When I select the database and try to install, it asks me for a location. Where on earth are the files? I don’t even know what to search for on my hard drive…
Debbie
Debbie 
(BOB member since 2005-03-01)
Looks useful, Andreas. Will work through it when I get chance, thanks!
Debbie
ETA: Oh great - a few slides in “Note you must first have downloaded the JAR files…” Where from? Google is my friend, I guess - as I download completely the wrong thing and overwrite something vital on my pc…
ETA2: Ok. Downloaded drivers OK and everything still works (so far). Got stuck on what port to use as I’ve never specified a port in an SQL Server connection before (only in oracle). Email to DBA…
ETA3: And DBA hasn’t got a clue either. He says the default port of 1433 should work, but it doesn’t. 
ETA4: for anybody who is still awake … googling for oracle drivers gave me a list of about 3000. Bit more digging and I found a support site that said I needed ojdbc6.jar for oracle 11g and that it would be bundled with the oracle client install. And it was. And it worked. And I managed to create a freehand SQL query against the data warehouse that worked… 
Debbie (BOB member since 2005-03-01)
(BOB member since 2002-06-20)