pontos
Posts: 16
|
Posted: 04/23/2007, 5:55 AM |
|
I found my problem, but I don't know how to resolve it.
When I do a new connection in DBConnectionManager :
con = DriverManager.getConnection(URL, user, password);
An exception is occured :
java sql SQLException No suitable driver
I tested the connection with the manager in connection properties and the connection work very well.
I have already imported all needed drivers (servlet-api.jar, jsp-api.jar) and JDBC Drivers are installed. I am using MSSqlServer.
Someone knows what to do to connect please?
|
|
|
matheus
Posts: 386
|
Posted: 04/23/2007, 5:58 AM |
|
Drivers configured well?
Driver in runtime library?
_________________
Matheus Trevizan
Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br |
|
|
negociant
Posts: 31
|
Posted: 04/23/2007, 6:00 AM |
|
Hm...
Just check: msbase.jar, mssqlserver.jar, msutil.jar must be in <TOMCAT_HOME>/common/lib.
Is it true?
|
|
|
pontos
Posts: 16
|
Posted: 04/23/2007, 6:01 AM |
|
I had just installed with an Installer "JDBC SQLserver2000.exe"
|
|
|
pontos
Posts: 16
|
Posted: 04/23/2007, 6:02 AM |
|
Yes, I have msbase.jar, mssqlserver.jar, msutil.jar in TOMCAT lib
|
|
|
negociant
Posts: 31
|
Posted: 04/23/2007, 6:03 AM |
|
Do you restart tomcat after add this jars?
|
|
|
negociant
Posts: 31
|
Posted: 04/23/2007, 6:05 AM |
|
And whart do you write in Server tab of connction settings for this connection?
|
|
|
pontos
Posts: 16
|
Posted: 04/23/2007, 6:05 AM |
|
it doesn't work at all
|
|
|
pontos
Posts: 16
|
Posted: 04/23/2007, 6:11 AM |
|
|
|
|
pontos
Posts: 16
|
Posted: 04/23/2007, 6:16 AM |
|
That is what you want ?
|
|
|
negociant
Posts: 31
|
Posted: 04/23/2007, 6:19 AM |
|
Try write in URL Field somthing like this
jdbc:microsoft:sqlserver://192.168.1.18:1433
should help.
|
|
|
pontos
Posts: 16
|
Posted: 04/23/2007, 6:23 AM |
|
Thank you, its work
|
|
|