How to connect SQL server with JSSC ?

Hi,İ wanna build a connection between java sun studio creator and SQL server 2005.Is it possible and if possible how?Waiting for your helpthanks,gkhn
[189 byte] By [gkhn] at [2007-11-26 10:34:10]
# 1

I am not an expert in microsoft products, but I see no reason why it wouldn't work.

Download the jdbc driver at: http://msdn.microsoft.com/data/ref/jdbc/

And have a look at the tutorial creating database server types and datasources at: http://developers.sun.com/prodtech/javatools/jscreator/learning/tutorials/2/dbs erversources.html

bami at 2007-7-7 2:43:20 > top of Java-index,Development Tools,Java Tools...
# 2

I've been using the MS SQL 2005 JDBC driver insides of JSC for a while now. It mostly works. The only problem I've seen is that trying to do much with the SQL editor in JSC causes the application to hang. Because of this, I do all of my SQL string editing in Query Analyzer or Enterprise Manager and just paste it into the command properties.

jsr at 2007-7-7 2:43:20 > top of Java-index,Development Tools,Java Tools...