Odd ODBC connection issue with ACCDE file (1 Viewer)

[shaunsizen]

Hi
Got a brain teaser here, just upgrading a client app to use TLS so ODBC v18 driver, the code drops and relinks the DB from the client to SQL Server. Connection string works fine when its the base code but fails when I compile it!!
Any ideas?

This is my string (I will be taking TrustServerCertificate=True out for prod but wanted to make sure its not that)

strConnect = "ODBC;DRIVER=ODBC Driver 18 for SQL Server;Server=" & strServerName & ";UID=SAC_User;PWD=sac;DATABASE=" & strDatabase & ";Network=DBMSSOCN;PORT=1499"

strConnect = strConnect & ";iTrustServerCertificate=True;Trusted_Connection=Yes;Encrypt=True"

Any ideas? I am running 365 on 64Bit

 

[cheekybuddha]

strConnect = strConnect & ";iTrustServerCertificate=True;Trusted_Connection=Yes;Encrypt=True"
                            ^
                            |
                          Typo?

 

[shaunsizen]

A good spot but oddly makes no difference, in fact I removed it and same issue the non compiled works but the compiled not!!

 

[Galaxiom]

Isn't this a bug that was discussed on this site a few weeks ago?

 

[shaunsizen]

Not seen it but let me check

 

[shaunsizen]

Could not find anything similar have raised a ticket with MS