aspose file tools*
The moose likes JDBC and the fly likes MS Access Web Connection using JDBC/Applet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MS Access Web Connection using JDBC/Applet" Watch "MS Access Web Connection using JDBC/Applet" New topic
Author

MS Access Web Connection using JDBC/Applet

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Hi everyone,
I'm new to Java and this forum.
I need help in connecting my applet to an MS Access database. Both the applet and database are located with my web host (Interland.com). The following is the error message that I get:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. Connection Error
I think I have a problem with not having the jdbc/odbc bridge driver in my website's root directory. If this is the case, can someone please tell me what files I need to upload into my web host?
sasank manohar
Ranch Hand

Joined: Feb 14, 2008
Posts: 186

I am also trying to access a database from Microsoft Access using Servlets and I am getting the same error

SQLException caught: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Please some one help us with this problem..
thanks
sdev


"SCJP5 | SCWCD5| DEVELOPER"
sasank manohar
Ranch Hand

Joined: Feb 14, 2008
Posts: 186
Hi mofius

I got my problem solved, I downloaded JDBC API3.0 and my program just worked fine.
It may help you...
thanks
sdev
Ray Marsh
Ranch Hand

Joined: Jan 12, 2000
Posts: 458
Mofius and sdev... please see our policy regarding registering.
Thanks,
"clkanth", take a look at this link: http://www.javaranch.com/ubb/Forum10/HTML/000180.html


Anxiety does not empty tomorrow of its sorrows, but only empties today of its strength. – Charles Spurgeon
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
sdev,
I just recently registered as "Jeff Jadi"...previously "Mofius"..
My problem is that I don't have access to the server that my website is running on.. So, I'm unable to install the drivers that my applet needs to access in order to gain database connectivity... Do you know of a way to get around this problem?... My site is currently hosted by Interland.com and they do not have Java JDK installed on their servers...
Has anyone successfully used an applet to connect to a database on their website that is hosted by a third party?
Thanks sdev,
and thanks to those that thought about my question..

------------------
JJ
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MS Access Web Connection using JDBC/Applet