Odd ODBC connection issue with ACCDE file (1 Viewer)


New member
Feb 26, 2024
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
strConnect = strConnect & ";iTrustServerCertificate=True;Trusted_Connection=Yes;Encrypt=True"
A good spot but oddly makes no difference, in fact I removed it and same issue the non compiled works but the compiled not!!
Isn't this a bug that was discussed on this site a few weeks ago?

Users who are viewing this thread

Top Bottom