Alteryx Designer Desktop Discussions

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

Error in connecting the alteryx to sql server

sriniprad08
11 - Bolide

Hi Team,

 

I need help. I tried connecting to sql server from alteryx . But it's not recognizing and allowing me to import the table or connect to sql server.

I do have ODBC server installed in my system.

 

Please find attached the snapshot.

sriniprad08_0-1608297323548.png

 

Thanks,

Sri

7 REPLIES 7
Qiu
21 - Polaris
21 - Polaris

@sriniprad08 
Just in case, have install the driver?

https://www.microsoft.com/en-us/download/details.aspx?id=53339

If you could post the error message, it would be better.

sriniprad08
11 - Bolide

hi @Qiu ,

 

Thank you for the reply. Please find below the snapshot , i think its installed,

 

sriniprad08_0-1608299271665.png

 

sriniprad08
11 - Bolide

hi @Qiu ,

There is no error message. Jus that its instead of connecting to sql server and giving me tables it rather giving me this below option,

sriniprad08_0-1608300067088.png

 

sriniprad08
11 - Bolide

Hi @Qiu 

Please find the list i can't find the ODBC.

 

sriniprad08_0-1608300494765.png

 

jrgo
14 - Magnetar

Hi @sriniprad08 

 

The drop down menu you pictured from the "Resolve File Type" dialog won't show any database related connection type because its to resolve files only.

 

You may want to look at your connection manager, specifically, what the configuration is for the alias you're trying to use (aka:Srinivas). It seems like it's not properly configured. The connection manager doesn't allow you to edit the connection so I'd suggest deleting it then creating it from scratch.

jrgo_1-1608301826935.png

 

This also is assuming that your connection is local and not one that's shared with you from a Gallery you're connected to. If the latter, you'll want to connect with your Gallery Curator (admin).

 

Hope this helps!

 

Best,

Jimmy
Teknion Data Solutions

 

sriniprad08
11 - Bolide

Hi @jrgo ,

 

Thank you so much for the reply. Sure will have a look and reinstall the drivers.

 

Cheers,

Sri

Qiu
21 - Polaris
21 - Polaris

@sriniprad08 
What is the version of your Alteryx?

In my case, it would be simply like below

Capture.PNG

Labels
Top Solution Authors