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


i also tried use real ip instead of, 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.