ODBC-less connection to a SQL server

[eatraas]

Hello,

I'm puzzled. My client is changing some settings on their SQL servers, each connection should be encrypted.

Can this be done with ODBC or should I use another type of connection?

Please assist.
Thanks in advance.

Erwin

 

[GPGeorge]

In a nutshell, yes, it's pretty standard in fact. HOW you go about it, of course, is a bit more complicated.

Here's an example of a connection string including encryption:

DRIVER=ODBC Driver 17 for SQL Server;SERVER=tcp:XXXXXXXXXX.database.windows.net,1433;UID=MyUID;PWD=MYPWD;Trusted_Connection=no;APP=Microsoft Office;DATABASE=TheBestStuff;Encrypt=yes;

 

[eatraas]

That should be simple indeed, is the form of encryption important? in this case AES256.

Regards
Erwin

 

[GPGeorge]

Good question. I suggest you consult the documentation.