• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Getting [Microsoft][ODBC SQL Server Driver] Optional feature not implemented

 
Sushil Shingote
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


I am using below mentioned code to insert values in MSAccess 2000 which having table structure as mentioned below:-

Field Name Data Type

TodaysDate Date/Time
Cart ID Number
Client Name Text
Campaign Text
Team & Segment Text
Duration Number
Tape ID Text
Start Date Date/Time
End Date Date/Time
Station Text

Code:-



I got below error after implementing the above code:-

[Microsoft][ODBC SQL Server Driver]Optional feature not implemented.

Kindly help me for the same.
 
Anayonkar Shivalkar
Bartender
Posts: 1557
5
Eclipse IDE Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Welcome to CodeRanch!

Please UseCodeTags. I've added those for now.

Coming to your question - as I'm not much familiar with Access DB, can you please confirm if your query works without the program (i.e. if it is fired directly on DB)?

Also, what is your table name?
 
Sushil Shingote
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Anayonkar Shivalkar wrote:Hi,

Welcome to CodeRanch!

Please UseCodeTags. I've added those for now.

Coming to your question - as I'm not much familiar with Access DB, can you please confirm if your query works without the program (i.e. if it is fired directly on DB)?

Also, what is your table name?


Dear Anayonkar,

The table name is ""Cart ID Details".

The project is working on multiple DSN, in which I am fetching data from SQL server which is located at server computer & want to save the fetched data in MSAccess 2000.

Please Anay, help me for the same.
 
Anayonkar Shivalkar
Bartender
Posts: 1557
5
Eclipse IDE Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Sushil,

Instead of using 'quote' button, you can (and mostly should) use 'post reply' button

Coming back to your issue (as already mentioned, I'm not much aware of MS Access, but), do we have any possibility of driver jar mismatch here? E.g. version of driver jar is different that actual DB version?

It would be helpful if you could post the complete exception stack trace.

Moving the topic to JDBC forum.
 
Sushil Shingote
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear Anay,

How will I check whether that .jar mismatched or not ?

Please help.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic