Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

prepared Statement ODBC error MSAccess

 
Brett Swift
Ranch Hand
Posts: 61
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, the following is my code that I am using to access an Access2000 DB on Windows2000 from a VisualAge environment. When I step through the code I get an error at this line:
pstmt.setFloat(4,carX.getPrice());
it doesn't even get to the executeUpdate line, because it throws this error:
[Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented.
Is there a problem in my syntax where I am trying to set the Float? I really need to find a solution to this....as you can see there is a lot of commented code that also gives other errors...the prepared statement was used later to solve other problems.

[ August 16, 2002: Message edited by: Thomas Paul ]
 
Thomas Paul
mister krabs
Ranch Hand
Posts: 13974
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving this to the JDBC forum
 
Gregg Bolinger
Ranch Hand
Posts: 15304
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sounds to me like your current ODBC Driver does not support a feature you are trying to use with JDBC. You might need to update your ODBC Driver, or since it did say optional, find another solution that is supported.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic