aspose file tools*
The moose likes JDBC and the fly likes Need help in my final year about connectivity with Ms-SQL server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Need help in my final year about connectivity with Ms-SQL server" Watch "Need help in my final year about connectivity with Ms-SQL server" New topic
Author

Need help in my final year about connectivity with Ms-SQL server

Deepak Gavkar
Greenhorn

Joined: Feb 23, 2013
Posts: 11
I am facing connectivity problem with my project, i am going to attach here. Please help me out as fast as possible. I am getting error :
F:\1\Multisignature>java AdminMsg
Waiting for the Message
Database Connectivity Error java.sql.SQLException: [Microsoft][ODBC Driver Manag
er] Data source name not found and no default driver specified

PLEASE HELP ME!!!

LINK FOR THE PROJECT : http://www.filedropper.com/multisignature

Deepak Gavkar
Greenhorn

Joined: Feb 23, 2013
Posts: 11
Jayesh A Lalwani wrote:Couple of things

A) don't shout
B) you posted in the wrong forum
C) you will need to post the code here if you want to make it easy for people to help you. Not many people are going to click on that link


Edit: I have modified the subject and moved the thread


Oh sorry!
Deepak Gavkar
Greenhorn

Joined: Feb 23, 2013
Posts: 11
Deepak Gavkar wrote:I am facing connectivity problem with my project, i am going to attach here. Please help me out as fast as possible. I am getting error :
F:\1\Multisignature>java AdminMsg
Waiting for the Message
Database Connectivity Error java.sql.SQLException: [Microsoft][ODBC Driver Manag
er] Data source name not found and no default driver specified

PLEASE HELP ME!!!

LINK FOR THE PROJECT : http://www.filedropper.com/multisignature

SOURCE CODE :

THERE IS FOLDER NAMED "TABLE" IN THE PROJECT FOLDER IN THAT THERE IS "SIGNATURE" FILE INCLUDED.
Jayesh A Lalwani
Bartender

Joined: Jan 17, 2008
Posts: 2333
    
  28

To make it easier to solve the problem, you should create a SSCCE that reproduces the problem. Since it looks like you are having problem connecting to the database, try to make another program that just connects to database and nothing else
Deepak Gavkar
Greenhorn

Joined: Feb 23, 2013
Posts: 11
Jayesh A Lalwani wrote:To make it easier to solve the problem, you should create a SSCCE that reproduces the problem. Since it looks like you are having problem connecting to the database, try to make another program that just connects to database and nothing else



OK, I am going to try it out. Thank you!
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38363
    
  23
How many main methods have you got in that code?
Jayesh A Lalwani
Bartender

Joined: Jan 17, 2008
Posts: 2333
    
  28

I am just curious. Did you write 4500 lines of code without testing even one line? or was this code working before and stopped working suddenly? or did you get this code from someone else?

Writing thousands and thousands of line of code and then testing it in all one go is bad bad practice. That's why we emphasise test driven development here. Write your test code first, then write some code.. then improve your test, then write more code, and do this iteratively. You should never run into a case where you have written 4500 lines of code and then you figure out that you cannot connect to database.
Deepak Gavkar
Greenhorn

Joined: Feb 23, 2013
Posts: 11
Jayesh A Lalwani wrote:I am just curious. Did you write 4500 lines of code without testing even one line? or was this code working before and stopped working suddenly? or did you get this code from someone else?

Writing thousands and thousands of line of code and then testing it in all one go is bad bad practice. That's why we emphasise test driven development here. Write your test code first, then write some code.. then improve your test, then write more code, and do this iteratively. You should never run into a case where you have written 4500 lines of code and then you figure out that you cannot connect to database.


Cool buddy this project don't have only one file to run, And i have made the connection with database by using My-Sql while doing R&D in the college lab's.
 
 
subject: Need help in my final year about connectivity with Ms-SQL server