Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: Simple & easy BUT urgent
11 views
Skip to first unread message
Jeff Higgins
Nov 17, 2012, 9:48:53 PM11/17/12
to
On 11/17/2012 06:02 PM, Oussama Romdhane wrote:
> hi everyone, I'm new here so hey there all !
> I just want you guys to give me the necessary line codes to connect an access data base (.mdb) to a java program (I'm working on web services using the soap exchange method)
> Thanks a lot
> OR
import java.sql.*;
class Scratch
{
public static void main(String[] args) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection("yourdatabaseurl");
} catch (Exception e) {}
}
}
> hi everyone, I'm new here so hey there all !
> I just want you guys to give me the necessary line codes to connect an access data base (.mdb) to a java program (I'm working on web services using the soap exchange method)
> Thanks a lot
> OR
import java.sql.*;
class Scratch
{
public static void main(String[] args) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection("yourdatabaseurl");
} catch (Exception e) {}
}
}
Arne Vajhøj
Nov 17, 2012, 10:11:00 PM11/17/12
to
On 11/17/2012 6:02 PM, Oussama Romdhane wrote:
> hi everyone, I'm new here so hey there all ! I just want you guys to
> give me the necessary line codes to connect an access data base
> (.mdb) to a java program (I'm working on web services using the soap
> exchange method)
With DSN:
> hi everyone, I'm new here so hey there all ! I just want you guys to
> give me the necessary line codes to connect an access data base
> (.mdb) to a java program (I'm working on web services using the soap
> exchange method)
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:Test");
DSN less:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con =
DriverManager.getConnection("jdbc:odbc:;Driver={Microsoft Access Driver
(*.mdb)};Dbq=C:\\Databases\\Test.mdb;");
But now the important part: The JDBC ODBC bridge is known to
have problems - especially with concurrent usage. Web services
will typical be concurrent usage. I will strongly recommend
a different solution - maybe a different database.
Arne
0 new messages