Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

jdbc problem

  Asked By: Lamberta    Date: Jul 03    Category: Java    Views: 876

I tryed to use jdbc for conecting MSsqlserver2000&jsp (with tomcat app server v 4.1.31) i used this article
but each time i had tried i got an error. what is wrong with this article.or what should i do?



1 Answer Found

Answer #1    Answered By: Clinton Edwards     Answered On: Jul 03

1- Check if you have ms sql server jdbc  drivers in your path (in WEB-INF/lib)
2- MS SQL server  2000 has two modes for authentication: windows and sql server authentication. Choose sql server authentication in your sql server configuration (from Enterprise Manager).
3- Check if the user you are using to connect to database has enough permission for example to read or change database tables.
4- Check your database URL for correct host, port, and other parameters.
5- And never get hopeless, you'll find the answer

Didn't find what you were looking for? Find more on jdbc problem Or get search suggestion and latest updates.