MS SQL Server 2005 on Windows Server 2012r2

I have this code working but windows update and now no works any idea how to fix it

StrSql=“Driver={SQL Server};Server=192.168.0.240;Database=csc;Trusted_Connection=yes;”
DbMainCsc.DataSource=StrSql
DbMainCsc.UserName=“sa”
DbMainCsc.Password=“3838”

If DbMainCsc.Connect then
else
MsgBox “Conn Csc Bad”
Quit
End If

Is port 1344 open on the server firewall?

yes

port 1433

Did you enable TCP/IP on the Microsoft SQL Server?

PS: You can of course also try MBS SQL Plugin.

Hi
if i use MSSQLServerDatabase i have connection perfect but the EOF on recordset no works

Dim DbMainCcs As MSSQLServerDatabase
DbMainCcs=New MSSQLServerDatabase
DbMainCsc.Host = “192.168.0.240”
DbMainCsc.Port=1433
DbMainCsc.UserName = “sa”
DbMainCsc.Password = “abc123”
DbMainCsc.DatabaseName = “csc”

If DbMainCsc.Connect then
else
MsgBox “Conn Csc Bad”
Quit
End If

Try connection string StrSql=“Driver={SQL Server};Server=192.168.0.240;Database=csc;Usr=sa;Pwd=abc123;”

[Microsoft][ODBC SQL Server Driver]Dialog failed

Upgrade to a newer version of MS SQL, 2005 is no longer supported on 2012R2

but MS SQL, 2005 is working on Server 2012R2 but this week have a update and now no works the problems is the app it works only sql 2005 i have small app to do other works can no be change.

if you telnet to port 1433 does it connect?

no connect
but the tcp config on sql is on 1433 and firewall is off

See https://support.microsoft.com/en-us/help/310099/description-of-the-portqry-exe-command-line-utility on how to test your UDP port using PortQry from https://www.microsoft.com/en-us/download/details.aspx?id=17148

Have you tried uninstalling the update?