Login Timeout Expired

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
alwillis1357
Posts: 9
Joined: Tue 14 Oct 2008 14:17

Login Timeout Expired

Post by alwillis1357 » Fri 03 Apr 2020 00:53

I have been using the dbExpress driver for SQL Server Standard with Source Code version 6.5.7 since March 2014 with no issues. My client updated their SQL Server installation which I think is 2014 and now they are getting Login Timeout Expired error. I updated my own copy of SQL Server 2014 to the latest service packs and now I'm getting the same error.

Is there any way to get the very old 6.5.7 driver to work? Please note that I have already purchased the latest dbExpress driver for SQL Server Standard with Source Code version 8.1.4. But since it has been 6 long years since I had to change out the dbExpress driver, it's going to be a learning curve for me and I'm trying to get my client back up and running as soon as possible.

I know that the dbxsda81.exe will do an automated install, but I'm afraid that I won't be able to set up my client's installation correctly without knowing exactly where the files need to go. Therefore, is there any way to get the very old 6.5.7 driver to work? If not, are there better information sources than the readme file?

Thanks

Stellar
Devart Team
Posts: 324
Joined: Tue 03 Oct 2017 11:00

Re: Login Timeout Expired

Post by Stellar » Tue 07 Apr 2020 08:49

All the documentation about the dbExpress driver is stored in the Readme.html, which describes all supported driver parameters.
If you're using sqlncli11 (Microsoft SQL Server 2012 Native Client) as VendorLib, then Devart dbExpress driver for SQL Server should be able to successfully connect to MS SQL Server 2014.
We recommend though using the latest versions of our products as they contain many improvements and fixes which make the operation of our products more stable and efficient.

alwillis1357
Posts: 9
Joined: Tue 14 Oct 2008 14:17

Re: Login Timeout Expired

Post by alwillis1357 » Wed 08 Apr 2020 17:44

Thanks for the response. I am now attempting to use the 8.1.4 version.

I am still having the same problem. Below is a sample connection code that I have used for many years with no issues:

scIMMain.Connected := False;
scIMMain.ConnectionName := 'Devart SQL Server';
scIMMain.LoginPrompt := False;
scIMMain.DriverName := 'DevartSQLServer';
scIMMain.Params.Clear;
scIMMain.Params.Add('User_Name=IM');
scIMMain.Params.Add('Password=' + MasterPassword);
scIMMain.Params.Add('HostName=' + SQLServerName);
scIMMain.Params.Add('Database=IMMAIN');
scIMMain.Connected := True;

I do see from the Reame.hmtl the I should also be specifying the LibraryName, VendorLib and GetDriverFunc. So now my connection string looks like this:

scIMMain.Connected := False;
scIMMain.ConnectionName := 'Devart SQL Server';
scIMMain.LibraryName := 'dbexpsda40.dll';
scIMMain.GetDriverFunc := 'getSQLDriverSQLServer';
scIMMain.VendorLib := 'sqlncli';
scIMMain.LoginPrompt := False;
scIMMain.DriverName := 'DevartSQLServer';
scIMMain.Params.Clear;
scIMMain.Params.Add('User_Name=' + ProgramConfigRecord.IMUserName);
scIMMain.Params.Add('Password=' + MasterPassword);
scIMMain.Params.Add('HostName=' + ProgramConfigRecord.SQLServerName);
scIMMain.Params.Add('Database=IMMAIN');
scIMMain.Connected := True;

I also tried scIMMain.VendorLib := 'sqloledb'.
I also omitting the VendorLib statement.

I tried locating dbexpsda40.dll in C:\windows\SYSWOW64 or the application directory or both and I still get the error. What else can I try?

Below is a buglist report of the error:


date/time : 2020-04-08, 12:52:59, 516ms
computer name : CIS-CHQ-LT-7QZ0
user name : brunkel
registered owner : Binh
operating system : Windows 10 x64 build 17763
system language : English
system up time : 20 days 22 hours
program up time : 1 minute 36 seconds
processors : 8x Intel(R) Core(TM) i5-8250U CPU @ 1.60GHz
physical memory : 3091/8051 MB (free/total)
free disk space : (C:) 109.94 GB (J:) 15.49 GB
display mode : 1280x720, 32 bit
process id : $9b4
allocated memory : 62.07 MB
largest free block : 867.91 MB
executable : IM1_NEW.exe
exec. date/time : 2020-04-08 12:48
version : 7.0.0.0
compiled with : Delphi 10.1 Berlin
madExcept version : 4.0.15
callstack crc : $5da74966, $89a8f399, $89a8f399
exception number : 1
exception class : TDBXError
exception message : Login timeout expired.

main thread ($42b0):
01009299 +051 IM1_NEW.exe Data.DBXCommon TDBXContext.Error
02af500e +10a IM1_NEW.exe Data.DBXDynalink TDBXMethodTable.RaiseError
02af5667 +013 IM1_NEW.exe Data.DBXDynalink TDBXDynalinkConnection.CheckResult
02af585a +052 IM1_NEW.exe Data.DBXDynalink TDBXDynalinkConnection.DerivedOpen
01004d9f +00b IM1_NEW.exe Data.DBXCommon TDBXConnection.Open
0100008a +0fe IM1_NEW.exe Data.DBXCommon TDBXConnectionFactory.GetConnection
00ffff85 +005 IM1_NEW.exe Data.DBXCommon TDBXConnectionFactory.GetConnection
01094685 +295 IM1_NEW.exe Data.SqlExpr TSQLConnection.DoConnect
0063665d +039 IM1_NEW.exe Data.DB TCustomConnection.SetConnected
02b599d5 +14d IM1_NEW.exe IMMain_dmu 623 +18 TIMMain_dm.OpenIMMain
02ae62e8 +320 IM1_NEW.exe IMMAIN 647 +60 TMainForm.FormShow
008553c5 +015 IM1_NEW.exe Vcl.Forms TCustomForm.DoShow
00859c31 +0a9 IM1_NEW.exe Vcl.Forms TCustomForm.CMShowingChanged
00758b76 +2be IM1_NEW.exe Vcl.Controls TControl.WndProc
0075d6c1 +5e9 IM1_NEW.exe Vcl.Controls TWinControl.WndProc
00855e85 +64d IM1_NEW.exe Vcl.Forms TCustomForm.WndProc
007587b0 +024 IM1_NEW.exe Vcl.Controls TControl.Perform
0075ca89 +10d IM1_NEW.exe Vcl.Controls TWinControl.UpdateShowing
0075cb98 +0bc IM1_NEW.exe Vcl.Controls TWinControl.UpdateControlState
0075f816 +026 IM1_NEW.exe Vcl.Controls TWinControl.CMVisibleChanged
00758b76 +2be IM1_NEW.exe Vcl.Controls TControl.WndProc
0075d6c1 +5e9 IM1_NEW.exe Vcl.Controls TWinControl.WndProc
00855e85 +64d IM1_NEW.exe Vcl.Forms TCustomForm.WndProc
007587b0 +024 IM1_NEW.exe Vcl.Controls TControl.Perform
00757162 +026 IM1_NEW.exe Vcl.Controls TControl.SetVisible
008556a1 +03d IM1_NEW.exe Vcl.Forms TCustomForm.SetVisible
008549e1 +071 IM1_NEW.exe Vcl.Forms TCustomForm.DoCreate
00854511 +13d IM1_NEW.exe Vcl.Forms TCustomForm.Create
0085f776 +076 IM1_NEW.exe Vcl.Forms TApplication.CreateForm
02ba0ee2 +0a6 IM1_NEW.exe IM1 2106 +25 initialization
77930417 +017 KERNEL32.DLL BaseThreadInitThunk

thread $20e8:
762f11f8 +48 user32.dll MsgWaitForMultipleObjects
00704719 +0d IM1_NEW.exe madExcept CallThreadProcSafe
0070477e +32 IM1_NEW.exe madExcept ThreadExceptFrame
77930417 +17 KERNEL32.DLL BaseThreadInitThunk
>> created by main thread ($42b0) at:
6d7a9166 +00 gdiplus.dll

thread $4f60:
77930417 +17 KERNEL32.DLL BaseThreadInitThunk

thread $461c:
77930417 +17 KERNEL32.DLL BaseThreadInitThunk

thread $54b8:
77930417 +17 KERNEL32.DLL BaseThreadInitThunk

thread $463c:
7761a1bd +12d KERNELBASE.dll WaitForMultipleObjectsEx
00704719 +00d IM1_NEW.exe madExcept CallThreadProcSafe
0070477e +032 IM1_NEW.exe madExcept ThreadExceptFrame
77930417 +017 KERNEL32.DLL BaseThreadInitThunk
>> created by thread $54b8 at:
764e1979 +000 combase.dll

thread $3f10:
77617d53 +93 KERNELBASE.dll WaitForSingleObjectEx
77617cad +0d KERNELBASE.dll WaitForSingleObject
00704719 +0d IM1_NEW.exe madExcept CallThreadProcSafe
0070477e +32 IM1_NEW.exe madExcept ThreadExceptFrame
77930417 +17 KERNEL32.DLL BaseThreadInitThunk
>> created by main thread ($42b0) at:
655b12fa +00 winspool.drv

thread $11b0:
00704719 +00d IM1_NEW.exe madExcept CallThreadProcSafe
0070477e +032 IM1_NEW.exe madExcept ThreadExceptFrame
77930417 +017 KERNEL32.DLL BaseThreadInitThunk
>> created by main thread ($42b0) at:
63fd16a6 +226 netbios.dll Netbios

thread $4f8:
77930417 +17 KERNEL32.DLL BaseThreadInitThunk

thread $3a00:
77930417 +17 KERNEL32.DLL BaseThreadInitThunk

thread $540c:
77930417 +17 KERNEL32.DLL BaseThreadInitThunk

thread $288c:
77930417 +17 KERNEL32.DLL BaseThreadInitThunk

