Question: Open Database Connection in Maple

I start by running microsofts free SQL Server Express 2005 (Microsoft SQL Server Management Studio Express) where my

data base UK-100-1SQL is located.

 

I run the following code in Maple :

 

restart;
driverString := "com.microsoft.sqlserver.jdbc.SQLServerDriver";
jarFile := "C:/Program Files/Microsoft SQL Server JDBC Driver 2.0/sqljdbc_2.0/enu/sqljdbc4.jar";
url := "jdbc:sqlserver://MARCUS-PC\SQLEXPRESS\Databases\UK-100-1SQL";
driver := Database:-LoadDriver('driver' = driverString, 'classpath' = jarFile);
connection := driver:-OpenConnection(url, " ", "none")

 

and rhen I get the error message:

 

Error, (in OpenConnection) The TCP/IP connection to the host MARCUS-PCSQLEXPRESSDatabasesUK-100-1SQL,
port 1433 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the
host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".

 

I get blue text for everything up unti connection:= which to me indicate that the jar file  loads properly etc

I have tried to dsconnect the firewall and antivirus software but nothing works.

I have also done a test inside Server Management Studio where I have tested if the database is available for a TCP IP connection

and it was....

 

what should I do to solve this?? Are there any other test I can run to identify the problem

Please Wait...