Search found 5 matches

by kenny
12.09.2019, 10:28
Forum: MS SQL Server
Topic: Connecting and session reusing
Replies: 9
Views: 1453

Re: Connecting and session reusing

Ado can connect with disabled Shared Memory and Named Pipes and with stopped SQL Server Browser when "computername\sqlexpress" or "ip,port" is used. Odbc can connect only with disabled Shared Memory and Named Pipes when "computername\sqlexpress" is used and additionally...
by kenny
11.09.2019, 13:24
Forum: MS SQL Server
Topic: Connecting and session reusing
Replies: 9
Views: 1453

Re: Connecting and session reusing

TCP/IP protocol was enabled for all tests. Using "computername\sqlexpress" works for ado and odbc, but not for freetds. The timeout throws "The connection to the server failed, no proper handle was returned. Insufficient memory, unable to connect for any reason.". The tracing con...
by kenny
11.09.2019, 07:43
Forum: MS SQL Server
Topic: Connecting and session reusing
Replies: 9
Views: 1453

Re: Connecting and session reusing

In the library path I have "\packages\DelphiXE10.2\Win32\Debug" and in the browsing path I have "\src\component", "\src\core", "\src\dbc", "\src\parsesql" and "\src\plain". I've tried revision 5431, 5877, 5890, 5904, 5906, 5911 and 5913. Th...
by kenny
09.09.2019, 09:04
Forum: MS SQL Server
Topic: Connecting and session reusing
Replies: 9
Views: 1453

Re: Connecting and session reusing

Revision 5911 still crashes the same way. When HostName is named pipe it does not report any exception just exits at line 403 in src\dbc\ZDbcDbLib.pas (FHandle := FPlainDriver.dbOpen(LoginRec, Pointer(RawTemp)) in procedure TZDBLibConnection.InternalLogin). When HostName is ip and Port is set it han...
by kenny
07.09.2019, 12:03
Forum: MS SQL Server
Topic: Connecting and session reusing
Replies: 9
Views: 1453

Connecting and session reusing

I'm using Windows 10 1903 18362.295, Embarcadero Delphi 10.2 25.0.26309.314, Microsoft SQL Server 2016 13.0.1601.5, ZeosLib 7.3 5906, FreeTDS supplied with ZeosLib and Microsoft OLE DB Driver 18.2.2.0. When I try to execute the following code using FreeTDS the program exits without any exception. Wh...