modules:
00500000 IM1_NEW.exe 7.0.0.0 J:
08b60000 SQLOLEDB.RLL 6.2.17763.1 C:\Program Files (x86)\Common Files\System\Ole DB
0c3d0000 dbexpsda40.dll 8.1.4.0 C:\Windows\SYSTEM32
10000000 KeyLib32.dll 4.5.0.2 J:
46480000 security.dll 6.2.17763.1 C:\Windows\SYSTEM32
63ef0000 ntdsapi.dll 6.2.17763.1 C:\Windows\SYSTEM32
63f10000 cryptdll.dll 6.2.17763.503 C:\Windows\SYSTEM32
63f30000 NtlmShared.dll 6.2.17763.802 C:\Windows\SYSTEM32
63f40000 msv1_0.DLL 6.2.17763.1075 C:\Windows\System32
63fb0000 DBNETLIB.DLL 6.2.17763.1 C:\Windows\SYSTEM32
63fd0000 netbios.dll 6.2.17763.1 C:\Windows\SYSTEM32
63fe0000 oledb32.dll 6.2.17763.1 C:\Program Files (x86)\Common Files\System\Ole DB
640b0000 MSDART.DLL 6.2.17763.1 C:\Windows\SYSTEM32
640e0000 MSDATL3.dll 6.2.17763.1 C:\Program Files (x86)\Common Files\System\Ole DB
64100000 sqloledb.dll 6.2.17763.1 C:\Program Files (x86)\Common Files\System\Ole DB
641d0000 olepro32.dll 6.2.17763.503 C:\Windows\SYSTEM32
641f0000 odbc32.dll 6.2.17763.1075 C:\Windows\SYSTEM32
64290000 oledlg.dll 6.2.17763.1075 C:\Windows\SYSTEM32
64360000 CoreUIComponents.dll 6.2.17763.1 C:\Windows\System32
646c0000 FONTSUB.dll 6.2.17763.914 C:\Windows\SYSTEM32
646e0000 SHFolder.dll 6.2.17763.1 C:\Windows\SYSTEM32
64700000 DAVHLPR.dll 6.2.17763.1 C:\Windows\System32
64710000 davclnt.dll 6.2.17763.1 C:\Windows\System32
64810000 oleacc.dll 7.2.17763.1 C:\Windows\SYSTEM32
65490000 ntlanman.dll 6.2.17763.404 C:\Windows\System32
65590000 winspool.drv 6.2.17763.1075 C:\Windows\SYSTEM32
65600000 drprov.dll 6.2.17763.1 C:\Windows\System32
65630000 CoreMessaging.dll 6.2.17763.194 C:\Windows\System32
65790000 TextInputFramework.dll 6.2.17763.1075 C:\Windows\System32
65ba0000 msls31.dll 3.10.349.0 C:\Windows\SYSTEM32
65be0000 RICHED20.DLL 5.31.23.1231 C:\Windows\SYSTEM32
65db0000 msimg32.dll 6.2.17763.1 C:\Windows\SYSTEM32
65dc0000 tv_w32.dll 15.4.4445.0 C:\Program Files (x86)\TeamViewer
671a0000 usp10.dll 6.2.17763.864 C:\Windows\SYSTEM32
6a150000 wintypes.dll 6.2.17763.1098 C:\Windows\SYSTEM32
6c140000 comctl32.dll 6.10.17763.1098 C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.17763.1098_none_262365ab67c31790
6ce70000 cscapi.dll 6.2.17763.404 C:\Windows\SYSTEM32
6ceb0000 FaultRep.dll 6.2.17763.1075 C:\Windows\SYSTEM32
6cf10000 netprofm.dll 6.2.17763.1 C:\Windows\System32
6cfd0000 npmproxy.dll 6.2.17763.316 C:\Windows\System32
6d000000 uxtheme.dll 6.2.17763.1075 C:\Windows\system32
6d730000 gdiplus.dll 6.2.17763.1098 C:\Windows\WinSxS\x86_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.17763.1098_none_570e5890c255915e
6dad0000 dwmapi.dll 6.2.17763.1075 C:\Windows\system32
6df70000 DPAPI.DLL 6.2.17763.1 C:\Windows\SYSTEM32
6e0e0000 ncryptsslp.dll 6.2.17763.1 C:\Windows\system32
6e100000 schannel.dll 6.2.17763.802 C:\Windows\System32
6e220000 wkscli.dll 6.2.17763.1 C:\Windows\SYSTEM32
6e3b0000 NTASN1.dll 6.2.17763.1 C:\Windows\SYSTEM32
6e3e0000 ncrypt.dll 6.2.17763.1 C:\Windows\SYSTEM32
6e870000 mskeyprotect.dll 6.2.17763.1 C:\Windows\SYSTEM32
70460000 rasadhlp.dll 6.2.17763.1 C:\Windows\System32
70470000 PROPSYS.dll 7.0.17763.1075 C:\Windows\SYSTEM32
705f0000 WINSTA.dll 6.2.17763.771 C:\Windows\SYSTEM32
706e0000 WINMMBASE.dll 6.2.17763.1 C:\Windows\SYSTEM32
70710000 winmm.dll 6.2.17763.1 C:\Windows\SYSTEM32
70740000 DSPARSE.DLL 6.2.17763.1 C:\Windows\SYSTEM32
71da0000 ntmarta.dll 6.2.17763.1 C:\Windows\SYSTEM32
71df0000 mpr.dll 6.2.17763.404 C:\Windows\SYSTEM32
72090000 wtsapi32.dll 6.2.17763.1 C:\Windows\SYSTEM32
72850000 SECUR32.DLL 6.2.17763.1 C:\Windows\SYSTEM32
739e0000 NETUTILS.DLL 6.2.17763.1 C:\Windows\SYSTEM32
73b50000 netapi32.dll 6.2.17763.1 C:\Windows\SYSTEM32
73b70000 version.dll 6.2.17763.1 C:\Windows\SYSTEM32
73b80000 wsock32.dll 6.2.17763.1 C:\Windows\SYSTEM32
73e00000 fwpuclnt.dll 6.2.17763.771 C:\Windows\System32
73e60000 DNSAPI.dll 6.2.17763.652 C:\Windows\SYSTEM32
73ef0000 dhcpcsvc.DLL 6.2.17763.1 C:\Windows\SYSTEM32
73f10000 dhcpcsvc6.DLL 6.2.17763.1 C:\Windows\SYSTEM32
73f30000 IPHLPAPI.DLL 6.2.17763.615 C:\Windows\SYSTEM32
74580000 mswsock.dll 6.2.17763.292 C:\Windows\system32
745e0000 dbgcore.DLL 6.2.17763.1 C:\Windows\SYSTEM32
74610000 dbghelp.dll 6.2.17763.1 C:\Windows\SYSTEM32
75300000 CRYPTBASE.dll 6.2.17763.1 C:\Windows\System32
75310000 SspiCli.dll 6.2.17763.1 C:\Windows\System32
75330000 ole32.dll 6.2.17763.1075 C:\Windows\System32
75430000 msvcrt.dll 7.0.17763.475 C:\Windows\System32
754f0000 ucrtbase.dll 6.2.17763.719 C:\Windows\System32
75620000 gdi32full.dll 6.2.17763.1098 C:\Windows\System32
75790000 advapi32.dll 6.2.17763.1 C:\Windows\System32
75810000 IMAGEHLP.DLL 6.2.17763.1 C:\Windows\System32
75830000 WS2_32.dll 6.2.17763.771 C:\Windows\System32
75890000 crypt32.dll 6.2.17763.973 C:\Windows\System32
75a30000 profapi.dll 6.2.17763.1075 C:\Windows\System32
75a50000 shcore.dll 6.2.17763.1075 C:\Windows\System32
75ae0000 windows.storage.dll 6.2.17763.1098 C:\Windows\System32
760e0000 MSASN1.dll 6.2.17763.1 C:\Windows\System32
760f0000 comdlg32.dll 6.2.17763.1075 C:\Windows\System32
761f0000 RPCRT4.dll 6.2.17763.864 C:\Windows\System32
762b0000 user32.dll 6.2.17763.1098 C:\Windows\System32
76450000 combase.dll 6.2.17763.1098 C:\Windows\System32
766d0000 bcrypt.dll 6.2.17763.1 C:\Windows\System32
766f0000 NSI.dll 6.2.17763.831 C:\Windows\System32
76700000 powrprof.dll 6.2.17763.1 C:\Windows\System32
76760000 kernel.appcore.dll 6.2.17763.1 C:\Windows\System32
767d0000 shlwapi.dll 6.2.17763.1 C:\Windows\System32
76820000 bcryptPrimitives.dll 6.2.17763.678 C:\Windows\System32
76950000 msvcp_win.dll 6.2.17763.1 C:\Windows\System32
769d0000 sechost.dll 6.2.17763.1075 C:\Windows\System32
76ea0000 cfgmgr32.dll 6.2.17763.1 C:\Windows\System32
76ee0000 shell32.dll 6.2.17763.1098 C:\Windows\System32
77440000 cryptsp.dll 6.2.17763.1 C:\Windows\System32
77470000 clbcatq.dll 2001.12.10941.16384 C:\Windows\System32
77500000 KERNELBASE.dll 6.2.17763.1098 C:\Windows\System32
77870000 oleaut32.dll 6.2.17763.914 C:\Windows\System32
77910000 KERNEL32.DLL 6.2.17763.475 C:\Windows\System32
779f0000 MSCTF.dll 6.2.17763.1075 C:\Windows\System32
77b30000 GDI32.dll 6.2.17763.592 C:\Windows\System32
77b60000 IMM32.DLL 6.2.17763.719 C:\Windows\System32
77b90000 win32u.dll 6.2.17763.1 C:\Windows\System32
77cb0000 ntdll.dll 6.2.17763.1098 C:\Windows\SYSTEM32

