Driver not found Exception

[Former Member]

hi all,

i am doing application in webdynpro java with sql backend and my code is

Class.forNam("com.microsoft.jdbc.sqlserver.SQLServerDriver");

Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://10.10.30.25:1433;databaseName=TrackingSystem","sa","sa") ;

Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery("SELECT * FROM [User Table]");

String un = wdContext.currentContextElement().getUsername();

and i am getting driver not found exception plz tell me the mistake

[Former Member · Accepted solution]

Hi,

You need to have the following files as part of your lib folder

Or else you need to register the JDBC drivers

msbase.jar

msutil.jar

mssqlserver.jar

This files are available from microsoft downloads site.

Regards

Ayyapparaj

[Former Member]

Hi Ayyapparaj,

i added external jars and i created dsn also still i am getting exception

Thanks & Regards

vasavi

[Former Member]

Hi,

Place the jar files in lib folder and run it will solve your problem, if you still getting the same exception check with the IP Adress what you have to connect to the databse.

Regards

Suresh