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
19 - Altair

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
19 - Altair

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