processes:
0000 Idle 0 0 0
0004 System 0 0 0
0078 Registry 0 0 0
0240 smss.exe 0 0 0
0348 csrss.exe 0 0 0
03a0 wininit.exe 0 0 0
03ec services.exe 0 0 0
0064 lsass.exe 0 0 0
0410 svchost.exe 0 0 0
0428 svchost.exe 0 0 0
04b4 svchost.exe 0 0 0
04e0 WUDFHost.exe 0 0 0
04e8 svchost.exe 0 0 0
05a0 WUDFHost.exe 0 0 0
05e0 svchost.exe 0 0 0
05fc svchost.exe 0 0 0
0608 svchost.exe 0 0 0
061c svchost.exe 0 0 0
062c svchost.exe 0 0 0
0684 svchost.exe 0 0 0
068c svchost.exe 0 0 0
06bc svchost.exe 0 0 0
06ec svchost.exe 0 0 0
0720 svchost.exe 0 0 0
0750 svchost.exe 0 0 0
07f0 svchost.exe 0 0 0
07f8 svchost.exe 0 0 0
0860 svchost.exe 0 0 0
086c svchost.exe 0 0 0
089c svchost.exe 0 0 0
08cc svchost.exe 0 0 0
08f0 svchost.exe 0 0 0
0900 svchost.exe 0 0 0
0944 ekrn.exe 0 0 0
094c UshUpgradeService.exe 0 0 0
09d4 svchost.exe 0 0 0
09e4 dasHost.exe 0 0 0
0a2c svchost.exe 0 0 0
0a60 svchost.exe 0 0 0
0a70 svchost.exe 0 0 0
0b00 EmsService.exe 0 0 0
0b1c svchost.exe 0 0 0
0b98 svchost.exe 0 0 0
08f8 svchost.exe 0 0 0
0cb8 svchost.exe 0 0 0
0e48 svchost.exe 0 0 0
0f60 svchost.exe 0 0 0
0c40 svchost.exe 0 0 0
0e88 svchost.exe 0 0 0
0f10 wlanext.exe 0 0 0
0ee8 conhost.exe 0 0 0
10bc svchost.exe 0 0 0
10c8 svchost.exe 0 0 0
10d0 svchost.exe 0 0 0
1128 igfxCUIService.exe 0 0 0
1130 Memory Compression 0 0 0
1188 svchost.exe 0 0 0
1190 svchost.exe 0 0 0
1204 svchost.exe 0 0 0
124c RtkAudioService64.exe 0 0 0
1300 vpnagent.exe 0 0 0
1308 svchost.exe 0 0 0
1344 svchost.exe 0 0 0
1394 spoolsv.exe 0 0 0
139c svchost.exe 0 0 0
13dc HostControlService.exe 0 0 0
13e4 HostStorageService.exe 0 0 0
0500 svchost.exe 0 0 0
1434 svchost.exe 0 0 0
1454 fontdrvhost.exe 0 0 0
1468 hasplms.exe 0 0 0
1470 svchost.exe 0 0 0
1488 svchost.exe 0 0 0
14b0 AdAppMgrSvc.exe 0 0 0
14b8 HidMonitorSvc.exe 0 0 0
14c8 svchost.exe 0 0 0
14d8 esif_uf.exe 0 0 0
14ec ScreenConnect.ClientService.exe 0 0 0
1500 svchost.exe 0 0 0
1508 svchost.exe 0 0 0
1510 svchost.exe 0 0 0
1518 sqlwriter.exe 0 0 0
1530 mongod.exe 0 0 0
155c EvtEng.exe 0 0 0
1570 RegSrvc.exe 0 0 0
1578 WavesSysSvc64.exe 0 0 0
1580 IntelCpHDCPSvc.exe 0 0 0
1590 RstMwService.exe 0 0 0
15dc ZeroConfigService.exe 0 0 0
15d4 svchost.exe 0 0 0
1710 svchost.exe 0 0 0
184c IntelCpHeciSvc.exe 0 0 0
1854 svchost.exe 0 0 0
19a4 unsecapp.exe 0 0 0
19e0 WmiPrvSE.exe 0 0 0
19f0 svchost.exe 0 0 0
1a0c CMGShieldSvc.exe 0 0 0
1adc WmiPrvSE.exe 0 0 0
1c60 unsecapp.exe 0 0 0
1db8 hasplmv.exe 0 0 0
2388 svchost.exe 0 0 0
19fc svchost.exe 0 0 0
2448 svchost.exe 0 0 0
2504 svchost.exe 0 0 0
2584 PresentationFontCache.exe 0 0 0
25cc svchost.exe 0 0 0
2820 svchost.exe 0 0 0
28f4 svchost.exe 0 0 0
29dc svchost.exe 0 0 0
2d48 svchost.exe 0 0 0
364c SecurityHealthService.exe 0 0 0
2efc svchost.exe 0 0 0
31d8 svchost.exe 0 0 0
257c Dell.D3.WinSvc.exe 0 0 0
2e1c svchost.exe 0 0 0
1e94 msdtc.exe 0 0 0
0d0c IAStorDataMgrSvc.exe 0 0 0
3598 jhi_service.exe 0 0 0
2be8 LMS.exe 0 0 0
245c SgrmBroker.exe 0 0 0
3738 svchost.exe 0 0 0
202c svchost.exe 0 0 0
2624 svchost.exe 0 0 0
3804 LTSVC.exe 0 0 0
1528 LTSvcMon.exe 0 0 0
4fa8 labvnc.exe 0 0 0
102c armsvc.exe 0 0 0
4318 svchost.exe 0 0 0
47c4 svchost.exe 0 0 0
32a0 AGSService.exe 0 0 0
4f38 AGMService.exe 0 0 0
0fa8 csrss.exe 2 0 0
3a1c GoogleCrashHandler.exe 0 0 0
4634 GoogleCrashHandler64.exe 0 0 0
05e8 ServiceShell.exe 0 0 0
50bc DDVRulesProcessor.exe 0 0 0
1554 DDVDataCollector.exe 0 0 0
1978 DDVCollectorSvcApi.exe 0 0 0
28bc DSAPI.exe 0 0 0
2c1c svchost.exe 0 0 0
51a0 SupportAssistAgent.exe 0 0 0
0a5c svchost.exe 0 0 0
3a48 MsMpEng.exe 0 0 0
262c NisSrv.exe 0 0 0
2e20 csrss.exe 4 0 0
2264 winlogon.exe 4 0 0
593c dwm.exe 4 0 0
5398 fontdrvhost.exe 4 0 0
54f4 svchost.exe 0 0 0
3114 labvnc.exe 4 0 0
1f70 OfficeClickToRun.exe 0 0 0
2abc dllhost.exe 0 0 0
0644 AppVShNotify.exe 0 0 0
3758 SearchIndexer.exe 0 0 0
0bdc dptf_helper.exe 4 0 2 normal C:\Windows\System32\Intel\DPTF
0118 ScreenConnect.WindowsClient.exe 4 15 11 normal C:\Program Files (x86)\ScreenConnect Client (42560915fdbaec4a)
3e90 Apoint.exe 4 27 21 normal C:\Windows\System32\DellTPad
31f0 RAVBg64.exe 4 0 0
03a8 RAVBg64.exe 4 0 0
0fa0 sihost.exe 4 0 11 normal C:\Windows\System32
3ed8 svchost.exe 4 0 1 normal C:\Windows\System32
4524 svchost.exe 4 4 4 normal C:\Windows\System32
5a88 taskhostw.exe 4 8 6 normal C:\Windows\System32
207c unsecapp.exe 4 0 0
4454 ctfmon.exe 4 0 0
3020 taskhostw.exe 4 0 0
4fec igfxEM.exe 4 13 17 normal C:\Windows\System32\DriverStore\FileRepository\ki130471.inf_amd64_26ad6921447aa568
5860 explorer.exe 4 633 599 normal C:\Windows
5030 svchost.exe 4 0 9 normal C:\Windows\System32
0e9c LTTray.exe 4 47 51 normal C:\Windows\LTSvc
4114 ApMsgFwd.exe 4 0 0
410c ApRemote.exe 4 0 1 normal C:\Windows\System32\DellTPad
53bc hidfind.exe 4 0 3 normal C:\Windows\System32\DellTPad
1f1c ShellExperienceHost.exe 4 7 63 normal C:\Windows\SystemApps\ShellExperienceHost_cw5n1h2txyewy
3c84 ApntEx.exe 4 8 5 normal C:\Windows\System32\DellTPad
2424 SearchUI.exe 4 16 59 normal C:\Windows\SystemApps\Microsoft.Windows.Cortana_cw5n1h2txyewy
0834 dllhost.exe 4 0 3 normal C:\Windows\System32
5394 RuntimeBroker.exe 4 40 10 normal C:\Windows\System32
3d94 RuntimeBroker.exe 4 40 3 normal C:\Windows\System32
31d0 ApplicationFrameHost.exe 4 42 27 normal C:\Windows\System32
4124 MicrosoftEdge.exe 4 13 61 normal C:\Windows\SystemApps\Microsoft.MicrosoftEdge_8wekyb3d8bbwe
32a8 SkypeApp.exe 4 0 8 normal C:\Program Files\WindowsApps\Microsoft.SkypeApp_14.56.102.0_x64__kzf8qxf38zg5c
39a8 SkypeBackgroundHost.exe 4 0 1 normal C:\Program Files\WindowsApps\Microsoft.SkypeApp_14.56.102.0_x64__kzf8qxf38zg5c
29ac browser_broker.exe 4 36 3 normal C:\Windows\System32
17bc YourPhone.exe 4 0 9 normal C:\Program Files\WindowsApps\Microsoft.YourPhone_1.20022.82.0_x64__8wekyb3d8bbwe
1544 conhost.exe 4 18 11 normal C:\Windows\System32
2fac RuntimeBroker.exe 4 36 8 normal C:\Windows\System32
57a8 MicrosoftEdgeCP.exe 4 0 17 normal C:\Windows\System32
2d8c MicrosoftEdgeSH.exe 4 0 8 normal C:\Windows\System32
580c RuntimeBroker.exe 4 0 4 normal C:\Windows\System32
2b1c RuntimeBroker.exe 4 0 1 normal C:\Windows\System32
41d8 RuntimeBroker.exe 4 40 3 normal C:\Windows\System32
2e4c smartscreen.exe 4 0 5 normal C:\Windows\System32
3dc8 SecurityHealthSystray.exe 4 7 5 normal C:\Windows\System32
56ec RtkNGUI64.exe 4 17 26 normal C:\Program Files\Realtek\Audio\HDA
51d0 RAVBg64.exe 4 5 13 normal C:\Program Files\Realtek\Audio\HDA
4324 WavesSvc64.exe 4 28 71 normal C:\Program Files\Waves\MaxxAudio
4b40 SystemSettings.exe 4 11 28 normal C:\Windows\ImmersiveControlPanel
28cc RtkUGui64.exe 4 0 17 normal C:\Windows\System32
3294 dllhost.exe 4 0 3 normal C:\Windows\System32
085c eguiProxy.exe 4 408 110 normal C:\Program Files\ESET\ESET Security
2580 BBPrint.exe 4 0 2 normal C:\Program Files\Bluebeam Software\Bluebeam Revu\2018\Revu
4c18 Greenshot.exe 4 30 20 normal C:\Program Files\Greenshot
1d80 OneDrive.exe 4 145 68 normal C:\Users\brunkel\AppData\Local\Microsoft\OneDrive
12d8 vpnui.exe 4 118 97 normal C:\Program Files (x86)\Cisco\Cisco AnyConnect Secure Mobility Client
4bc4 chrome.exe 4 56 50 normal C:\Program Files (x86)\Google\Chrome\Application
3970 chrome.exe 4 0 3 normal C:\Program Files (x86)\Google\Chrome\Application
37d0 chrome.exe 4 0 4 normal C:\Program Files (x86)\Google\Chrome\Application
2dfc chrome.exe 4 9 13 above normal C:\Program Files (x86)\Google\Chrome\Application
3880 chrome.exe 4 0 1 normal C:\Program Files (x86)\Google\Chrome\Application
501c chrome.exe 4 0 0 idle C:\Program Files (x86)\Google\Chrome\Application
18f4 chrome.exe 4 0 0 idle C:\Program Files (x86)\Google\Chrome\Application
37a0 chrome.exe 4 0 0 idle C:\Program Files (x86)\Google\Chrome\Application
1c40 chrome.exe 4 0 0 idle C:\Program Files (x86)\Google\Chrome\Application
2b0c chrome.exe 4 0 0 idle C:\Program Files (x86)\Google\Chrome\Application
3b90 TeamViewer_Service.exe 0 0 0
17e4 TeamViewer.exe 4 556 344 normal C:\Program Files (x86)\TeamViewer
50f0 tv_w32.exe 4 0 0
4714 tv_x64.exe 4 0 0
343c MicrosoftEdgeCP.exe 4 0 54 below normal C:\Windows\System32
3d28 MicrosoftEdgeCP.exe 4 0 51 normal C:\Windows\System32
5318 MicrosoftEdgeCP.exe 4 0 50 normal C:\Windows\System32
1770 svchost.exe 0 0 0
050c MicrosoftEdgeCP.exe 4 0 17 normal C:\Windows\System32
126c svchost.exe 4 0 1 normal C:\Windows\System32
3904 svchost.exe 0 0 0
4ef8 acrotray.exe 4 45 13 normal C:\Program Files (x86)\Adobe\Acrobat 2017\Acrobat
2fe8 WindowsInternal.ComposableShell.Experiences.TextInput.InputApp.exe 4 0 70 normal C:\Windows\SystemApps\InputApp_cw5n1h2txyewy
4920 svchost.exe 0 0 0
23d8 YourPhoneServer.exe 4 0 6 normal C:\Program Files\WindowsApps\Microsoft.YourPhone_1.20022.82.0_x64__8wekyb3d8bbwe\YourPhoneServer
4bd8 Microsoft.Photos.exe 4 0 8 normal C:\Program Files\WindowsApps\Microsoft.Windows.Photos_2020.19081.28230.0_x64__8wekyb3d8bbwe
0bbc RuntimeBroker.exe 4 36 6 normal C:\Windows\System32
071c svchost.exe 0 0 0
1e2c LockApp.exe 4 6 18 normal C:\Windows\SystemApps\Microsoft.LockApp_cw5n1h2txyewy
3b98 RuntimeBroker.exe 4 73 16 normal C:\Windows\System32
5504 TeamViewer_Desktop.exe 4 0 0
0fe0 audiodg.exe 0 0 0
4300 svchost.exe 0 0 0
2104 svchost.exe 0 0 0
09b4 IM1_NEW.exe 4 82 96 normal \\CIS-HOU-APPS-01\PET
2620 RuntimeBroker.exe 4 0 2 normal C:\Windows\System32
1c38 splwow64.exe 4 0 2 normal C:\Windows
5a34 PrintIsolationHost.exe 0 0 0

