Connecting to SQLServer 2k named Instance

hey guys, time need urgent help, swapped windows linux platform , using cf9, when create dsn in windows using server_name\instance_name server field, filling user name , password microsoft sql server native dsn works perfectly, when same thing on linux nasty error:

 

java.sql.sqlnontransientconnectionexception: [macromedia][sqlserver jdbc  driver]the requested instance either invalid or not running.
root cause that:  java.sql.sqlnontransientconnectionexception: [macromedia][sqlserver jdbc  driver]the requested instance either invalid or not running.

so tryed create connection using "other" dsn type , filled out info:

 

cf data source name: test

jdbc url: jdbc:sqlserver://server_name\instance_name:1433;databasename=mydatabase

driver class: com.microsoft.sqlserver.jdbc.sqlserverdriver

driver name: sql server jdbc

user name: myuser

password: mypass

 

i error:

 

connection verification failed data source: test
com.microsoft.sqlserver.jdbc.sqlserverexception: tcp/ip  connection host fullsql, port 1433 has failed. error: "connection  refused. verify connection properties, check instance of  sql server running on host , accepting tcp/ip connections at  port, , no firewall blocking tcp connections the  port.".

 

this done after downloading sqljdbc_3.0.1301.101_enu.tar.gz microsoft's web site , placing sqljdbc4.jar file inside /opt/coldfusion9/runtime/lib directory.

 

so first way create connection works on windows not on linux, , second way not work in place tho it's supposed working...

 

please send me asap, need thing working badly!

come on guys.!! ne1? , still need life saver tip issue....

More discussions in Database Access

adobe