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

eatraas

Registered User.
Local time
Today, 06:06
Joined
Jan 23, 2009
Messages
96
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
Today, 06:06
Joined
Nov 25, 2004
Messages
1,776
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
Today, 06:06
Joined
Jan 23, 2009
Messages
96
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