hardware:
+ {09e9a11d-ccb2-45ae-9be8-65c263e60491}
- Dell ControlVault w/o Fingerprint Sensor (driver 4.10.11.9)
+ {1ed2bbf9-11f0-4084-b21f-ad83a8e6dcdc}
- \\cis-chq-dcfs-01\Canon iPF710_ Sabine Wren
- \\CIS-CHQ-DCFS-01\HP 2530T_Unkar Plott
- \\CIS-CHQ-DCFS-01\Xerox C8070_Kylo Ren
- \\CIS-CHQ-DCFS-01\Xerox7970_Darth Vader
- \\CIS-CHQ-DCFS-01\Xerox7970_Jar Jark Binks
- \\CIS-CHQ-DCFS-01\XeroxC8070_Stormtrooper
- \\CIS-CHQ-DCFS-01\XeroxPhaser5550_Tusken Raider
- Adobe PDF
- Bluebeam PDF
- Fax
- Microsoft Print to PDF
- Microsoft XPS Document Writer
- OneNote
- Root Print Queue
- SKMPDF
- Xerox C8070 - Han Solo
+ {36fc9e60-c465-11cf-8056-444553540000}
- Intel(R) USB 3.0 eXtensible Host Controller - 1.0 (Microsoft)
- USB Composite Device
- USB Composite Device
- USB Root Hub (USB 3.0)
+ {4d36e966-e325-11ce-bfc1-08002be10318}
- ACPI x64-based PC
+ {4d36e967-e325-11ce-bfc1-08002be10318}
- SK hynix SC401 SATA 256GB
+ {4d36e968-e325-11ce-bfc1-08002be10318}
- Intel(R) UHD Graphics 620 (driver 25.20.100.6472)
+ {4d36e96b-e325-11ce-bfc1-08002be10318}
- HID Keyboard Device
- HID Keyboard Device
- Standard PS/2 Keyboard
+ {4d36e96c-e325-11ce-bfc1-08002be10318}
- Intel(R) Display Audio (driver 10.26.0.4)
- Realtek Audio (driver 6.0.1.8622)
+ {4d36e96e-e325-11ce-bfc1-08002be10318}
- Generic PnP Monitor
+ {4d36e96f-e325-11ce-bfc1-08002be10318}
- HID-compliant mouse
- HID-compliant mouse
+ {4d36e970-e325-11ce-bfc1-08002be10318}
- Realtek PCIE CardReader (driver 10.0.17763.21313)
+ {4d36e972-e325-11ce-bfc1-08002be10318}
- Bluetooth Device (Personal Area Network)
- Cisco AnyConnect Secure Mobility Client Virtual Miniport Adapter for Windows x64 (driver 3.1.6019.0)
- Intel(R) Dual Band Wireless-AC 8265 (driver 20.70.12.5)
- Intel(R) Ethernet Connection (4) I219-LM (driver 12.17.8.7)
- Microsoft Kernel Debug Network Adapter
- Microsoft Wi-Fi Direct Virtual Adapter
- Microsoft Wi-Fi Direct Virtual Adapter #2
- WAN Miniport (IKEv2)
- WAN Miniport (IP)
- WAN Miniport (IPv6)
- WAN Miniport (L2TP)
- WAN Miniport (Network Monitor)
- WAN Miniport (PPPOE)
- WAN Miniport (PPTP)
- WAN Miniport (SSTP)
+ {4d36e979-e325-11ce-bfc1-08002be10318}
- \\CIS-CHQ-DCFS-01\CAM-Pro Downstairs Xerox 8070 (driver 7.76.0.0)
- \\CIS-CHQ-DCFS-01\CAM-Pro Upstairs Xerox 8070 (driver 7.76.0.0)
- \\CIS-CHQ-DCFS-01\XeroxC8045_Rey (driver 7.76.0.0)
- Microsoft IPP Class Driver
+ {4d36e97b-e325-11ce-bfc1-08002be10318}
- Intel(R) Chipset SATA/PCIe RST Premium Controller (driver 17.0.2.1076)
- Microsoft Storage Spaces Controller
+ {4d36e97d-e325-11ce-bfc1-08002be10318}
- ACPI Fixed Feature Button
- ACPI Lid
- ACPI Power Button
- ACPI Processor Aggregator
- ACPI Sleep Button
- ACPI Thermal Zone
- Charge Arbitration Driver
- Composite Bus Enumerator
- Dell Data Vault Control Device (driver 2.0.3.0)
- Detection Verification (driver 1.0.160.0)
- High precision event timer
- Intel(R) Dynamic Platform and Thermal Framework Generic Participant (driver 8.3.10207.5567)
- Intel(R) Dynamic Platform and Thermal Framework Generic Participant (driver 8.3.10207.5567)
- Intel(R) Dynamic Platform and Thermal Framework Generic Participant (driver 8.3.10207.5567)
- Intel(R) Dynamic Platform and Thermal Framework Manager (driver 8.3.10207.5567)
- Intel(R) Dynamic Platform and Thermal Framework Processor Participant (driver 8.3.10207.5567)
- Intel(R) Management Engine Interface (driver 1828.12.0.1152)
- Intel(R) Power Engine Plug-in
- Intel(R) Serial IO I2C Host Controller - 9D60 (driver 30.100.1816.3)
- Intel(R) Serial IO I2C Host Controller - 9D61 (driver 30.100.1816.3)
- Intel(R) Serial IO I2C Host Controller - 9D62 (driver 30.100.1816.3)
- Intel(R) Serial IO I2C Host Controller - 9D63 (driver 30.100.1816.3)
- Intel(R) Serial IO I2C Host Controller - 9D64 (driver 30.100.1816.3)
- Intel(R) Smart Sound Technology (Intel(R) SST) Audio Controller (driver 9.21.0.3755)
- Intel(R) Smart Sound Technology (Intel(R) SST) OED (driver 9.21.4001.1)
- Intel(R) Xeon(R) E3 - 1200 v6/7th Gen Intel(R) Core(TM) Host Bridge/DRAM Registers - 5914 (driver 10.1.1.44)
- Legacy device
- Microsoft ACPI-Compliant Embedded Controller
- Microsoft ACPI-Compliant System
- Microsoft Basic Display Driver
- Microsoft Basic Render Driver
- Microsoft Hyper-V Virtualization Infrastructure Driver
- Microsoft System Management BIOS Driver
- Microsoft UEFI-Compliant System
- Microsoft Virtual Drive Enumerator
- Microsoft Windows Management Interface for ACPI
- Microsoft Windows Management Interface for ACPI
- Microsoft Windows Management Interface for ACPI
- Microsoft Windows Management Interface for ACPI
- Mobile 6th/7th Generation Intel(R) Processor Family I/O PCI Express Root Port #1 - 9D10 (driver 10.1.1.44)
- Mobile 6th/7th Generation Intel(R) Processor Family I/O PCI Express Root Port #3 - 9D12 (driver 10.1.1.44)
- Mobile 6th/7th Generation Intel(R) Processor Family I/O PMC - 9D21 (driver 10.1.1.44)
- Mobile 6th/7th Generation Intel(R) Processor Family I/O SMBUS - 9D23 (driver 10.1.1.44)
- Mobile 6th/7th Generation Intel(R) Processor Family I/O Thermal subsystem - 9D31 (driver 10.1.1.44)
- Mobile 7th Generation Intel(R) Processor Family I/O LPC Controller (U with iHDCP2.2 Premium) - 9D4E (driver 10.1.1.44)
- Motherboard resources
- Motherboard resources
- Motherboard resources
- Motherboard resources
- Motherboard resources
- Motherboard resources
- Motherboard resources
- NDIS Virtual Network Adapter Enumerator
- PCI Express Root Complex
- Plug and Play Software Device Enumerator
- Programmable interrupt controller
- Remote Desktop Device Redirector Bus
- System CMOS/real time clock
- System timer
- UMBus Root Bus Enumerator
- Volume Manager
+ {50127dc3-0f36-415e-a6cc-4cb3be910b65}
- Intel(R) Core(TM) i5-8250U CPU @ 1.60GHz
- Intel(R) Core(TM) i5-8250U CPU @ 1.60GHz
- Intel(R) Core(TM) i5-8250U CPU @ 1.60GHz
- Intel(R) Core(TM) i5-8250U CPU @ 1.60GHz
- Intel(R) Core(TM) i5-8250U CPU @ 1.60GHz
- Intel(R) Core(TM) i5-8250U CPU @ 1.60GHz
- Intel(R) Core(TM) i5-8250U CPU @ 1.60GHz
- Intel(R) Core(TM) i5-8250U CPU @ 1.60GHz
+ {50dd5230-ba8a-11d1-bf5d-0000f805f530}
- Microsoft Usbccid Smartcard Reader (WUDF)
+ {533c5b84-ec70-11d2-9505-00c04f79deaf}
- Generic volume shadow copy
- Generic volume shadow copy
- Generic volume shadow copy
+ {5c4c3332-344d-483c-8739-259e934c9cc8}
- Intel(R) Dynamic Application Loader Host Interface (driver 1908.12.0.1228)
- Intel(R) iCLS Client (driver 1.52.230.1)
- Intel(R) Management and Security Application Local Management (driver 1914.12.0.1254)
- Intel(R) Pinning Shell Extensions (driver 17.0.2.1076)
+ {62f9c741-b25a-46ce-b54c-9bccce08b6f2}
- Bluetooth
- Broadcom Corp Contacted SmartCard 0
- Microsoft Device Association Root Enumerator
- Microsoft GS Wavetable Synth
- Microsoft Passport Container Enumeration Bus
- Microsoft Radio Device Enumeration Bus
- Microsoft RRAS Root Enumerator
- Smart Card Device Enumeration Bus
- Wi-Fi
- Xerox C8070 - Han Solo
+ {72631e54-78a4-11d0-bcf7-00aa00b7b32a}
- Microsoft AC Adapter
- Microsoft ACPI-Compliant Control Method Battery
+ {745a17a0-74d3-11d0-b6fe-00a0c90f57da}
- AlpsAlpine Virtual HID Device (driver 10.0.0.126)
- Converted Portable Device Control device
- Dell Touchpad (driver 10.3201.101.212)
- HID-compliant consumer control device
- HID-compliant system controller
- HID-compliant touch pad
- HID-compliant vendor-defined device
- HID-compliant wireless radio controls
- I2C HID Device
- Intel(R) HID Event Filter (driver 2.2.1.372)
- Microsoft Input Configuration Device
- Portable Device Control device
+ {c166523c-fe0c-4a94-a586-f1a80cfbbf3e}
- Microphone Array (Realtek Audio)
- Speakers / Headphones (Realtek Audio)
+ {ca3e7ab9-b4c3-4ae6-8251-579ef933890f}
- Integrated Webcam
+ {d94ee5d8-d189-4994-83d2-f68d7d41b0e6}
- Trusted Platform Module 2.0
+ {db4f6ddd-9c0e-45e4-9597-78dbbad0f412}
- Smart card filter driver
+ {e0cbf06c-cd8b-4647-bb8a-263b43f0f974}
- Bluetooth Device (RFCOMM Protocol TDI)
- Intel(R) Wireless Bluetooth(R) (driver 20.60.1.1)
- Microsoft Bluetooth Enumerator
- Microsoft Bluetooth LE Enumerator
+ {e6f1aa1c-7f3b-4473-b2e8-c97d8ac71d53}
- UCM-UCSI ACPI Device
+ {f2e7dd72-6468-4e36-b6f1-6488f42c1b52}
- System Firmware

