Drivers for gallery

Question

Hi, I currently have a working workflow on Designer but struggle to transfer the same to Gallery. I've tried to install all the same drivers but it's been a while since I installed the drivers on my system and don't remember exactly what I did. Is there any way I can translate/transfer the same driver specs to the Company Gallery?

StephenRuhl · Answer

@Gana_Baliada You'll need to check the ODBC Data Sources manager (there's one for 32 and one for 64 bit). This will show you the drivers and System DSNs you have installed. You'll need to replicate the System DSNs on the server.

Gana_Baliada · Answer

Actually, all I've done so far is install the most updated drivers for the 3 databases. Sadly, that hasn't done the trick.

Gana_Baliada · Answer

So, I'm connecting IBM DB2, Teradata, and Oracle databases to 10+ spreadsheets. And I installed the drivers back in December. I did have problems and had to install multiple/ reinstall drivers from multiple sources to get the ODBC connections going. They work perfectly now, but I don't remember exactly which ones got them working?

Alternatively, is there a way to check what drivers are currently installed? (I realize this isn't the ideal platform for this question).