Page 1 of 1

Cannot set Pooling on non-1433 port

Posted: Thu 30 Jun 2016 12:21
Hi
I have the strangest problem, and i cannot understand why,

if sqlserver set to standard port 1433 i am able to connect with pooling=true,
BUT
when i change to different port on sql server (same port opened on firewalll ),
i am unable to connect with pooling=true, I can however connect with pooling=false

running sdac 7.3.313 on seattle10, fmx app, VPS running mssql 2012 express on winserver2012
conn server, database,username, port and password is set, in addition
conn1.Options.Provider := msClasses.prDirect; //must use to connect for andoird, but give same problem prAauto on win32 fmx app anyway
conn1.Options.DisconnectedMode := true;
conn1.Options.LocalFailover := true;
conn1.options.AllowImplicitConnect := true;
conn1.Options.ApplicationName :='blahvlahblah';
dm.conn1.Pooling := true; // pooling min=0 max=100 clifetime=0 validate=false

Re: Cannot set Pooling on non-1433 port

Posted: Thu 30 Jun 2016 13:29
by AlexP
Hello,

Thank you for the information. We have reproduced and fixed the problem. This fix will be included to the next SDAC version.

Re: Cannot set Pooling on non-1433 port

Posted: Thu 30 Jun 2016 14:35
Alex,
please elaborate as to what it is,
this has been driving me crazy for the last 2 days :)

Re: Cannot set Pooling on non-1433 port

Posted: Fri 01 Jul 2016 06:04
by AlexP
We can send you a night build in order for you to check this case on your sample. For this, please send your license number to alexp*devart*com.

Re: Cannot set Pooling on non-1433 port

Posted: Thu 11 Aug 2016 22:06
Alex, any timeline as to when this will be released.
thanks
Wihan

Re: Cannot set Pooling on non-1433 port

Posted: Fri 12 Aug 2016 07:43
by AlexP
We plan to release the new version next month.