This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
My suggestion would be to use DNSless connection strings. This still requires that you have the same drivers, but you do not have to set up the system DSNs. You can set these connections up in Gallery and share them with yourself/users, and they'll be available in Designer. ConnectionStrings.com is a great resource for building DSNless connection strings.
Have you installed the same drivers on the server as you have on your Designer machine. For data connections to work, the driver, System DSN (not required for DSNless), and connection string need to be exactly the same between both systems.
If you are still having trouble feel free to message email@example.com, and we'll get you sorted.
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).
@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.