Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

connecting with MS access database using jbuilder 2005 1

Status
Not open for further replies.

SH4F33

Programmer
Apr 1, 2005
58
MU
Hello everybody. I'm new to java and I'm using borland jbuilder 2005. Ive got 3 forms that will connect to a database and the borland help suggests that it will b preferable to use a datamodule. To add a datamodule to my project, I did the following steps File > New > Datamodule.
I got the "Data Modeler" window. Ive selected "Database > Add connection URL". And Ive got the "New URL" window (Ive created a DSN connection for my MS Access database named "bboard").Ive selected "sun.jdbc.odbc.JdbcOdbcDriver" as driver and Ive clicked the button next to the URL field.Now Ive got the "ODBC Sources" window, Ive selected "jdbc:eek:dbc:MS Access Database",I know it wont connect coz I havent specified the DSN name anywhere. So where should I specify this?
Thanks a lot in advance.
 
I believe that you need to use "jdbc:eek:dbc:DSN" as your URL, substituting your DSN name in place of DSN

Tim
---------------------------
"Your morbid fear of losing,
destroys the lives you're using." - Ozzy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top