cpu registers:
eax = 08ee38c8
ebx = 08e9c5c0
ecx = 00000000
edx = 00450bc0
esi = 08ee38c8
edi = 08ef5940
eip = 0100929e
esp = 0493f7dc
ebp = 0493f824

stack dump:
0493f7dc 9e 92 00 01 de fa ed 0e - 01 00 00 00 07 00 00 00 ................
0493f7ec f0 f7 93 04 9e 92 00 01 - c8 38 ee 08 c0 c5 e9 08 .........8......
0493f7fc c8 38 ee 08 40 59 ef 08 - 24 f8 93 04 0c f8 93 04 .8..@Y..$.......
0493f80c 2c f8 93 04 f0 ac 50 00 - 24 f8 93 04 c0 67 64 0c ,.....P.$....gd.
0493f81c 20 12 f7 08 00 00 00 00 - 70 f8 93 04 13 50 af 02 .......p....P..
0493f82c 84 f8 93 04 f0 ac 50 00 - 70 f8 93 04 1a 00 00 00 ......P.p.......
0493f83c 20 23 f0 08 f0 e0 74 0c - ca 00 00 00 0c 8a ef 08 #....t.........
0493f84c 9c 0a ed 08 00 00 00 00 - 00 00 00 00 15 00 00 00 ................
0493f85c 00 00 00 00 ff ff 00 00 - c0 c5 e9 08 00 00 00 00 ................
0493f86c 00 00 00 00 a4 f8 93 04 - 6c 56 af 02 00 00 00 00 ........lV......
0493f87c c0 67 64 0c 5f 58 af 02 - b4 f8 93 04 f0 ac 50 00 .gd._X........P.
0493f88c a4 f8 93 04 a0 bb d4 06 - 20 23 f0 08 00 00 00 00 ........ #......
0493f89c 00 00 00 00 00 00 00 00 - 00 f9 93 04 a2 4d 00 01 .............M..
0493f8ac 00 5a ef 08 8d 00 00 01 - c0 f8 93 04 cf ae 50 00 .Z............P.
0493f8bc 00 f9 93 04 cc f8 93 04 - f0 ac 50 00 00 f9 93 04 ..........P.....
0493f8cc 0c f9 93 04 f0 ac 50 00 - 00 f9 93 04 e0 d3 eb 08 ......P.........
0493f8dc f0 94 90 0b 01 00 00 00 - 00 00 00 00 00 00 00 00 ................
0493f8ec 00 00 00 00 20 f1 f5 08 - 20 8e ef 08 20 23 f0 08 .... ... ... #..
0493f8fc 88 f8 92 0b 8c f9 93 04 - 8a ff ff 00 8a 46 09 01 .............F..
0493f90c 18 f9 93 04 f0 ac 50 00 - 8c f9 93 04 24 f9 93 04 ......P.....$...

