On Thu, Jun 2, 2022 at 10:47 PM prathibha sumanth <
prathibha.suma...@gmail.com> wrote:
> Hi,
>
> I am connecting to database using Sequel.connect(db_connection_params) and
> db_connection_param hash has following details,
> db_connection_params = {:adapter=>'', :host=>server_ip, :port=>'',
> :user=>'', :password=>''}
> I am able to establish the connection to database when SSL protocol is
> enabled.
>
>
> I have got a server where SSL is disabled and TLS 1.2 is enabled, when I
> am trying to establish the database connection on this server using
> Sequel.Connect(db_connection_params) with the same hash details as above,
> I am getting the below error,
>
> WIN32OLERuntimeError: (in OLE method `Open': )
> OLE error code:80004005 in Microsoft OLE DB Provider for ODBC Drivers
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error
> HRESULT error code:0x80020009
> Exception occurred.
>
> Can anyone suggest me on how to establish the DB connection where TLS 1.2
> security protocol is enabled?
Looks like you may be using the ado adapter to connect to SQL Server. You
may have more luck with the tinytds adapter.
My advice would be to try to get the connection working using the
underlying database driver directly (without Sequel). If you can do that,
but cannot figure out how to get it working with Sequel, then post with how
to get it working with the underlying driver, and I should be able to tell
you how to get it working with Sequel.
Thanks,
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/CADGZSSdZG-cBgNB1D-LYaVZjd1mevZhK%2B%2BOsJmUxFx4qSVx7MA%40mail.gmail.com.
