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?
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
Have you tried uninstalling the update?