Question

can any one tell me how to do java sql or java access
connectivity??? i've tried alot but nothing is working please help me with that....

Answer 1

check the following class

Answer 2

Nahin bhai, mujhe to java kuch pata nahin hai. sorry.

Answer 3

ok yaar no problem but thanks anyway

Answer 4

do u know anyone else who can help me with this...?

Answer 5

In SQL, strings are single quoted. That will help your insert statement greatly. The compiler can't tell where strings begin and end when you haven't escaped the inner double quotes.

Answer 6

How is the problem presenting itself? What kind of error are you getting?

Can you get a basic "SELECT * FROM ..." to work with an existing database?

Answer 7

dude nothing is working not even Select * from.... at every function program throws an exception ... i dont know what wrong with it.

Answer 8

if you can't even get select to work, you probably don't have a connection to the database. What database system are you using?

Answer 9

try this first:
http://docs.oracle.com/javase/tutorial/jdbc/basics/gettingstarted.html

Answer 10

Ms-sql and using JcreaterPro as java IDE.

Answer 11

ok what to download from the link

Answer 12

just read the tutorial and do what they tell you to do (download what they tell you to download). Just use JavaDB like they tell you to. Once you are more comfortable and understand the basics, you should be able to adapt it to your particular database.

It's probably best if you start here: http://docs.oracle.com/javase/tutorial/jdbc/index.html

Answer 13

ok thanks its a great help

Answer 14

I guess your using java to access MS database...I noticed that you misspelled the string parameter for Class.forName("sun.jdbc.odbc.jdcodcDriver") ...It should be Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").....By the way you should define user dns to work with odbc datasource...

Answer 15

ok... thank i'll check it