Re: [Schemaspy-users] Can't connect to MSSQL Express 2005
Brought to you by:
johncurrier
|
From: John C. <cur...@ya...> - 2010-11-18 22:40:30
|
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?
|