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
			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
