access an mdb file with out server?
[155 byte] By [wolfbane10a] at [2007-10-2 8:32:43] 
Is it possible for Java to access an mdb file without a server installed on the machine? If so, what are the limitations? Can you do insert queries?
If you're asking about MS Access database files, no server exists for them anyway. So there is no such question.And yes, you can do insert queries.
DrClapa at 2007-7-16 22:33:54 >
My mistake, I meant to say an mdf file. How can I access and modify an mdf file without MS Server installed on the machine?
wolfbane10a at 2007-7-16 22:33:54 >
> My mistake, I meant to say an mdf file. How can I
> access and modify an mdf file without MS Server
> installed on the machine?
mdf = one of the MS SQL Server data files.
Why would you want to do that? The SQL Server has to be running somewhere anyways or there is no point in the files. And it would probably be a really bad idea to try to modify them without going through a SQL Server.
But if you want to spend a lot of time (probably at least 6 months) figuring out the internal format and you want to tie yourself forever to one version of SQL Server (and probably one schema layout) then you could just access it like a file.
jschella at 2007-7-16 22:33:54 >
OK in that case let me just say what I am trying to achieve. I have an app that uses a database. I was wondering if there is anyway to use the application and the database file,but without the server running? maybe with MySQL? The goal is to be able to copy the software and the database file to another pc and have it work. But I am guessing that is not realistically possible?
wolfbane10a at 2007-7-16 22:33:54 >
> maybe with MySQL?
Definitely not.
> The goal is to be able to copy the
> software and the database file to another pc and have
> it work. But I am guessing that is not realistically
> possible?
Either you need the database server or you have to write something to interpret the format of the file.
jschella at 2007-7-16 22:33:54 >
Of course with more information it might be possible to describe a usuable solution.For instance if you are trying to create a traveling salesman type distributed system then there are solutions for that.
jschella at 2007-7-16 22:33:55 >
Database Connectivity New Topic
- Problem with inserting into the table
- Is it possible to create greeting card,so that added as plain text in mails
- How to connect database using java script
- Listeners in JDBC
- Only Restarting the Weblogic Server will invoke the Stored Procedure?
- Connecting to mysql server remotely
- problem in connection with sql server
- how to optimise search in database?.
Database Connectivity Hot Topic
- OS for a server machine
- Transaction management
- I am unable to connect to oracle using thin driver
- Cannot create datasource to MYSQL in tomcat 5.5.X
- mySQL driver issue
- I my JDBC calls are very slow pls suggest me for optimization
- A question relating to MySQl Database
- how do i retrieve the word document format
Database Connectivity
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding