f



MS Access databases

Hello,

I have been trying to read a simple MSAccess database and show
the records on screen but no success so far.
I  have created a DSN (Data Source Name) in my Win 2k box
and the connection goes ok.
But when I try to return a ResultSet using a simple SELECT statement,
("SELECT * FROM MyTable")
no records appear. Database is Ok. It is a very simple table.

I don't get *any* error message but also no records from it.

Is there anything special I need to do for accessing it?
Does anybody have a simple code for accessing MSAccess databases?
(From DSN creation till sample code)


Thanks in Advance.

Java Newbie.


0
H3li0
11/5/2003 11:07:17 PM
comp.lang.java.databases 3049 articles. 0 followers. samyaksulabh (16) is leader. Post Follow

7 Replies
958 Views

Similar Articles

[PageSpeed] 54

import java.sql.*;

public class DataBase {
    public static void main(String[] args) {
        String data = "jdbc:odbc:YahooAddrBook";  // data base friendly nam
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection conn = DriverManager.getConnection(
                data, "", "");
            Statement st = conn.createStatement();
            String q =
                "SELECT * " +
                "FROM yahoo_ab " +              // table name
                "WHERE (\"Last Name\" LIKE '"+ args[0]+"') "+
                "ORDER BY (\"First Name\")";
                System.out.println(q);
            ResultSet rec = st.executeQuery(q);
            while(rec.next()) {
                System.out.println(
                          rec.getString("First Name")     + ", "
                        + rec.getString("Last Name")      + ", "
                        + rec.getString("E-Mail Address") + ".");
            }
            st.close();
        } catch (Exception e) {
            System.out.println("Error -- " + e.toString());
            e.printStackTrace();
        }
    }
}
"H3li0" <junior_helio@hotmail.com> wrote in message
news:bobvqp$1cqqpv$1@ID-147895.news.uni-berlin.de...
> Hello,
>
> I have been trying to read a simple MSAccess database and show
> the records on screen but no success so far.
> I  have created a DSN (Data Source Name) in my Win 2k box
> and the connection goes ok.
> But when I try to return a ResultSet using a simple SELECT statement,
> ("SELECT * FROM MyTable")
> no records appear. Database is Ok. It is a very simple table.
>
> I don't get *any* error message but also no records from it.
>
> Is there anything special I need to do for accessing it?
> Does anybody have a simple code for accessing MSAccess databases?
> (From DSN creation till sample code)
>
>
> Thanks in Advance.
>
> Java Newbie.
>
>


0
nos
11/5/2003 11:14:35 PM
It works now.
Thanks a LOT !

I wonder if the process to access a SQL Server 2000 database would be the
same.

Is tehere any difference in the process? Or is it just about the DSN change?

Cheers,

Java Newbie


"nos" <nos@nospam.com> wrote in message
news:vvfqb.115975$e01.421770@attbi_s02...
> import java.sql.*;
>
> public class DataBase {
>     public static void main(String[] args) {
>         String data = "jdbc:odbc:YahooAddrBook";  // data base friendly
nam
>         try {
>             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
>             Connection conn = DriverManager.getConnection(
>                 data, "", "");
>             Statement st = conn.createStatement();
>             String q =
>                 "SELECT * " +
>                 "FROM yahoo_ab " +              // table name
>                 "WHERE (\"Last Name\" LIKE '"+ args[0]+"') "+
>                 "ORDER BY (\"First Name\")";
>                 System.out.println(q);
>             ResultSet rec = st.executeQuery(q);
>             while(rec.next()) {
>                 System.out.println(
>                           rec.getString("First Name")     + ", "
>                         + rec.getString("Last Name")      + ", "
>                         + rec.getString("E-Mail Address") + ".");
>             }
>             st.close();
>         } catch (Exception e) {
>             System.out.println("Error -- " + e.toString());
>             e.printStackTrace();
>         }
>     }
> }
> "H3li0" <junior_helio@hotmail.com> wrote in message
> news:bobvqp$1cqqpv$1@ID-147895.news.uni-berlin.de...
> > Hello,
> >
> > I have been trying to read a simple MSAccess database and show
> > the records on screen but no success so far.
> > I  have created a DSN (Data Source Name) in my Win 2k box
> > and the connection goes ok.
> > But when I try to return a ResultSet using a simple SELECT statement,
> > ("SELECT * FROM MyTable")
> > no records appear. Database is Ok. It is a very simple table.
> >
> > I don't get *any* error message but also no records from it.
> >
> > Is there anything special I need to do for accessing it?
> > Does anybody have a simple code for accessing MSAccess databases?
> > (From DSN creation till sample code)
> >
> >
> > Thanks in Advance.
> >
> > Java Newbie.
> >
> >
>
>


0
H3li0
11/6/2003 9:23:36 AM
"H3li0" ...
> It works now.
> Thanks a LOT !
>
> I wonder if the process to access a SQL Server 2000
> database would be the same.
>
> Is tehere any difference in the process?
> Or is it just about the DSN change?

It's one way to do it, to create a DSN for the SQL-Server, and change it in
your code.

It'll work, but ODBC gives poor performance, so it would be recommended that
you instead use a JDBC Type 4 driver for SQL Server:

   http://tinyurl.com/twlb

Put the jar-files in your classpath and change the drivername to:

  com.microsoft.jdbc.sqlserver.SQLServerDriver

.... and the url (what you called "data") to:

  jdbc:microsoft:sqlserver://servername:1433

....where you change "servername" for the actual server SQL-Server runs on.
Possibly you have to change the portnumber as well, if i is configured to
listen on another port (check with your DBA).

// Bjorn A



0
Bjorn
11/6/2003 3:27:51 PM
Correct that it is only one way to do it.
I would have liked to have used JDBC, but didn't
know how at the time and only ODBC is
available on my pc.

If anyone knows of a JDBC driver for MS Access
or MS Works please let me know.
Phil....

"Bjorn Abelli" <DoNotSpam.bjorn_abelli@hotmail.com> wrote in message
news:bodp9n$1d5icj$1@ID-73292.news.uni-berlin.de...
> "H3li0" ...
> > It works now.
> > Thanks a LOT !
> >
> > I wonder if the process to access a SQL Server 2000
> > database would be the same.
> >
> > Is tehere any difference in the process?
> > Or is it just about the DSN change?
>
> It's one way to do it, to create a DSN for the SQL-Server, and change it
in
> your code.
>
> It'll work, but ODBC gives poor performance, so it would be recommended
that
> you instead use a JDBC Type 4 driver for SQL Server:
>
>    http://tinyurl.com/twlb
>
> Put the jar-files in your classpath and change the drivername to:
>
>   com.microsoft.jdbc.sqlserver.SQLServerDriver
>
> ... and the url (what you called "data") to:
>
>   jdbc:microsoft:sqlserver://servername:1433
>
> ...where you change "servername" for the actual server SQL-Server runs on.
> Possibly you have to change the portnumber as well, if i is configured to
> listen on another port (check with your DBA).
>
> // Bjorn A
>
>
>


0
nos
11/6/2003 7:04:21 PM
"nos" wrote...
> Correct that it is only one way to do it.
> I would have liked to have used JDBC,
> but didn't know how at the time and only ODBC is
> available on my pc.

Just to clarify things, you *are* using JDBC in your example, but you're
using the internal JDBC-ODBC-bridge for access to Access...

> If anyone knows of a JDBC driver for MS Access
> or MS Works please let me know.

My last comment was on the question on how to change the connection to
SQL-Server instead of MS Access, and in the case of SQL-server i pointed to
a place where the JDBC-driver can be downloaded.

   http://tinyurl.com/twlb

AFAIK there exists no JDBC-driver of type 4 (native access) for MS Access.
There are some drivers for Access of type 2 and 3 (additional software
besides the driver has to be installed) listed on Sun's site:

   http://tinyurl.com/qhu4

NB! The list says that BCS has drivers of type 4, but that's only for SQL
Server, not MS Access...

// Bjorn A



0
Bjorn
11/6/2003 11:44:33 PM
thanks i'll try it out

"Bjorn Abelli" <DoNotSpam.bjorn_abelli@hotmail.com> wrote in message
news:boemd1$1ca0dq$1@ID-73292.news.uni-berlin.de...
>
> "nos" wrote...
> > Correct that it is only one way to do it.
> > I would have liked to have used JDBC,
> > but didn't know how at the time and only ODBC is
> > available on my pc.
>
> Just to clarify things, you *are* using JDBC in your example, but you're
> using the internal JDBC-ODBC-bridge for access to Access...
>
> > If anyone knows of a JDBC driver for MS Access
> > or MS Works please let me know.
>
> My last comment was on the question on how to change the connection to
> SQL-Server instead of MS Access, and in the case of SQL-server i pointed
to
> a place where the JDBC-driver can be downloaded.
>
>    http://tinyurl.com/twlb
>
> AFAIK there exists no JDBC-driver of type 4 (native access) for MS Access.
> There are some drivers for Access of type 2 and 3 (additional software
> besides the driver has to be installed) listed on Sun's site:
>
>    http://tinyurl.com/qhu4
>
> NB! The list says that BCS has drivers of type 4, but that's only for SQL
> Server, not MS Access...
>
> // Bjorn A
>
>
>


0
nos
11/6/2003 11:47:03 PM
"nos" ...
> thanks i'll try it out

Well, don't be too hasty...

If your application functions well enough against MS Access with the
JDBC-ODBC-bridge, it could very well be a turn to the worse to try another
driver (as it AFAIK doesn't exist any type 4 drivers for MS Access).

As I said, you already *are* using JDBC, but if you change to another
database, such as SQL Server, you should change from the JDBC-ODBC-bridge to
another driver.

HTH

// Bjorn A


0
Bjorn
11/6/2003 11:55:28 PM
Reply:

Similar Artilces:

DataBase DataBase DataBase DataBase
DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate: 2000/Records/Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Easy to Learn (Typically 30 Seconds) Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). Easy Paypal Online Ordering. See Site Below. http://www.vehiclerepair.org/dbPro/dbpro.html Scott: #DataBase...

DataBase DataBase DataBase DataBase
DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate: 2000/Records/Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Easy to Learn (Typically 30 Seconds) Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). Easy Paypal Online Ordering. See Site Below. http://www.vehiclerepair.org/dbPro/dbpro.html ...

Database Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Em...

Database Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Em...

Database Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). http://www.vehiclerepair.org/dbPro/dbpro.html ...

Database Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Em...

Database Database Database Database Software Cheap
Database Database Database Database Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). http://w...

Database Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Em...

a database, is a database, is a err database
How many times can we see the same request from someone who wants to access data from a 'pick' database through what has come to be 'standard' practices (odbc, oledb) and still get the same old sloppy ' buy this proprietary utility (and above all, my services)' answer. I think most of these pick flavors should have some sort of layer (by now!) to handle this; If someone needs to do this, the service is really 'education' i.e to show them how. Lets cut the shit now and stop with this tired and silly BS and sad marketing schlock. Regards, -Jim Jim wrote: > How many times can we see the same request from someone who wants to > access data from a 'pick' database through what has come to be > 'standard' practices (odbc, oledb) > and still get the same old sloppy ' buy this proprietary utility (and > above all, my services)' answer. I think most of these pick flavors > should have some sort of layer (by now!) to handle this; If someone > needs to do this, the service is really 'education' i.e to show them > how. Lets cut the shit now and stop with this tired and silly BS and > sad marketing schlock. > > Regards, > > -Jim Jim who? I wonder? What is this? An attack on capitalism? Providing services for those who perhaps lack the time, skill, or knowledge to perform such tasks is hardly a crime. Maybe "standard" odbc and...

Java with MS Access 2000 Database
Hi All I am trying to connect with MS Access database but faild. Please let me know what are the alternatives, so that I can connect to an Access Database. Thanks in Advance Zee What are you failing with? Make sure you have your data source/DB setup via control panel. The following pice of code shows how I connect to a ms access database called myDB. ------------------ // Load the driver class Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // Define the data source for the driver String sourceURL = "jdbc:odbc:myDB"; // Create a connection thr...

MS Access database with a file extension of .mde
Good day: Can you kindly assist me in opening a MS Access database with a file extension of .mde? I get an error message stating "This database is in an unrecognized format". Any help is greatfull. TIA This usually indicates an attempt to open an Access 2000 database in an earlier version. -- MichKa [MS] NLS Collation/Locale/Keyboard Development Globalization Infrastructure and Font Technologies This posting is provided "AS IS" with no warranties, and confers no rights. "mary" <chloemelmom@yahoo.com> wrote in message news:a0a64947.0311151242.4df0c...

How to reset or disconnect all conections to an MS Access database if the database is hung up?
Hi, All: &nbsp; Sometime I do not knwo why my database in local C drive is locked. If I restart the LabVIEW software, it works fine. Is there a way to disconnect all connections before you make a new connection? I remember I used this function a couple of years ago but I could not find the function in new LabVIEW database connectivity tool kit. I am using LabVIEW 8.0.1. Thanks. &nbsp; Jim Is it DB Close Connection? You VI should contain one of these. <img src="http://forums.ni.com/attachments/ni/170/194552/1/DB%20Close%20Connection.jpg"> DavidMessage Edited by David C...

Database Database Database Database Software Cheap #2
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Em...

Create MS/ACCESS database app for non-ms/access users
Is it possible to create an MS/ACCESS database application and package it for users who do not have MS/ACCESS loaded in their PCs? I was told that this is possible, but I don't know what software is needed. Do you know? If so, please answer this post. Thanks. SueB *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Per Sue Bricker: >Is it possible to create an MS/ACCESS database application and package >it for users who do not have MS/ACCESS loaded in their PCs? > >I was told that this is possible, but...

MS Access Script to import data from external mde database to mdb database
Hi, Does anyone know of a way I can write a script that imports a table from a particular .mde file? I don't seen any obvious way to do it as a macro. Any suggestions if it can be done as a macro or as a written module? My ultimate goal is to have script that clears info out of 1 table in an .mdb file, imports an identically structured table from a .mde file, runs an append query I have in place to copy the data from the imported table to the table in my.mbd file, and then delete the imported table. Any help that could be provided would be greatly appreciated. Best wishes, George Hadl...

SN#10373 Tutorial on Java[TM] DataBase Connectivity API Database Access
SYSTEM NEWS FOR SUN USERS Vol 65 Issue 2 2003-07-07 Article 10373 from section "Java Technology" "Keeping Simple Things Simple" The tutorial on Java[TM] DataBase Connectivity (JDBC[TM]) API Database Access by Maydene Fisher covers the basics of the API features of version 2.0. Fisher states, "The JDBC API was designed to keep simple things simple. This means that the JDBC API makes everyday database tasks, like simple SELECT statements, very easy." This trail (section in the tutorial) is divided i...

Open Access Database Form from within Access database
I have included the following code to open an Access database form from within an exsisting Access database. But when I run the code, it appears that it opens the database because in windows explorer I can see the database has the .ldb file extension. So it appears that it's open, but I can't see the database or the form that I've tried to open. What am I doing wrong. The following is the code: 'This is in the declaration part of the module Dim appAccess As Access.Application ' Initialize string to database path. Const strConPathToSamples = "C:\Documents a...

how do you update a java.sql.date type in an ms access database
when i update a row in an access database the date field does not update to the correct date it brings up some funny date which i dont know where it comes from. Below is the method i use to update. maybe the date types are not compatable? thanks in advance, public static void bookIN(int custID, int rNumber,java.sql.Date bkInDate ){ try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String filename = "hotelDB.mdb"; String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; database+=...

Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Em...

Java access to Microsoft Access database through Samba
Hi, I need to access from an JSP application in a Linux server to a Microsoft Access database (only read) that is in another Windows server (only accepts users in its domain, that are different from Linux server users) I have configured Samba so that I can access to the database file. When I access through the folder navigator of Linux it requests me user, domain and password and access without problems. I do not know, how to access from a Java/JSP application, it's possible to do it? what driver I must use? it is necessary to configure Samaba to have permission...

Access MS-ACCESS database on server from client????
I m currently developing a java based application and want to know how can i make client access database located on the server? "HeMan_Speaks" <Lunar20092010@gmail.com> wrote in message news:d71ce567-0434-48b8-b1d2-bb191706ab45@w8g2000prd.googlegroups.com... >I m currently developing a java based application and want to know how > can i make client access database located on the server? I think you're going to have to expand a little bit more in your question here, as is not 100% quite clear what you're trying to do. You might want to make a little bit of a d...

MATLAB command to access MS Access database
Hi! Is there a MATLAB command which gives access to a .mdb MS Access database or do I need a special driver? Thanks, Andree Hi Andree Ellert, you can use activeXcontrol to interact with MS-Access database. access = actxserver('Access.Application'); returns the handle for Access. set(access, 'Visible', 1); will show the opened Access window. use get(access) and set(access) commands to find the methods available to call. -Vadivelu M =========== http://www.mathworks.com/access/helpdesk/help/toolbox/database/datatool.shtml "Andree Ellert" <ellert@gmx.net////...

Java access to Microsoft Access database through Samba
Hi, I need to access from an JSP application in a Linux server to a Microsoft Access database (only read) that is in another Windows server (only accepts users in its domain, that are different from Linux server users) I have configured Samba so that I can access to the database file. When I access through the folder navigator of Linux it requests me user, domain and password and access without problems. I do not know, how to access from a Java/JSP application, it's possible to do it? what driver I must use? it is necessary to configure Samaba to have permission some user in parti...

request for explanation on access an database in ms access
This is the code that I found on the internet for accessing an ms access database: import java.sql.*; class Test { public static void main(String[] args) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // set this to a MS Access DB you have on your machine String filename = "d:/java/mdbTEST.mdb"; String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; database+= filename.trim() + ";DriverID=22;READONLY=true}"; // add on to the end // now we can get the connection from the DriverManager Connection con = DriverManager.getConnection( database ,"",""); } catch (Exception e) { System.out.println("Error: " + e); } } } What I don't understand is the declaration of database. What I did was putting the database in the same dir as the sourcecode and use "jdbc:odbc:CafeJolt.mdb". But this doesn't work. And the above code does, why is that??? Actually it's not Java question. It's ODBC question. You have to have ODBC connection. Depending of Windows it's usually something like this (for my Windows 2000): Start->Sttings->Control Panel->Administartive Tools->Data Sources(ODBC)-> User DSN -> [Add]-> Driver to Microsoft Access(*.mdb) === And here, finally you can choose file name. ...

Java access to Microsoft Access database through Samba
Hi, I need to access from an JSP application in a Linux server to a Microsoft Access database (only read) that is in another Windows server (only accepts users in its domain, that are different from Linux server users) I have configured Samba so that I can access to the database file. When I access through the folder navigator of Linux it requests me user, domain and password and access without problems. I do not know, how to access from a Java/JSP application, it's possible to do it? what driver I must use? it is necessary to configure Samaba to have permission some user in particular (tomcat, apache...) Thanks! JC wrote: > Hi, > > I need to access from an JSP application in a Linux server to a > Microsoft Access database (only read) that is in another Windows server > (only accepts users in its domain, that are different from Linux server > users) > > I have configured Samba so that I can access to the database file. When > I access through the folder navigator of Linux it requests me user, > domain and password and access without problems. > > I do not know, how to access from a Java/JSP application, it's possible > to do it? what driver I must use? it is necessary to configure Samaba > to have permission some user in particular (tomcat, apache...) > > Thanks! I have never tried it, but AFAIK, you would need ODBC drivers on linux, as that is the origin of your JVM. MS Acce...

Web resources about - MS Access databases - comp.lang.java.databases

Database - Wikipedia, the free encyclopedia
... requiring information. For example, modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies. Database ...

Database - Wikipedia, the free encyclopedia
A database is an organized collection of data . The data are typically organized to model aspects of reality in a way that supports processes ...

Oracle: Fear Not, ’12c’ Database Nearing Its Breakout, Says Credit Suisse
... from cloud computing applications in 2016, along with the adoption by customers of the its “ 12c ” version of its flagship relational database ...

Enterprises want to run databases in containers
More than three out of four IT decision makers are interested in running stateful applications like databases within containers, according to ...

NFL mock draft database 2016: Tracking Giants picks from around the Internet
Let's keep track of mock drafts from around the Internet as the 2016 NFL Draft approaches. Can we find a consensus for the New York Giants?

Consumer Group Sues DOT For Failure To Create Searchable Database Of Safety Defects
... about safety defects. One safety group says this hasn’t happened, and is suing DOT Secretary Anthony Foxx in an effort to make this database ...

TSA Will Finally Be Given Access To Counterterrorism Database To Screen Airport Workers
TSA Will Finally Be Given Access To Counterterrorism Database To Screen Airport Workers

U.S. Attorney Suggests Password Cardinals Used To Access Astros Scouting Database Was “Eckstein123"
... scouting director Christopher Correa plead guilty to five counts of unauthorized access to a computer for hacking the Houston Astros database. ...

Blinkbox Music's user database was just sold to... JD Sports
Of Tesco's three ailing digital Blinkbox services, its e-book store appeared to be the only one that would go gently into that good night. Eventually, ...

DB Networks Launches Real-Time Database Security Sensor
By integrating this sensor into their products, security OEMs provide their customers with more usage detail and metrics from data-tier cyber ...

Resources last updated: 3/3/2016 2:15:57 AM