Another 1261 Com/CLR:Exception message

Started by Jeff, January 16, 2018, 12:33:26 PM

Previous topic - Next topic

Jeff

Hi all! I am getting a 1261 Com/CLR:Exception when I try to connect using the provider string below. I have tried other providers and integrated security as well. I am guessing the SQL server I am connecting to is required an SSL connection and I (not WB) do not know how to handle this. Does anyone have any thoughts?

DB.open("driver={SQL Server};server=MYSERVER;catalog=MYDB;uid=isADMIN;pwd=isPassword;")

[COM/CLR Exception]
ADODB.Connection=Provider cannot be found. It may not be properly installed.
Microsoft OLE DB Provider for ODBC Drivers=[Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error
[COM & CLR Sub-system]
Function=InvokeMember
ErrorCode=9 (0x80020009)
ErrorDesc=Exception occurred.
Jeff

td

You might want to find out if your server does indeed require SSL encryption to save yourself some time and frustration.  I haven't tried it but according to MSFT documentation, all you need to do is add ";encrypt=true" to your connection string to force an SSL connection.    Here's a link to the ConnectionStrings Website page:

https://www.connectionstrings.com/all-sql-server-connection-string-keywords/

"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade

Jeff

Jeff