×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

ODBC, SSL and TLC

ODBC, SSL and TLC

ODBC, SSL and TLC

(OP)
Colleagues,
We have just migrated from Sequel 2K to 2012, and now are trying to connect

- classic ASP .NET programs (made in VS 2012) on Win2016 server,
- via intranet (VPN),
- to the Sequel's DB on Win2016 server box
- via 32-bit ODBC ver. 10.00.14393.00

and getting error 18:



Firewall's not an issue (the needed port is open).
Apparently, it has something to do with SSL vs. TLC.

FYI: my partner and I already ran searches in the I-net for Sequel Error 18, found 5 altogether websites with explanations and resolutions... Explanations did help, resolutions - did not.

Thus, The Question is:

What steps and in what order shall we make to resolve this issue?

TIA!

Regards,

Ilya

RE: ODBC, SSL and TLC

What I found points our you might need a Hotfix of SQL Server 2012: https://dba.stackexchange.com/questions/197236/app...

If you go for a current Windows Server with latest TLS versions, it would also be better to use a newer SQL Server version. I guess you have decided for that version, as the compatibility is sufficient?

It's hard to mix old and new technology...

And as you said yourself, you find multiple reasons, could be anything, also group policies, I don't know what you tried already, but I'd go for SQL 2019, make the giant leap.

Bye, Olaf.

Olaf Doschke Software Engineering
https://www.doschke.name

RE: ODBC, SSL and TLC

Try Native client 11 with SQL 2012 and later.

Bob Palmer
www.resisystems.co.uk
The most common solution is H2O!

RE: ODBC, SSL and TLC

(OP)
Thank you Olaf.
Unfortunately, the company I work for is huge, naturally the IT security measures (read "restrictions") are sky-high, budgets are predetermined (means also "restricted").
Thus, we have to do with what we're given, not with what we choose. Plus, we are migrating from SQL 2K upward. Best case scenario, we'll get SQL 2016.
Moreover, we cannot run and install even standard updates and/or hot fixes ourselves even on our own workstations, let alone on a server! Only corporate Sys Admins can do it.
Thus, we need to file Service Ticket, wait for corp. VP approval, and then corp. IT security engineer takes control of your W/S and does it.
As result, we'll need to file this Service Ticket with justification... and you can figure all the rest.
But thank you nonetheless because your post should help us to formulate that Service Request's justification!

Regards,

Ilya

RE: ODBC, SSL and TLC

Well, then I'd rather use SQL2016 than try whether the Hotfix SQL 2012 works. As it's not the only reason and option, first try easier options like using another driver.

The group policies change that could help I found here would even not require an installation, just a restart:
https://community.progress.com/s/article/How-to-re...

And it points in the same direction, TLS version, which means an ODBC driver change does not change how the socket is secured with which TLS version the underlying Windows system uses.
Besides that, it shows the same error can have multiple reasons, and if you're not able to try several things it likely will just cost more time for the next ticket, so a Sys Admin may be the best idea to look into this.

Bye, Olaf.

Olaf Doschke Software Engineering
https://www.doschke.name

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close