disassembling:
[...]
02b599c6 mov ecx, [eax]
02b599c8 call dword ptr [ecx+$3c]
02b599cb 623 mov eax, [esi+$3d4]
02b599d1 mov dl, 1
02b599d3 mov ecx, [eax]
02b599d5 > call dword ptr [ecx+$5c]
02b599d8 626 mov eax, [esi+$3f0]
02b599de xor edx, edx
02b599e0 mov ecx, [eax]
02b599e2 call dword ptr [ecx+$5c]
02b599e5 627 mov eax, [esi+$3f0]
[...]

Stellar
Devart Team
Posts: 324
Joined: Tue 03 Oct 2017 11:00

Re: Login Timeout Expired

Post by Stellar » Thu 09 Apr 2020 08:35

Please try using the following connection parameters and let us know the result.

Code: Select all

  scIMMain.Connected := False;
  scIMMain.LoginPrompt := False;
  scIMMain.ConnectionName := 'Devart SQL Server';
  scIMMain.DriverName := 'DevartSQLServer';
  scIMMain.GetDriverFunc := 'getSQLDriverSQLServer';
  scIMMain.LibraryName := 'dbexpsda40.dll';
  scIMMain.VendorLib := 'sqlncli11';

  scIMMain.Params.Clear;
  scIMMain.Params.Values['Hostname'] := ProgramConfigRecord.SQLServerName;
  scIMMain.Params.Values['Database'] := 'IMMAIN';
  scIMMain.Params.Values['User_name'] := ProgramConfigRecord.IMUserName;
  scIMMain.Params.Values['Password'] := MasterPassword;

  scIMMain.Connected := True;
