1. java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found an bytes.com@harsha1302 Hi Harsha, I would like to clarify something. Did you configured the data source using (ODBC data sources) for which you are trying to access ? If you have configured, ... |
2. java.sql.SQLException: Server configuration denies access to data source coderanch.comI wrote the following class DBManager to access the mySQL DB server from java programs. // DBManager.java import java.sql.*; public class DBManager{ Connection connection=null; Statement statement=null; public DBManager(){ // constructor initConnection(); } void initConnection(){ // initialize DB connection and statement if(connection != null) return; try{ Class.forName("com.mysql.jdbc.Driver"); connection = DriverManager.getConnection("jdbc:mysql://localhost/cf?user=scott&password=tiger"); statement = connection.createStatement(); } catch (ClassNotFoundException e){ System.err.println(e); } catch (SQLException sqle){ ... |
3. java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found... coderanch.comhi deepak here, this is my code as follows: import java.rmi.*; import java.rmi.server.*; import java.net.*; import java.io.*; import javax.swing.*; import java.awt.event.*; import java.awt.*; import java.sql.*; class CentralizedServer extends JFrame implements ActionListener { JLabel jLabel1,l4,l5,l10; JLabel jLabel2; JLabel jLabel3; JLabel l6; JComboBox jComboBox1; JComboBox jComboBox2; JComboBox jComboBox3,jc4,jc5; JButton b1; JPanel contentPane; // End of variables declaration ImageIcon icon; public CentralizedServer() { Container ... |
4. java.sql.SQLException[ODBC Driver Manager]Data source name not found and no default driver specified coderanch.comHi Aravind & Ritchie, What i did all is opening 'Control Panel +Administrative tools+Data Sources(ODBC)+System DSN+ Add + Microsoft Access Driver(*mdb)+Finish+DSN Name' Then i used this DSN Name in DriverManager.getConnection(DSNName).Then when i run the project the above exception is generated.Is there anything to do with the Classpath in configuring the DSN? Thank You. |