Win a copy of The Business Blockchain this week in the Cloud forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How can i connect MS Access from JDBC Program ??

 
Sirish Kumar Gongal Reddy
Ranch Hand
Posts: 109
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
Rcently i was encounter a problme what it is,
How can i connect MS Access from JDBC Program,iam using jdbc-odbc Driver and i select Odbcdriver for MS Access,can you guess what the problem is ?
one more thing my program is compiling fine but not getting any out put ?
Thanking you,
Regards,
G Sirish Reddy.,

Code:
....
...
...
ResultSet rs=stmt.executeQuery("Select * from [$emp]");
while(rs.next()){
S.o.p(rs.getInt(1));
[ June 29, 2005: Message edited by: Bear Bibeault ]
 
Andrew Nomos
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
did you setup an odbc data source?

Originally posted by G Sirish Reddy:
Hello,
Rcently i was encounter a problme what it is,
How can i connect MS Access from JDBC Program,iam using jdbc-odbc Driver and i select Odbcdriver for MS Access,can you guess what the problem is ?
one more thing my program is compiling fine but not getting any out put ?
Thanking you,
Regards,
G Sirish Reddy.,

Code:
....
...
...
ResultSet rs=stmt.executeQuery("Select * from [$emp]");
while(rs.next()){
S.o.p(rs.getInt(1));
 
Wei Dai
Ranch Hand
Posts: 86
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
>One more thing my program is compiling fine but not getting any out put ?
> ResultSet rs=stmt.executeQuery("Select * from [$emp]");
Make sure that code hasn't thrown any exception. If no exception, that emp table should hasn't any rows. If you can't find any wrong, but you make sure that emp table has rows indeed, you have to use "select * from emp" through HXTT Access(www.hxtt.net) driver to verify that issue.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic