RE: ERROR using the tomcat db connection pool against one SQL SERVER 200 database. Please help me

[Francois JEANMOUGIN]

 org.apache.commons.dbcp.DbcpException
 : java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
 JDBC]Unable
 to connect.  Invalid URL

The URL is invalid.

 valuejdbc:microsoft:sqlserver://192.168.0.12:1433/Northwind/value

Here is the URL


On my servers, my devs are using:

valuejdbc:microsoft:sqlserver://1.2.3.4:port;DatabaseName=DBP_toto
/value

Hope this helps


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

ERROR using the tomcat db connection pool against one SQL SERVER 200 database. Please help me

[Dionisio Ruiz de Zarate]

Hello i am trying for using the Tomcat database conecition pool (dbcp)
against one SQL SERVER 2000 but i cannot connect always appears this error:
DBCP borrowObject failed: java.sql.SQLException: [Microsoft][SQLServer 2000
Driver for JDBC]Unable to connect.  Invalid URL.
org.apache.commons.dbcp.DbcpException
: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable
to connect.  Invalid URL

in the server.xml i have:
Context path= docBase= reloadable=true crossContext=true
Resource name=jdbc/DB auth=Container type=javax.sql.DataSource/
ResourceParams name=jdbc/DB
parameter
namefactory/name
valueorg.apache.commons.dbcp.BasicDataSourceFactory/value
/parameter
parameter
namedriverClassName/name
valuecom.microsoft.jdbc.sqlserver.SQLServerDriver/value
/parameter
parameter
nameurl/name
valuejdbc:microsoft:sqlserver://192.168.0.12:1433/Northwind/value
/parameter
parameter
nameusername/name
valuesa/value
/parameter
parameter
namepassword/name
valuesa/value

but i cannot connect, the error appears when i make:
conn=ds.getConnection();

can anybody helps me?
this question is very important for my job.
Please help me.

Thanks



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]