Connection might be blocked by antivirus software or firewall. Please try connecting to the server from the same client machine using standard tools, e.g. Microsoft Management Studio.

alwillis1357
Posts: 9
Joined: Tue 14 Oct 2008 14:17

Re: Login Timeout Expired

Post by alwillis1357 » Thu 09 Apr 2020 10:10

I was able make some progress, however the results have been inconsistent.

I will try again in a few hours when I have access to the client's systems. The change that I see is to modify scIMMain.VendorLib := 'sqlncli'; to scIMMain.VendorLib := 'sqlncli11';

I was briefly able to get the connection to work by using the blank option of scIMMain.VendorLib := ''''; However this was not with my preferred configuration of having dbexpsda40.dll located in the application program directory on the application server rather than having dbexpsda40.dll located in C:\WindowsSysWOW64 directory. I've done this successfully over a number of years with multiple clients and it has never been a problem. However when troubleshooting this problem earlier, I removed dbexpsda40.dll from the the application program directory and moved it to the client's workstation C:\WindowsSysWOW64 directory. The the application server and each user's workstation were rebooted. It was in this configuration that the scIMMain.VendorLib := '''' worked.

When I tried to revert to my preferred configuration of having dbexpsda40.dll located in the application program directory the timeout error returned. I restarted the client's workstation, but since I'm accessing the client's workstation remotely, I have to wait for them to return in the morning to login. So I am on hold until the client returns to login to the workstation. The application server has not been rebooted and I don't want to have to do that again because of other applications that the client has running.

What is also very confusing is that I have a small utility application that has remained unchanged and uses the older connection parameters that do not specify:
scIMMain.LibraryName := 'dbexpsda40.dll';
scIMMain.GetDriverFunc := 'getSQLDriverSQLServer';
scIMMain.VendorLib := '';

This program continues to connect to the SQL Server every time. I am totally baffled. Unfortunately I didn't try to execute this program at the beginning with the much older dbexpsda40.

Stellar
Devart Team
Posts: 324
Joined: Tue 03 Oct 2017 11:00

Re: Login Timeout Expired

Post by Stellar » Fri 10 Apr 2020 12:52

When the connection parameter VendorLib is set to 'sqlncli11', an application will use Microsoft SQL Server 2012 Native Client. You can put the driver library in the same directory where the executable file of your application is located, in which case the OS won't search the system path to load the driver.

Post Reply