i can't seem to get the right connection string to connect to the msde using microsoft jdbc driver. what i tried is:

jdbc:microsoft:sqlserver://127.0.0.1\NetSDK:1433;DatabaseName=pubs

i also tried use real ip instead of 127.0.0.1, remove instance name from the connection string, etc. no luck at all. i am sure the instance and database is running because i can connect with 'osql'.

any idea why? help is deeply appreciated. please email jfwang@tbcommerce.com if possible. thanks in advance.