I am doing an app thats needs to connect to a fox pro data base. I am
new to java and need to know how to do this below is an example of
what i am doing. It is a jdbc odbc bridge but i don't know how to
make it work. I keep getting a null pointer exceptin when i execute a
query.
private Connection con = null;
private Statement stmt = null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
con = DriverManager.getConnection("jdbc:odbc:;DRIVER=Microsoft
FoxPro VFP Driver (*.dbf);"
+"UID=;"+
"Deleted=Yes;"+
"Null=Yes;"+
"Collate=Machine;"+
"BackgroundFetch=Yes;"+
"Exclusive=No;"+
"SourceType=DBF;"
+"SourceDB=n://catholicData/nexusxp/dataxp"
);