ODBC-less connection to a SQL server (1 Viewer)

eatraas

Registered User.
Local time
Yesterday, 22:06
Joined
Jan 23, 2009
Messages
91
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

Grover Park George
Local time
Yesterday, 22:06
Joined
Nov 25, 2004
Messages
788
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;
 
Last edited:

eatraas

Registered User.
Local time
Yesterday, 22:06
Joined
Jan 23, 2009
Messages
91
That should be simple indeed, is the form of encryption important? in this case AES256.

Regards
Erwin
 

Users who are viewing this thread

Top Bottom