Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Location
    sydney
    Posts
    3

    Unhappy Unanswered: JAVA and MS SQL SERVER2000

    my database is on a MS SQL SERVER2000 and i would like to write a java from end program to aquire and update the info in the database...
    i'm totally new to this and from my recent readings discovered that i have to use JDBC. the database was written in Access.

    can anyone give me a push to start this project...
    thanx

  2. #2
    Join Date
    Dec 2002
    Posts
    2

    Re: JAVA and MS SQL SERVER2000

    Originally posted by sayoub
    my database is on a MS SQL SERVER2000 and i would like to write a java from end program to aquire and update the info in the database...
    i'm totally new to this and from my recent readings discovered that i have to use JDBC. the database was written in Access.

    can anyone give me a push to start this project...
    thanx
    Why not use JBuilder? It's good for these things.

    Also you are correct. You have to create a JDBC.ODBC source. I think that is what it's called.

  3. #3
    Join Date
    Dec 2002
    Location
    sydney
    Posts
    3

    Angry

    does jbuilder has its own JDBC? and it needs to add the driver to the CLASSPATH, but how do i do that??? i always seem to get a driver error.

  4. #4
    Join Date
    Jan 2003
    Location
    KL, Malaysia
    Posts
    38
    Originally posted by sayoub
    does jbuilder has its own JDBC? and it needs to add the driver to the CLASSPATH, but how do i do that??? i always seem to get a driver error.
    You can use sun's jdbc-odbc driver or use microsoft's jdbc driver


    sun.jdbc.odbc.JdbcOdbcDriver

    com.microsoft.jdbc.sqlserver.SQLServerDriver

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •