Logo 
Search:

Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

jdbc problem

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

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

Share: 

 

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.




Tagged: