Cannot see File Format and Specific Query window

[DaniDFunesP]

Hello

 I have this problem, I’m using Driver 18 for Sql

ssvb:DRIVER={ODBC Driver 18 for SQL Server};UID=xxxx;PWD=__EncPwd1__;DATABASE=xxx;SERVER=xxx,1433;Encrypt=Optional;TrustServerCertificate=yes

When I select the table and put ok disappears the file format and the table if I select

If I select the File format work, but I can see the other options when you select a table pre query post etc

Can you help me

Regards

[DanM]

@DaniDFunesP 

I am not quite following what the issue you are having but I do believe your driver version should be okay based on the help docs.https://help.alteryx.com/current/en/designer/data-sources/microsoft-sql-server-2012,-2014,-2016,-and...

If you could provide a bit more details and what you are attempting to accomplish I can try to assist.

DanM

[DaniDFunesP]

I think something is wrong since my connection with driver 18 works but when I have AMP disabled, if I enable AMP I get the error that I have attached, I don't know what is happening. I saw in the Microsoft documentation that in my string I have to put Encrypt=Optional, but it still doesn't work, could it be my database?