We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

In DB Error

jmedidi
8 - Asteroid

I am using this Connect-In DB tool to connect to a database. Getting an message that Error opening the connect string .

 

But the database works fine. I was able to write to it in the workflow using output data tool.

 

Appreciate some support.

 

using MicroSoft SQL Server

4 REPLIES 4
apathetichell
20 - Arcturus

Do you have two connections to the same database like a connection through a  file and through a user connection to the same db?

 

can you post a screen grab of your error?

jmedidi
8 - Asteroid

Below is the screenshot :

 

jmedidi_0-1629208853497.png

 

apathetichell
20 - Arcturus

And your sure there isn't a connection some other way? Like through a user/password combo in data connections or something? I've never seen an in-DB which works even though the connection failed.

jmedidi
8 - Asteroid

I was able to write to the database using the output Data tool. and its the same database instance.

Labels
Top Solution Authors