ODBC problem

[Fahad]

Hi everyone!

How are you all. Sorry I was busy for sometimes and couldn't come to the forum.

Mr. belal, in java when we write a java application that has a link with database, we often do it with odbc connection. to make the program run, we have to first make the odbc connection (from control pannel). it is little bit disturbing. Can't I write code that will create odbc connection before running the application? Pls, help me with some code.

Fahad

[Mastermind]

I'm not exactly sure what you are trying to say but I connect to MySQL database from java using the following code

Code:

public void createDatabase(String DBName) throws Exception {                    Connection conn;   Statement st=null;   ResultSet rs=null;   Class.forName("com.mysql.jdbc.Driver");   conn = DriverManager.getConnection("jdbc:mysql://localhost/ttdatabase");   st = conn.createStatement();

I guess it should be similar with the ODBC as well.
_________________
Keep your own dignity, both online and offline throughout your life !!!

[Belal]

hi fahad, it's good to see post frm u after a long time. yes, mastermind is right..............ur odbc connection way sould b similar. but here i m also giving u a code that does it (database: ms access)

import java.sql.*;
import java.io.*;

public class DatabaseConnection
{

//__________Declare Global Objects________
Connection con;
Statement stmt;

public DatabaseConnection()
{
File f1=new File("myDB.mdb");
try
{
//__________Loading Driver__________
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

//__________Creating Connection___________
Connection con= DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};" +"DBQ="+f1.getAbsolutePath()+"","Administrator","");

//_________Creating Statement___________
stmt=conOthers.createStatement();
}catch(ClassNotFoundException cnfe){System.out.println("Class Not Found Error!!!");}
catch(SQLException sqle){ System.out.println("SQL Exception found!");}
}//End of constructor
}//End of class DatabaseConnection

in fact, this class file solve two prob:
1. connecting to ur db
2. connecting to a db that is in ur working folder

let me know if it doesn't solve ur prob
_________________
we've lot of things to think abt curr probs
so, i don't have time to think abt religion or wonder of sceice .......... how ppl can waste their time like this?