Microsoft oledb sql server error

Hi all,

I am getting some weird error when I tried to give a SQL server as a data source. I am using altery 11.7 version, very recently i have updated alteryx designer before it was working.

Anyone help me to fix this issue. Please find the attached document for error.

Thanks

Deepak.

sql server error.PNG

Input

Error Message

Database Connection

Accepted answers

WayneWooldridge

Hi @DeepakKrish,

Check to see if you are using the SQL Native Client driver. It appears you are using the MS OLEDB provider instead and the issue will probably resolve if you reconfigure you DSN using the native client driver.

All comments

WayneWooldridge

Hi @DeepakKrish,

DeepakKrish

Hi @WayneWooldridge

As far as I am using MS oledb for SQL provider and I have reconfigured the DSN also , but still i am facing same issue.

esar

I got the same error and I found out that when you create the oledb saved connection data Source=address\dbname loses the \ -character between the server address and dbname. You can add the missing character manually just before saving the connection.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703