Workbench 5 Connection String has not been initialized


Putting in the connection string when connecting to a source like OLEDB, more specifically SQL Server, has always seemed finicky but now with Workbench 5 I'm having an even more hard time.
I put it in as the whole string at once, it fills in the fields on it's own such as Catalog = , Data Source = , Username =, etc. I hit apply on the window the pops up when you click in the connection (shown in blue in screenshot). This populates all those things in the OLAP Connection box, ok so everything seems fine. I click Apply to the whole thing (the one in red) and click preview. I then get an error saying [02.07.19 1:25:36 PM] The ConnectionString property has not been initialized. I go back to the connection string settings and it's all gone, like I never put it in? What am I missing?
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**
Comments
-
Hi guiterhero23,
Would you try...
Provider=OraOLEDB.Oracle;
Data Source=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myHost)(PORT=myPort)))(CONNECT_DATA=(SID=MyOracleSID)(SERVER=DEDICATED)));
User Id=myUsername;Password=myPassword;Reference: https://www.connectionstrings.com/oracle-provider-for-ole-db-oraoledb/
to see if you can connector to Workbench 5?
Thank you!
Msan
0 -
The one I was able to use in the previous version (and works in Workbench 5 in terms of populating the boxes, just doesn't actually save) is Provider=sqloledb;Data Source=XXXXXX;Initial Catalog=XXXXXX;User Id=XXXXXX;Password=XXXXXX
Not sure how Oracle differs but this one is for Microsoft SQL Server
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 87 Workflows
- 23 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 117 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive