SQLServers

returns a list of the open SQLServer objects.

Details and Options

To use SQLServers, you first need to load DatabaseLink using Needs["DatabaseLink`"].

Wolfram Language code: Needs["DatabaseLink`"]

Launch multiple HSQL servers:

Wolfram Language code: s1 = SQLServerLaunch[{"myDb1" -> FileNameJoin[{$TemporaryDirectory, "HSQLServer1"}]}, "Port" -> 9001]

Wolfram Language code: s2 = SQLServerLaunch[{"myDb2" -> FileNameJoin[{$TemporaryDirectory, "HSQLServer2"}]}, "Port" -> 9002]

Wolfram Language code: s3 = SQLServerLaunch[{"myDb3" -> FileNameJoin[{$TemporaryDirectory, "HSQLServer3"}]}, "Port" -> 9003]

Obtain a list of open servers:

Wolfram Language code: SQLServers[]

Wolfram Language code: SQLServers[] === {s1, s2, s3}

Wolfram Language code: SQLServerShutdown[#]& /@ {s1, s2, s3};

Top