Re: [Schemaspy-users] Can't connect to MSSQL Express 2005

[John C. <cur...@ya...>]

Do you have more of the stack trace from the failure?  It should give us some 
more clues.

John




________________________________
From: Richard Sickler <ric...@av...>
To: "sch...@li..." 
<sch...@li...>
Sent: Mon, November 15, 2010 5:22:23 PM
Subject: [Schemaspy-users] Can't connect to MSSQL Express 2005

Hi,

I'm having problems connecting to a MS SQL Express database.

I can get schemaspy to connect to a PostGRESQL database just fine.
I can get Microsoft's SQL Server Management Studio Express to connct to this 
MSSQL data base,
but I can't get schemaspy to connect to the MSSQL 2005 Express database.

I have tried many combination of commands and drivers, (MS's sqljdbc4.jar, and 
jtds-1.2.5.jar) with no luck.
I have set the ports to use 1433 - although I have had no trouble connecting 
with Management Studio.

I have been trying variations of:
java -jar schemaSpy.jar -t mssql05 -db <dbname> -host <hostname> -port 1433 -u 
<username> -p <password> -o schemaspy.res -dp sqljdbc4.jar

and similar incantations with jtds-1.2.5.jar.

I keep getting Failed to connect to database URL 
[jdbc:sqlserver:/<hostname>:1433;databseName=<dbname>]

Okay, it has to be something that I'm not doing, or not doing correctly, but 
darn if I can see it.

Help?